Convert Excel to CSV,TSV and Txt
Saving Workbook to Text or CSV Format
Sometimes, you want to convert or save a workbook with multiple worksheets into text format. For text formats (for example TXT, TabDelim, CSV, etc.), by default both Microsoft Excel and Aspose.Cells save the contents of the active worksheet only.
The following code example explains how to save an entire workbook into text format. Load the source workbook which could be any Microsoft Excel or OpenOffice spreadsheet file (so XLS, XLSX, XLSM, XLSB, ODS and so on) with any number of worksheets.
When the code is executed, it converts the data of all sheets in the workbook to the TXT format.
You can modify the same example to save your file to CSV. By default, TxtSaveOptions.Separator is comma, so do not specify a separator if saving to CSV format.
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Load your source workbook | |
| Workbook workbook = new Workbook(dataDir + "book1.xls"); | |
| // Text save options. You can use any type of separator | |
| TxtSaveOptions opts = new TxtSaveOptions(); | |
| opts.Separator = '\t'; | |
| opts.ExportAllSheets = true; | |
| // Save entire workbook data into file | |
| workbook.Save(dataDir + "out.txt", opts); |
Saving Text Files with Custom Separator
Text files contain spreadsheet data without formatting. The file is a kind of plain text file that can have some customized delimiters between its data.
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| string filePath = dataDir + "Book1.xlsx"; | |
| // Create a Workbook object and opening the file from its path | |
| Workbook wb = new Workbook(filePath); | |
| // Instantiate Text File's Save Options | |
| TxtSaveOptions options = new TxtSaveOptions(); | |
| // Specify the separator | |
| options.Separator = Convert.ToChar(";"); | |
| // Save the file with the options | |
| wb.Save(dataDir + "output.csv", options); | |