Could not find the correct fileformattype of the excel using aspose.cells

Aspose.Cells Product Family
1

Hello,

I am not able to find the correct FileFormatType of Aspose.Cells for the below url to open the excel workbook.
http://www.bse-sofia.bg/all_issues/?lang=bg
I used many fileformattypes like Excel2003, Defaut, Excel97.
Iam getting the below exception.

Aspose.Cells.CellsException : This file’s format is not supported or you don’t specify a correct format.

But when the two Tabdelimited, CSV fileformats are used, we are able to open the workbook. But it contains data not in irregular unknown pattern.

Can any one suggest me the correct fileformattype of the above url.


Thanks in Advance.

- MounicaS


2

Hi,

Thanks for your posting and using Aspose.Cells for .NET

For .xls file, use FileFormatType.Excel97To2003 enumeration.

However, often you don’t need to specify the format type, Aspose.Cells will detect the correct file format from its extension. So you can use this code.

Please download and use the latest version:
Aspose.Cells for .NET (Latest Version)


C#


Workbook workbook = new Workbook(“c:\yourfile.xls”);


3

Hi,


Also, you may use the static CellsHelper.DetectFileFormat() method to get the file format type for a file, the method takes the file path as an argument.

Thank you.