Hi All,
I am not sure if this would be the correct place for the below request.
I am currently using Infragistics 10.3 and wanted to know if there is a way where I can save an Infragistics workbook to a tab delimited text file. As the data content in my excel is too high I am not looking for opening the file , reading the data in a stream and then writing it down to the new file. Microsoft Excel has an option of saving a workbook as Tab delimited text file but I can’t use the same as the machine would not have the Excel Interop.
Thanks and Regards,
Ritesh
Thanks Mike,
I would upgrade to 11.1 as per your suggestion.
Thanks Rob,
I am looking forward to save records from files having 400,000 rows and around 25 columns. The file currently for such files are around 27MB. Do let me know if there is a way which can reduce my memory usage.
Ritesh, this may help...
http://geekswithblogs.net/QuandaryPhase/archive/2009/01/29/asp.net-downloading-a-datatable-in-csv-format.aspx
If you want to keep your memory footprint low, you can adjust this to use a SQLDataReader instead of a DataTable.
-Rob
The Excel library does not currently support saving to a tab-delimited file. You can submit a feature request for this. Also, if it is the Excel library that is having the problem with a large amount of data you are saving, I suggest you upgrade to 11.1. There were some major memory improvements in the Excel library starting in that version. Performance was improved as well.