Save a CSV file

Aspose.Cells Product Family
1

I need to generate a file with 200.000 rows to a csv file.

I use this:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

excel.Save("File.csv", SaveType.OpenDefault, FileFormatType.CSV, Me.Response)

I received this error: Rows of DataTable is out of range.

It is possible to export more than 64.000 rows using aspose.excel?

2

Aspose.Excel is a spreadsheet creation engine and it works similiar to MS Excel. MS Excel doesn’t support to export more than 65536 rows.

Is this feature important to you? Could you try to combine several csv files to one?

3

@gferreira,
Aspose.Excel is discarded and a new product Aspose.Cells is introduced that is quite rich in terms of features and performance as compared to its predecessor. Aspose.Cells can save rows upto 1048576. It not only supports large number of rows but also provides other features to export Excel file to CSV like set encoding, mark export area, format strategy, quote type, separator character, separator string and format strategy. You can now export XLSX (that supports 1048576 rows at max) also to CSV. Here is an example that demonstrates exporting Excel to CSV using Aspose.Cells.

Workbook workbook = new Workbook("Book1.xlsx");
TxtSaveOptions txtSaveOptions = new TxtSaveOptions();
txtSaveOptions.Separator = ',';
workbook.Save("ByAspose.csv",txtSaveOptions);

For more information on conversion to CSV follow the below link:
Load or Import CSV file with Formulas
Save Workbook to Text or CSV Format in Aspose.Cells

Download the latest version of this product from the following link for trials:
Aspose.Cells for .NET (Latest Version)

A detailed solution is available here which can be used for testing different features of this product.