Excel Chart Preservation

import com.gembox.spreadsheet.*;

class Program {

    public static void main(String[] args) throws java.io.IOException {
        // If using the Professional version, put your serial key below.
        SpreadsheetInfo.setLicense("FREE-LIMITED-KEY");

        ExcelFile workbook = ExcelFile.load("%InputFileName%");

        int numberOfEmployees = %EmployeesCount%;

        ExcelWorksheet worksheet = workbook.getWorksheet(0);

        // Update named ranges 'Names' and 'Salaries' which are used by preserved chart.
        worksheet.getNamedRange("Names").setRange(worksheet.getCells().getSubrangeAbsolute(1, 0, numberOfEmployees, 0));
        worksheet.getNamedRange("Salaries").setRange(worksheet.getCells().getSubrangeAbsolute(1, 1, numberOfEmployees, 1));

        // Add data which is used by preserved chart through named ranges 'Names' and 'Salaries'.
        String[] names = new String[] { "John Doe", "Fred Nurk", "Hans Meier", "Ivan Horvat" };
        java.util.Random random = new java.util.Random();
        for (int i = 0; i < numberOfEmployees; i++) {
            worksheet.getCell(i + 1, 0).setValue(names[i % names.length] + (i < names.length ? "" : " " + (i / names.length + 1)));
            worksheet.getCell(i + 1, 1).setValue(random.nextInt(4000) + 1000);
        }

        workbook.save("Preservation.xlsx");
    }
}