How to export grid to csv ( comma separated value).
I was thinking that it might be possible to export the grid to an Excel Workbook then use the Excel object to write the CSV file, but the save method in the Infragistics.Excel.Workbook class doesn't let you specify any alternative file formats.
Is there a way of doing this in code (that's less effort than writing code to create the csv file manually)?
John.
Hi John,
Not with the Infragistics WorkBook. You could, of course, use the Microsoft Office Interop assemblies to create an instance of Excel on the machine and I beleive you should be able to save to any format you want. Although, this would require that Excel be installed on the machine. And I'm not really an expert on the Excel object model, so you'd probably need to check with Microsoft to see if / how that can be done.