How Do I Create a New Excel File Using JXL?

Question

I'm trying to create a new Excel file using jxl, but am having a hard time finding examples in their API documentation and online.

Answer 1

Not sure if you need to stick with JXL, but the best library for handling Excel files is Apache's POI HSSF.

I think there are plenty of examples on the website I provided, but if you need further assistence, let me know. I may have a few examples laying around.

Just out of curiosity, POI stands for Poor Obfuscation Interface and HSSF is Horrible SpreadSheet Format. You see how much Apache loves Microsoft Office formats :-)

Answer 2

After messing around awhile longer I finally found something that worked and saw there still wasn't a solution posted here yet, so here's what I found:

try {
    String fileName = "file.xls";
    WritableWorkbook workbook = Workbook.createWorkbook(new File(fileName));
    workbook.createSheet("Sheet1", 0);
    workbook.createSheet("Sheet2", 1);
    workbook.createSheet("Sheet3", 2);
    workbook.write();
    workbook.close();
} catch (WriteException e) {

}

Answer 3

This page gives an example of how to create a new Excel file with JXL: http://www.java-tips.org/other-api-tips/jexcel/how-to-create-an-excel-file.html