Aspose cells 7.0.0.2

Aspose.Cells Product Family
1

hi team,

what are the equivalent classes for below mentioned classes in 7.0.0.2 cells.

1.DXFStyle.
2. how to set the Light cells data provider for worrkbook in 7.0.0.2.
3. set encoding for workbook.
4. how to create own color and add to Palette.

Thanks ,

kumar.


2

Hi,


1) in the new version e.g v7.0.x, it is not included. Please use Style object instead. For example, you may also set formatting using PivotTable.formatAll(style).

Sample code:
Code with the new version is like following:
…
PivotTable pt = (PivotTable)worksheet.getPivotTables().get(0);
Style dxfStyle = workbook.createStyle();
Font font = dxfStyle.getFont();
dxfStyle.setCustom(“0.00_);Red”);
font.setSize(8);
pt.formatAll(dxfStyle);
…

2) Please find attached the zip archive that contains some examples for using LightCells APIs.

3) There is no direct way to do it as there is not any API available (even in the older versions too). For example, you may try to save/convert the workbook to byte array and also you may load a workbook from the byte array etc.

4) See the topic:
http://www.aspose.com/documentation/java-components/aspose.cells-for-java/colors-and-palette.html

Thank you.

3

Hi,

LightCells API is not supported by V7.0.0. Please use latest version or fix:
Aspose.Cells for Java 7.0.3


For encoding of a workbook, if you want to load a text format template file such as CSV, please use TxtLoadOptions.setEncoding(). If you want to set encoding of a workbook or saving workbook to text format with specific encoding, please use Workbook.getSettings().setEncoding().