We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Java Api 2.4.2 ? and using 2.4.2 to get range of Cells and setting style on the range?

I’m really having a tough time working with this Aspose app I inherited since it’s using Aspose Cells 2.4.2 and all the documentation and the api on the site is for a newer version.

Is there an archived version of the java docs somewhere? I really could use it.

For example, I can’t tell what each int represents in

cells.getCells(int int int int)

since in the latest version there is no method getCells(int,int,int,int) for the Cells object.

I’ve run into this problem now in other areas which is making it difficult to work without at least the Java docs.

… if anyone wants to help out, I’d like to style a range of cells a certain way, but the docs are all showing how to do this using a later version.

I see in this legacy code the developer getting cells like
Cells cells = worksheet.getCells();
Cell cellData[][] = cells.getCells(0,0,0,7);

then he’s iterating over the two dimensional array and setting each cell style manually. Besides this being inefficient, I can’t even tell (as mentioned previously) what range 0,0,0.7 represents?

What’s the best way for me to format a range using 2.4.2? Thanks.


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

Please download the official release of V2.4/V2.5 to get the javadoc.
Aspose.Cells for Java 2.5.4

The better way to set style for range of cells is Cells.setRangeStyle(int startRow, int endRow, int startColumn, int endColumn, Style style)