// Create a new workbook Workbook workbook = new Workbook(); // ToJson&FromJson can be used in combination with spread.sheets product // Document Solutions for Excel import an excel file. // Change the path to real source file path. String source = "source.xlsx"; workbook.open(source); // Open the same user file Workbook new_workbook = new Workbook(); new_workbook.open(source); for (IWorksheet worksheet : workbook.getWorksheets()) { // Do any change of worksheet // ... // Document Solutions for Excel export a worksheet to a json string. String json = worksheet.toJson(); // Use the json string to initialize spread.sheets product. // Product spread.sheets will show the excel file contents. // Use spread.sheets product export a json string of worksheet. // Document Solutions for Excel use the json string to update content of the corresponding worksheet. new_workbook.getWorksheets().get(worksheet.getName()).fromJson(json); } // Document Solutions for Excel export workbook to an excel file. // Change the path to real export file path. String export = "export.xlsx"; new_workbook.save(export);
// Create a new workbook var workbook = Workbook() // ToJson&FromJson can be used in combination with spread.sheets product // Document Solutions for Excel import an excel file. // Change the path to real source file path. val source = "source.xlsx" workbook.open(source) // Open the same user file val new_workbook = Workbook() new_workbook.open(source) for (worksheet in workbook.getWorksheets()) { // Do any change of worksheet // ... // Document Solutions for Excel export a worksheet to a json string. val json = worksheet.toJson() // Use the json string to initialize spread.sheets product. // Product spread.sheets will show the excel file contents. // Use spread.sheets product export a json string of worksheet. // Document Solutions for Excel use the json string to update content of the corresponding worksheet. new_workbook.getWorksheets().get(worksheet.getName()).fromJson(json) } // Document Solutions for Excel export workbook to an excel file. // Change the path to real export file path. val export = "export.xlsx" new_workbook.save(export)