How to get the color of worksheet
In fact I can call method by reflect to get these like
Thanks for your posting and using Aspose.Cells.
You can get the default style of the entire workbook using the Workbook.getDefaultStyle() property.
It’s not work.
Thanks for your sample excel file and using Aspose.Cells.
Please let us know how do you set default color of worksheet using Microsoft Excel. If you set the color of all cells then you can get the color of individual cell using Cell.getStyle() property.
In MS Excel, click top left corner of sheet, left to A, above 1, MS Excel display a triangle icon, this will make MS Excel select all cells.
Thanks for your suggestion and using Aspose.Cells.
We have logged a ticket for this feature in our database for product team investigation. We will look into it and implement this feature. In case, we need to unobfuscated some method relating to it, we will do it or implement a new method for it. Once there is some news for you, we will let you know asap.
This issue has been logged as
- CELLSJAVA-41560 - How to get default color of worksheet
xhaixia:But these code will make save method generate a extra rowWorkbook wb = new Workbook("C:/DefaultColor2.xlsx");Cells cells = wb.getWorksheets().get(0).getCells();Cell cell = cells.get(cells.getMaxRow() + 1, 0);System.out.println(Integer.toHexString(cell.getStyle().getForegroundArgbColor()));wb.save("C:/DefaultColor2.html");This will make html has a blank row