Save Workbook to Text or CSV Format in Aspose.Cells

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 (e.g., XLS, XLSX, XLSM, XLSB, ODS, etc.) with any number of worksheets.

When the code is executed, it converts the data of all sheets in the workbook to TXT format.

You can modify the same example to save your file to CSV. By default, TxtSaveOptions.Separator is a comma, so do not specify a separator if saving to CSV format.

C#

  

string filePath = "source.xlsx";  

// Load your source workbook  
Workbook workbook = new Workbook(filePath);  

// 0‑byte array  
byte[] workbookData = new byte[0];  

// Text save options. You can use any type of separator  
TxtSaveOptions opts = new TxtSaveOptions();  
opts.Separator = '\t';  

// Copy each worksheet's data in text format into the workbook data array  
for (int idx = 0; idx < workbook.Worksheets.Count; idx++)  
{  
    // Save the active worksheet into text format  
    MemoryStream ms = new MemoryStream();  
    workbook.Worksheets.ActiveSheetIndex = idx;  
    workbook.Save(ms, opts);  

    // Save the worksheet data into the sheet data array  
    ms.Position = 0;  
    byte[] sheetData = ms.ToArray();  

    // Combine this worksheet's data into the workbook data array  
    byte[] combinedArray = new byte[workbookData.Length + sheetData.Length];  
    Array.Copy(workbookData, 0, combinedArray, 0, workbookData.Length);  
    Array.Copy(sheetData, 0, combinedArray, workbookData.Length, sheetData.Length);  
    workbookData = combinedArray;  
}  

// Save the entire workbook data to a file  
File.WriteAllBytes(filePath + ".out.txt", workbookData);  

Download Running Code

• GitHub

Download Sample Code

• GitHub