XLSB with slicers - file getting corrupted after saving

Aspose.Cells Product Family
1
Hi Team,

we tried to importCSV command to import csv file to excel (XLSB+SLICERS) we are seeing same issue again with aspose cells 8.3.1.2 version

Please suggest.

try {
Workbook workbook = null;
try {
workbook = new Workbook("E:\\Current_Plan_Extract.xlsb");
} catch (Exception e1) {
}
try {
workbook.save("E:\\Current_Plan_Extract.xlsb");
} catch (Exception e1) {
}
TxtLoadOptions loadOptions = new TxtLoadOptions();
loadOptions.setSeparatorString("|");
workbook.getWorksheets().get("Sheet1").getCells()
.importCSV(
"E:\\1dbeaf370ad151ea122c01fcf6926178_Sheet1.csv", loadOptions,
0, 0);
workbook.save("E:\\sample.xlsb", SaveFormat.XLSB);

} catch (Exception e) {
e.printStackTrace();
}
}

2

Hi,

Thanks for your posting and using Aspose.Cells.

Please download and try the latest version: Aspose.Cells for Java 8.4.1 and see how it goes at your end and if it fixes your issue.

If your issue still occurs, then please provide us your source xlsb file. The file you attached does not look source xlsb file but it looks like it was generated by Aspose.Cells.

We need your unmodified source xlsb file namely Current_Plan_Extract.xlsb.

Also, we did not find any slicer inside your Current_Plan_Extract.xlsb file.

3

Hi Team,


with help of latest aspose jar we tried to generate a report. But getting aspose related exception message. Please look into this issue and provide us the solution.

This is high priority issue from our side. Quick response is highly appriciated.


package test;

import com.aspose.cells.Workbook;

public class test {
public static void main(String[] args) throws Exception {
System.out.println(“creating”);
Workbook workbook =null;
try {
workbook = new Workbook(“E:\Current_Plan_Report.xlsb”);
System.out.println(“workbook created”);
} catch (Exception e1) {
System.out.println("Error: " + e1.getStackTrace());
throw new Exception(e1);
}
}

}


exception message:

Caused by: java.lang.IndexOutOfBoundsException: Index: 2, Size: 2
at java.util.ArrayList.RangeCheck(Unknown Source)
at java.util.ArrayList.get(Unknown Source)
at com.aspose.cells.zbqn.a(Unknown Source)
at com.aspose.cells.zbql.b(Unknown Source)
at com.aspose.cells.zbqu.c(Unknown Source)
at com.aspose.cells.zbqu.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.(Unknown Source)
at test.test.main(test.java:11)



Thanks
4

Hi Chandra,


Thank you for providing your sample.

We have evaluated your presented scenario while using the latest version of Aspose.Cells for Java 8.4.1.2, and we are able to observe the java.lang.IndexOutOfBoundsException: Index: 2, Size: 2 at Workbook constructor. We need to further analyze the scenario to pin point the problem cause therefore we have logged the problem in our bug tracking system under the ticket CELLSJAVA-41310. Please allow us some time to properly analyze this incident, and provide the fix at earliest possible. In the meanwhile, we will keep you posted with updates in this regard.

We are sorry for your inconvenience.
5

Hi,

Thanks for using Aspose.Cells for Java.

Please download and try this fix: Aspose.Cells for Java v8.4.1.3 and let us know your feedback.

6

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

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