Hello. I have used Aspose in the past to create XLS, PDF and PowerPoint files. We have a new requirement for my application to add subtotals into a file which is in .CSV format (it could be in .TXT is necessary).
After a lot of whiteboarding, we have decided to try to read the file with Aspose, insert the subtotals programatically and then then write out another .CSV file.
So, it is technically possible to read in a .CSV or .TXT file and output a .CSV?
Thanks
Lisa
Hi,
Thank you for considering Aspose.
Yes, Aspose.Cells provides the support for .CSV files. Please see the following code which will help you get better understanding of how you can open and save a CSV file using Aspose.Cells.
Sample Code:
//Creating a Workbook object
Workbook workbook = new Workbook();
//Calling Open method of Workbook object to open an Excel file using its file path
workbook.Open("C:\\input.csv",FileFormatType.CSV);
//You can use your desired code here for process the workbook
workbook.Save("C:\\output.csv", FileFormatType.CSV);
Also please see the following link for more details on different file formats supported by Aspose.Cells