1

I am opening an existing Excel file using SpreadsheetGear, using the following code:

SpreadsheetGear.IWorkbook xlBook = SpreadsheetGear.Factory.GetWorkbook(fileName, System.Globalization.CultureInfo.CurrentCulture); xlBook.SaveAs(fileNameCSV, SpreadsheetGear.FileFormat.CSV);

This works, but the saved CSV file contains the wrong sheet.

Can anyone help with a code snippet on how to open an Excel file in SpreadsheetGear, then save only a SPECIFIC sheet to a CSV file.

Please note I am working with SpreadsheetGear and want a solution for that library. Thanks!

Fritz45
  • 752
  • 1
  • 10
  • 23

1 Answers1

2

The IWorksheet interface includes a SaveAs(...) method for just this purpose:

using SpreadsheetGear;
using System.Globalization;
...

IWorkbook xlBook = Factory.GetWorkbook(fileName, CultureInfo.CurrentCulture); 
xlBook.Worksheets["My Sheet"].SaveAs(fileNameCSV, FileFormat.CSV);

I'll also mention that there is also an IRange.SaveAs(...) method if you want to save just a particular range to CSV / UnicodeText (tab-delimited).

Tim Andersen
  • 3,014
  • 1
  • 15
  • 11