We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Creating a .CSV file

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

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/opening-files.html


Thank You & Best Regards,