java jexcel_java – 在jExcel API中创建多个工作表

如果一个工作表已满(65536行),我需要使用jExcel API在Java中创建多个Excel工作表.假设如果一张纸已满,则在下一张纸中,它应该从第一张纸中停止的位置开始自动写入.当一张纸已满时,我只是坚持使用逻辑来动态创建它.下面是我到目前为止所做的代码.

public void write() throws IOException,WriteException {

File file = new File(inputFile);

WorkbookSettings wbSettings = new WorkbookSettings();

wbSettings.setLocale(new Locale("en","EN"));

WritableWorkbook workbook = Workbook.createWorkbook(file,wbSettings);

writingToExcel(workbook);

}

//Logic to create sheet dyanmically if one is full should be done here I guess?

private void writingToExcel(WritableWorkbook workbook) {

workbook.createSheet("Report",0);

WritableSheet excelSheet = workbook.getSheet(0);

try {

createLabel(excelSheet);

createContent(excelSheet);

} catch (WriteException e) {

e.printStackTrace();

} finally {

try {

workbook.write();

workbook.close();

} catch (IOException e) {

e.printStackTrace();

} catch (WriteException e) {

e.printStackTrace();

}

}

}

private void createLabel(WritableSheet sheet) throws WriteException {

WritableFont times10pt = new WritableFont(WritableFont.TIMES,10);

times = new WritableCellFormat(times10pt);

times.setWrap(true);

WritableFont times10ptBoldUnderline = new WritableFont(WritableFont.TIMES,10,WritableFont.BOLD,false,UnderlineStyle.SINGLE);

timesBoldUnderline = new WritableCellFormat(times10ptBoldUnderline);

timesBoldUnderline.setWrap(true);

CellView cv = new CellView();

cv.setFormat(times);

cv.setFormat(timesBoldUnderline);

cv.setAutosize(true);

// Write a few headers

addCaption(sheet,"Header 1");

addCaption(sheet,1,"This is another header");

}

private void createContent(WritableSheet sheet) throws WriteException,RowsExceededException {

for (int i = 1; i < 70000; i++) {

addNumber(sheet,i,i + 10);

addNumber(sheet,i * i);

}

}

private void addCaption(WritableSheet sheet,int column,int row,String s)

throws RowsExceededException,WriteException {

Label label;

label = new Label(column,row,s,timesBoldUnderline);

sheet.addCell(label);

}

private void addNumber(WritableSheet sheet,Integer integer) throws WriteException,RowsExceededException {

Number number;

number = new Number(column,integer,times);

sheet.addCell(number);

}

我不知道如何在我的代码中添加该逻辑.

任何建议都会有很大帮助吗？

或者在任何情况下,任何人都可以给我一个简单的例子,如果一张纸已满,它应该开始自动写入不同的纸张(第二张)？