Posted 8 September 2017, 1:51 pm EST
I'm testing with the Windows Spread control the import functionality from Excel.
When I copy same values from Excel and paste them into the spread control, it takes a lot of time.
The Excel file is in attachment. When I open it with the code openExcel(..,..) it goes very fast but then I cannot change the backgroundcolor etc...
When I save the Excel as csv, and use the code
fpSpread1.ActiveSheet.LoadTextFile(openCSV.FileName, false, FarPoint.Win.Spread.Model.IncludeHeaders.None, "\n", ";", "");
it also goes very slow!
Is there a solution? It is only a file of 16kb!