This is my code snippet for comparing 2 excel files. I call this function from my QTP scripts. I get this error quite often which causes my test script to fail. Any pointers will be appreciated. Set objExcel = CreateObject("Excel.Application") objExcel.Application.Visible = False objExcel.DisplayAlerts = False Set objWorkbook1= objExcel...
I have a problem while pasting my contents (or text) generated by Java code into excel. The problem is that my Java code generates a String with multiple lines, i.e. with line breaks (\n) included. When I try to copy this content and paste it into an Excel file, I am getting a multiline text with a square box symbol. I came to know tha...
i need to show a value in excel cell like in 12.3% in the cell.but it should be able convert into a number.by default it is considering as a text.But i want it as a number. if any body overcome this problem.please let me know. ...
I am working on a one to many query for an assets database. Here is some sample data Server Name Application Primary_User Server1 SQL DBA Server1 Citrix IT Server1 Oracle DBA Server2 Sharepoint Web Server3 SQL ...
Is there a way to add rows from a DataTable to a Excel spreadsheet without interating through a SQL Insert Statement as so? Are there any alternative methods? foreach (DataRow drow in DataTable DT) { cmd.CommandText = "INSERT INTO [LHOME$]([Date], [Owner], [MAKE], [BUY], [OVERAGE], [SUM]) " + "VALUES(" + "'" + drr.ItemArray[0].ToStri...
Hi! Is there a way to upload an Excel file and save its content to Sql Server directly? thanks!! EDITED: I don't want to save it as binary. I want to read its contend and save them to DB, each Excel column content into the DB table column and so on... ...
Hi, Say you had an Excel file containing a column filled with words, and you'd like to allow the user to copy the cells from that excel and paste them inside something like a textbox (we're talking ASP.NET 3.5). What would you do? (Any other control would be fine, I just need something the code-behind can later on read from into a db....
After running a model in fortran (95) I end up with some result arrays (and one result matrix). I'd like to move these into excel for reporting purposes. What's the easiest way to do this? ...
Hello: I am having problems opening an existing Excel file with Tcl Tk. I am able to open an existing MS Word file with no problems. The code that I am using is as follows, also my test application has "package require tcom" included: proc OpenFile {} { #Path to file set app [::tcom::ref getobject "C:\\Users\\Me\\Desktop\\Test.doc"] ...
I want to create excel sheet from asp.net application using C# language. please reply me how to create it and also if having source. I don't know how to create it. Also I want drop down list in one of column. how we can do this. Please reply me its urgent.... Regards, Girish ...
Hi to All, I am using the ExcelPackage dll to creating the excel from the .net application. I want to add drop down list in one of column of Excel sheet. How to add it???? Also I want to do some formatting changes to the cell values. Please reply ......... Regards, Girish ...
I'm unable to find the correct DataType for inserting into EXCEL 97-2003 format. I'm able to insert but when veiwing the Excel 97-2003 document every column is coming up with Number saved as text. Even when inserting Double from C# Excel still recognizing it as numbers saved as text and asks the viewer to convert to number. Any help w...
Hi! I'm trying to build an Excel macro that will allow me to do the following: I have two excel sheets. I want the macro to match all the values in Sheet1, col A against cell A1 in Sheet2. If it matches, copy cell Dx from Sheet1 to cell D1 in Sheet2, if it doesn't just move on to cell A2 in Sheet2 and do the same, but copy cell Dx fro...
Hi to All, I am creating a excel sheet from tempalte excel sheet. I have a code try { FileInfo newFile = new FileInfo(@"D:\ExcelFromTemplate.xlsx"); FileInfo template = new FileInfo(@"D:\template.xlsx"); using (ExcelPackage xlPackage = new ExcelPackage(newFile,template)) { ExcelWorks...
while writing an formula for data in a excel cell if an excel cell contains an integer we can use the statement if (cell.value > 100 ) but when the excel cell contains a time duration in the format min:sec and we have to compare value greater than 3 minutes duration how to write the statement. if (cell.value > 03:00 ) is this stateme...
while writing an algorithm dealing with excel data if we want to compare each cell in a row we write foreach row foreach cell in a row jf ( cell.value > 100 ) but if we dont want to compare each cell in the row but only the cells of a particular collumn then do we write like this ? foreach row if ( particular_collumn.cell.valu...
hello, I am trying to do a simple shared database for a small workgroup of people, who use Excel for their data. I am thinking SQLite, because I don't really want to go server, as there are only 5 users and they're all local, and the database is very low intensity. What's the best tool for accessing SQLite via Excel? Thanks. ...
i have a list 1 column and 100 rows each with a number the number on each row may not be unique i need to output the unique list of numbers sorted according to their rank , which is less if the number of its repetitions is more. least ranked number i.e 1 is on the top now here is how i am planning to solve this problem first i want to...
I am using functionality that creates an Excel spreadsheet in my application. It is achieved using the ExcelPackage DLL or the Microsoft Excel COM DLL. I want something to hold hyperlink collections in a cell. Is there is any way to achieve this? ...
Hi all, We would like to export a view of a custom SharePoint list to Excel on a repeatable basis, and with some minor formatting. I have made a .iqy file by using Actions/Export to Spreadsheet from the view menu, and then uploaded this .iqy file back into SharePoint. When users click on it, it does bring up the data in Excel - but wit...