Dear Aspose Team,
We are using Aspose Cell.When we want to open file throws exception.
FileFormatInfo info = FileFormatUtil.DetectFileFormat(workbook);
LoadOptions options = new LoadOptions(info.LoadFormat);
var excleFile = new FileStream(path, FileMode.Open);
Workbook workbook = new Workbook(excleFile , options )
Note: When I detect LoadFormat, it show XLSB ,but it I am able to open it with LoadFormat.CSV.
DummyWorkbookForTesting.zip (7.3 KB)
Please Could you help me?
Thanks in advance
Thanks for your query.
I have tried this code using latest version Aspose.Cells for .NET 19.1.x but could not observe any exception and file opens fine. You may please test this scenario using latest version and provide the feedback.
Regarding setting the LoadFormat.CSV, Aspose.Cells checks the file format type when opening the file first, If it could not detect the file format type, then it will use the set load format by you.
Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.