Does the UltraSpreadsheet control have any mechanism to load a CSV file and/or convert it to an Excel file?
Hello Richard,
The UltraSpreadsheet currently only has the ability to use the Infragistics Excel Engine to display an Excel Workbook as its data source, but unfortunately, our Excel Engine does not have the ability to save or load from CSV as discussed on the following forum thread. This thread is for WPF, but the functionality is the same for Windows Forms. If you would like to see this ability added to the Infragistics Excel Engine, I would recommend suggesting a new product idea for it at our Windows Forms Ideas Site.
With the above said, creating a Workbook, or rather a Worksheet inside of the Workbook.Worksheets collection is much like creating a DataTable. The Worksheet object has a set of WorksheetRow objects which have WorksheetCell objects that you can set the values of. After some research, I found a generic parser for CSV files on code-project at this article that allows you to load a DataTable at this topic. Perhaps this would help you?
Please let me know if you have any other questions or concerns on this matter.