Not able to read an Excel using Aspose

Aspose.Cells Product Family
1

Hi,

I am not able to read the attached Excel file using Aspose.cells for java(JDK 1.6)

I tried by specifying different file formats in Loadoptions.

It still doesn't work. Anything i am missing here.

Thanks,

Shreesha

2

Hi Shreesha,

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

I tried to open your source xls file with MS-Excel 2010 and it displayed warning that file has some different format that xls. However, it was able to open it. So the file has some unknown format.

Please download and try the latest version: Aspose.Cells
for Java v7.6.1.4 and see if it works fine at your end. The latest version is able to open your file successfully.

3

Hi Shakeel,

Thanks for the response!

I tried with Aspose.Cells for Java v7.6.1.4.

Its not throwing any error while creating workbook.

However when i try to get the data, its not showing any.

In the below code snippet, cells object is coming as null and cells.getm,axDataRow is coming as zero.

bis = new BufferedInputStream(new FileInputStream(absFileName));

outputFile = new BufferedWriter(new PrintWriter(outputFileName));

Workbook workbook = new Workbook(bis,loadOptions);

Worksheet worksheet = workbook.getWorksheets().get(1);

Cells cells = worksheet.getCells();

System.out.println("Total Rows : "+worksheet.getCells().getMaxDataRow());

Thanks,

Shreesha

4

Hi Shreesha,

Thanks for your feedback and using Aspose.Cells.

Your source file has unknown format and when Aspose.Cells creates a workbook object from it, it is empty with no data. We have logged this issue in our database for investigation. We will look into it and fix this issue if possible. Once, there is some fix or update for you, we will let you know asap.

This issue has been logged as CELLSJAVA-40685.

5

The issues you have found earlier (filed as CELLSJAVA-40685) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.