Excel specific features
GemBox.Spreadsheet preserves Excel specific features like sparklines, slicers, icon sets, data bars, etc. when reading XLSX file format.

import com.gembox.spreadsheet.*;
class Program {
public static void main(String[] args) throws java.io.IOException {
// If using Professional version, put your serial key below.
SpreadsheetInfo.setLicense("FREE-LIMITED-KEY");
ExcelFile workbook = ExcelFile.load("%InputFileName%");
// Modify all values in column C. Set them to some random value between -10 and 10.
CellRangeIterator readEnumerator = workbook.getWorksheet(0).getColumn("C").getCells().getReadIterator();
java.util.Random rnd = new java.util.Random();
while (readEnumerator.hasNext()) {
ExcelCell cell = readEnumerator.next();
if (cell.getValueType() == CellValueType.INT)
cell.setValue(rnd.nextInt(20) - 10);
}
workbook.save("Excel Specific Features.xlsx");
}
}
Want more?
Like it?
Published: February 28, 2020 | Modified: March 20, 2020 | Author: Marek Turis