Hello,
I wanted to document an exception I am seeing when using the Excel library to read a specific custom cell format.
If an Excel cell has the following:
Then reading…
Hello
I've got the problem to get defined
NamedReferences
to apply as "validation dropdown"-lists into another worksheet.
I tried ... ".ApplyFormula("=Name_User");
But when i open the excel workbook i could only found…
I am importing from an Excelspreadsheet, but when I import from a formula field I Get {#Name?}
From other posts I gather that importing the results from a formula is now supported...
The formula is: =IF(C9="","",VLOOKUP(C9,'Drop down lists'!G:I,3…
Hi,
I am using the Workbook.Load function to load up a large spreadsheet containing 100000 rows. This operation is taking a very long time and it appears that the entire contents of the sheet is being read into memory. Is there a more efficient…
I got the following error while i was trying to load Excel file stream. I am using Infragistics35.WebUI.Excel.v9.2. Version=9.2.20092.2056.
I can open the file from MS Excel.
Index was out of range. It must be non-negative and less than the size of…
We want to read an Excel template, fill it with data and then write it back to another Excel file. In the generated Excel file the colors differ from the original color . The code basically looks like this:
Workbook w = Workbook.Load("File1.xlsx");…