importing data from database to excel sheet through JExcel Api

[akki gupta]

how to import data from the database to an excel sheet using JExcel Api through JSP page?

[Ifteqar Ahmed]

Step 1: The following code Creates an Excel File using JXL API.

 public static void main(String args[])
    {
        try
        {
            Date date = new Date();
            System.out.println();
            String filename = "SomeFile.xls";
            WorkbookSettings ws = new WorkbookSettings();
            ws.setLocale(new Locale("en", "EN"));
            WritableWorkbook workbook = Workbook.createWorkbook(new File(filename), ws);
            WritableSheet s = workbook.createSheet("Sheet1", 1);
            writeDataSheet(s);
            workbook.write();
            workbook.close();
        }
        catch(IOException e)
        {
            e.printStackTrace();
        }
        catch(WriteException e)
        {
            e.printStackTrace();
        }
    }

Step2 : The following Function writes data to the Excel Sheet.

private static void writeDataSheetifx(WritableSheet s)
        throws WriteException
    {
        WritableFont wf = new WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD);
        WritableCellFormat cf = new WritableCellFormat(wf);
        cf.setAlignment(Alignment.CENTRE);
        cf.setBorder(Border.ALL, BorderLineStyle.THIN);
        cf.setWrap(true);
        try
        {
           
            ResultSet rs=st.ExecuteQuery("Select number from numbertable");
while(rs.next)
{
           int n[]= rs.getInt(number);
}
            for(int ix = 1; ix<=n; ix++)
            {
                Label l1 = new Label(0, 1, "Sample Cell");
                s.addCell(l1);
                Number n = new Number(ix, 1, Double.parseInt(n[ix]);
                n.setCellFormat(cf);
                s.addCell(n);
            }

            in.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }

I have just given you the Idea about How to import Values from database to Excel Sheet. Modify the code as per your Requirements.

Thanks.......

[akki gupta]

thanks....:)

[Miku Ranjan]

Hi,
There is another way of using jxl you can use jxl tag directly in xls file.