public static JexcelSheetData createSheetData(Sheet sheet, JexcelTransformer transformer){ JexcelSheetData sheetData = new JexcelSheetData(); sheetData.setTransformer(transformer); sheetData.sheet = sheet; sheetData.sheetName = sheet.getName(); sheetData.columnWidth = new int[256]; for(int i = 0; i < 256; i++){ sheetData.columnWidth[i] = sheet.getColumnView(i).getSize(); } int numberOfRows = sheet.getRows(); for(int i = 0; i < numberOfRows; i++){ sheetData.rowDataList.add(JexcelRowData.createRowData(sheet, i, transformer)); } sheetData.mergedCells = sheet.getMergedCells(); return sheetData; }