Class SpreadsheetUtils

java.lang.Object
repast.simphony.ui.table.SpreadsheetUtils

public class SpreadsheetUtils extends Object
Utility to convert TableModels to spreadsheet files via POI
Author:
Eric Tatara
  • Constructor Details

    • SpreadsheetUtils

      public SpreadsheetUtils()
  • Method Details

    • saveSingleTableAsExcel

      public static void saveSingleTableAsExcel(TableModel model, String sheetName, File file)
      Creates an Excel workbook from a single TableModel
      Parameters:
      model -
      sheetName -
      file - the name of the save file
    • saveTablesAsExcel

      public static void saveTablesAsExcel(Map<String,TableModel> models, File file)
      Creates an Excel workbook from a list of Table models, with each TableModel inserted as a seprate sheet.
      Parameters:
      models - a list of TableModel
      file - the name of the save file