by clearoffice
30. October 2009 07:15
Does Clear Spreadsheet support legacy .xls file?
Yes
From the spreadsheet, simply select a file with an xls extension. Clear Spreadsheet will automatically convert it. You can then save to xlsx (Office 12 format).
Developers can open xls document by using the BiffFormat class.
BiffFormat format = new BiffFormat();
SpreadsheetDocument document = format.Open (xlsFileName);
Biff stands for “Binary interchange file format” - the technical name given by Microsoft.
All the code for Biff resides in a separate assembly: Office.Spreadsheet.Formats.Biff.dll. This way, you can remove this assembly from your application to make it “legacy free”.
Also, you can open csv files (comma separated values):
CsvFormat format = new CsvFormat();
SpreadsheetDocument document = format.Open (csvFlieName);
And tsv files (tab separated values):
CsvFormat format = new CsvFormat();
SpreadsheetDocument document = format.Open (csvFlieName);
11ffd3d5-95e2-4888-a512-2067bb61bc8f|0|.0
Tags:
Subscribe