Create Excel file and store in sdcard

Create an excel file in android :

Download jxl.jar from

http://www.andykhan.com/jexcelapi/

extract the file and  copy the jar file to project – libs fiolder

try the following code in your class file

an excel file will be created in sdcard

String Fnamexls="testfile"  + ".xls";

               File sdCard = Environment.getExternalStorageDirectory();

         File directory = new File (sdCard.getAbsolutePath() + "/newfolder");

         directory.mkdirs();

             File file = new File(directory, Fnamexls);

             WorkbookSettings wbSettings = new WorkbookSettings();

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

             WritableWorkbook workbook;

             try {

               int a = 1;

                 workbook = Workbook.createWorkbook(file, wbSettings);

                 //workbook.createSheet("Report", 0);

                 WritableSheet sheet = workbook.createSheet("First Sheet", 0);

                 Label label = new Label(0, 2, "SECOND");

                 Label label1 = new Label(0,1,"first");

                 Label label0 = new Label(0,0,"HEADING");

                 Label label3 = new Label(1,0,"Heading2");

                 Label label4 = new Label(1,1,String.valueOf(a));

                 try {

                                  sheet.addCell(label);

                                   sheet.addCell(label1);

                                  sheet.addCell(label0);

                                  sheet.addCell(label4);

                                  sheet.addCell(label3);

                           } catch (RowsExceededException e) {

                                  // TODO Auto-generated catch block

                                  e.printStackTrace();

                           } catch (WriteException e) {

                                  // TODO Auto-generated catch block

                                  e.printStackTrace();

                           }

             

                 workbook.write();

                 try {

                                  workbook.close();

                           } catch (WriteException e) {

                                  // TODO Auto-generated catch block

                                  e.printStackTrace();

                           }

                 //createExcel(excelSheet);

             } catch (IOException e) {

                 // TODO Auto-generated catch block

                 e.printStackTrace();

             }