Free Support Forum - aspose.com

Trying to apply Style to entire worksheet- API does not match product

I need to apply common formatting to all cells on a worksheet. API documentation indicates I should be able to call something similar to the following

Workbook workbook = new Workbook();

Style style = workbook.createStyle();
style.setPattern(BackgroundType.SOLID);

BorderCollection borders = style.getBorders();
borders.setStyle(CellBorderType.NONE);

However these APIs don’t appear to be available in my version of Aspose Cells. I don’t have “setPattern” method on the Style object, only “setPatternStyle”.

Can you please help me achieve the above formatting in the version of Aspose.Cells I have?

We are using aspose-cells-2.5.4.10.jar

Thanks

Hi,


Well, I am afraid to use the new APIs, you need to have latest versions e.g v7.0.x.

However, if you need to stick with older version, see a code segment for your reference:

Example:<o:p></o:p>

[JAVA]

//Instantiating a Workbook object

Workbook workbook = new Workbook();

//Accessing the added worksheet in the Excel file

Worksheet worksheet = workbook.getWorksheets().addSheet();

Cells cells = worksheet.getCells();

//Accessing the "A1" cell from the worksheet

Cell cell=cells.getCell("A1");

Style style = cell.getStyle();

//Setting the foreground color to yellow

style.setColor(Color.YELLOW);

//Setting the background pattern to vertical stripe

style.setPatternStyle(PatternType.VERTICAL_STRIPE);

//Saving the modified style to the "A1" cell.

cell.setStyle(style);

//Accessing the "A2" cell from the worksheet

cell=cells.getCell("A2");

style = cell.getStyle();

//Setting the foreground color to blue

style.setColor(Color.BLUE);

//Setting the background color to yellow

style.setPatternColor(Color.YELLOW);

//Setting the background pattern to vertical stripe

style.setPatternStyle(PatternType.VERTICAL_STRIPE);

//Saving the modified style to the "A2" cell.

cell.setStyle(style);

//Saving the Excel file

workbook.save("C:\\output.xls",FileFormatType.DEFAULT);


Thanks Amjad. We are in the process of renewing our license file to get the latest version.

Until that process is complete, do you think you could provide me a link to the full API documentation for the version of Aspose.Cells Java I am using currently?

aspose-cells-2.5.4.10.jar

Would like the full documentation for this version.

Thanks.

Hi,


I am afraid, I can’t as the documentation (topics) is updated based on the latest version only although you may get the API Reference of older version e.g 2.5.4.
http://www.aspose.com/community/files/72/java-components/aspose.cells-for-java/entry307071.aspx

Thank you.