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
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
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.