Microsoft Office Excel Comman Separated Values File

Aspose.Cells Product Family
1

It is possible to open a 'Microsoft Office Excel Comman Separated Values File' and if so how?

2

Do you mean to open a CSV file? Currently Aspose.Excel doesn’t support to open it but supports to save the file as CSV format.

3

@romanr,
Aspose.Cells has replaced Aspose.Excel which is discontinued now and no more development is done for it. Aspose.Cells supports all the latest feature of MS Excel including loading the CSV files. This feature is demonstrated in the following sample code:

Opening CSV File

TxtLoadOptions opts = new TxtLoadOptions();
opts.Separator = ',';
opts.HasFormula = true;

// Load your CSV file with formulas in a Workbook object
Workbook workbook = new Workbook(dataDir + "sample.csv", opts);

// You can also import your CSV file like this
// The code below is importing CSV file starting from cell D4
Worksheet worksheet = workbook.Worksheets[0];
worksheet.Cells.ImportCSV(dataDir + "sample.csv", opts, 3, 3);

// Save your workbook in Xlsx format
workbook.Save(dataDir + "output_out.xlsx");

Load or Import CSV file with Formulas

TxtLoadOptions opts = new TxtLoadOptions();
opts.Separator = ',';
opts.HasFormula = true;

// Load your CSV file with formulas in a Workbook object
Workbook workbook = new Workbook(dataDir + "sample.csv", opts);

// You can also import your CSV file like this
// The code below is importing CSV file starting from cell D4
Worksheet worksheet = workbook.Worksheets[0];
worksheet.Cells.ImportCSV(dataDir + "sample.csv", opts, 3, 3);

// Save your workbook in Xlsx format
workbook.Save(dataDir + "output_out.xlsx");

Here are the links to different articles which can be referred for working with CSV files:
Opening CSV File
Opening CSV files and replacing invalid characters
Using preferred parser
Load or Import CSV file with Formulas

Here is the link to the latest free trial version of this new product:
Aspose.Cells for .NET(Latest version)

Download a complete solution here which contains hundreds of examples for testing different features of Aspose.Cells.