CODEWITHSUNDEEP
javaexcel
Shahrin
Shahrin

Reputation: 134

create multiple sheets on excel in java

I'm trying to create two different sheets on a single excel file . But only getting the first sheet.How can I get the second sheet ? where did I mistake ? Please help

Below is the code :

        WorkbookSettings ws = new WorkbookSettings();
        ws.setLocale(new Locale("en", "EN"));
        WritableWorkbook workbook = Workbook.createWorkbook(new File(filename), ws);
        WritableSheet s = workbook.createSheet("Summary", 0);

        // set font ,border,alignment
        cf.setWrap(true);

        Label l = null;
        l = new Label(0, 0, "Ticket Product", cf);
        s.addCell(l);
        ............................................
        ............................................
        // code to load data on the first sheet


        int columns = s.getColumns();
        for (i = 0; i < columns; i++) 
        {
            //write on excel columnwise
        }
        workbook.write();

        s = workbook.createSheet("Details", 1);

        // set font ,border,alignment
        cf.setWrap(true);

        l = null;
        l = new Label(0, 0, "Ticket Product", cf);
        s.addCell(l);
        ............................................
        ............................................
        //code to load data on the second sheet

        columns = s.getColumns();
        for (i = 0; i < columns; i++) 
        {
          //the same loop as before to write columnwise
        }

        workbook.write();
        workbook.close();

Upvotes: 2

Views: 25682

Answers (2)

Mahaveer Jangir
Mahaveer Jangir

Reputation: 605

You have to use workbook.setSheetOrder(sheetName,pos) , and you can have the logic to increment the pos variable as required.

Upvotes: 1

Hard Developer
Hard Developer

Reputation: 319

    WorkbookSettings ws = new WorkbookSettings();
    ws.setLocale(new Locale("en", "EN"));
    WritableWorkbook workbook = Workbook.createWorkbook(new File(filename), ws);
    WritableSheet sheet1 = workbook.createSheet("Summary", 0);//Create the first sheet
    WritableSheet sheet2 = workbook.createSheet("Details", 1);//Create the second sheet
    // set font ,border,alignment
    cf.setWrap(true);

    Label l = null;
    l = new Label(0, 0, "Ticket Product", cf);
    sheet1.addCell(l);
    ............................................
    ............................................
    // code to load data on the first sheet


    int columns = sheet1.getColumns();
    for (i = 0; i < columns; i++) 
    {
        //write on excel columnwise in sheet 1
    }

   int columnsheet2 = sheet2.getColumns();
    for (i = 0; i < columns; i++) 
    {
        //write on excel columnwise in sheet 2
    }
    workbook.write();

    s = workbook.createSheet("Details", 1);
    //here is the mistake you are using the same 's' object.

    // set font ,border,alignment
    cf.setWrap(true);`enter code here`

    l = null;
    l = new Label(0, 0, "Ticket Product", cf);
    sheet1.addCell(l);
    ............................................
    ............................................
    //code to load data on the second sheet

    columns = s.getColumns();
    for (i = 0; i < columns; i++) 
    {
      //the same loop as before to write columnwise
    }

    workbook.write();
    workbook.close();

Upvotes: 3

Related Questions