Class SpreadsheetUtils


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

      • SpreadsheetUtils

        public SpreadsheetUtils()
    • Method Detail

      • 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