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
No thanks.
Hello,
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?