Hello Infragistics team,
I am trying to use the Excel Library. I have an excel spreadsheet of more than 200,000 rows. It takes a very long time to load the excel file. Below is the code using the Microsoft.Office.Interop.Excel library to retrieve the column names in an excel worksheet:
workbook = excelApp.Workbooks.Open(fileName); mWorksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Sheets[1];
range = mWorksheet.UsedRange;
for (int column = 1; column <= range.Columns.Count; column++) { MTOColumns.Add((range.Cells[1, column]).Value.ToString()); }
how to achieve the same using the Infragistics library? Is there a way to run Linq queries against the loaded worksheet? How to improve the performance of working with large files?
Thank you very much
Hello,
You could load an excel file by using the following code:
Workbook book = Workbook.Load("filename.xlsx");
You should have the Infragistics.Documents.Excel assembly in order to use the above class.
I tried to load an excel file with 200k rows and it loaded for 10 seconds on my machine. What actions exactly do you want to perform with the file?
I am checking about the progress of this issue. Please let me know If you need any further assistance on this.
This is currently not possible with our Excel engine, do you want me to log a new product idea regarding this for you?
No thanks.