Women in Technology

Hear us Roar



Article:
  Reading and Writing Excel Files with POI
Subject:   Excel to CSV -- better use the andykhan.com java JExcel API
Date:   2003-11-26 09:04:52
From:   filipb
After some time waiting for the authors to fix the
errors in the article, I found an excellent free
(GNU LGPL) java application by Andy Khan
(andykhan.com)
It works ok for me to do command-line invoked
transformations from xls to csv. It is possible
also to do xls-to-xml.
Full Threads Newest First

Showing messages 1 through 4 of 4.

  • Excel to CSV -- better use the andykhan.com java JExcel API
    2005-05-12 23:10:09  Sivalingan [View]


    Hi ,

    Will u please mail me the sample code to transform Excel(xls) to cvs using Java...

    Its urgently needed...

    Thanks in advance
    • Excel to CSV -- better use the andykhan.com java JExcel API
      2006-06-20 07:17:42  pnknanda [View]

      Hi,
      even i'm working on the same issue,So can you send the sample code of " How to read Excel file and transform the same to csv file using java".
      It'll be great help to me.

      Thanks & Regards,
      Nanda Kishore
      • Excel to CSV -- better use the andykhan.com java JExcel API
        2008-05-19 01:37:46  Kannan Raghupathy [View]

        Hi Nanda,

        The code below will help you to solve the problem. Make sure that you have jxl.jar file and then compile and run the below code.

        import java.io.*;
        import jxl.*;
        import java.util.*;

        class ConvertCSV
        {
        public static void main(String[] args)
        {
        try
        {
        //File to store data in form of CSV
        File f = new File("Output.csv");

        OutputStream os = (OutputStream)new FileOutputStream(f);
        String encoding = "UTF8";
        OutputStreamWriter osw = new OutputStreamWriter(os, encoding);
        BufferedWriter bw = new BufferedWriter(osw);

        //Excel document to be imported
        String filename = "input.xls";
        WorkbookSettings ws = new WorkbookSettings();
        ws.setLocale(new Locale("en", "EN"));
        Workbook w = Workbook.getWorkbook(new File(filename),ws);

        // Gets the sheets from workbook
        for (int sheet = 0; sheet < w.getNumberOfSheets(); sheet++)
        {
        Sheet s = w.getSheet(sheet);

        bw.write(s.getName());
        bw.newLine();

        Cell[] row = null;

        // Gets the cells from sheet
        for (int i = 0 ; i < s.getRows() ; i++)
        {
        row = s.getRow(i);

        if (row.length > 0)
        {
        bw.write(row[0].getContents());
        for (int j = 1; j < row.length; j++)
        {
        bw.write(',');
        bw.write(row[j].getContents());
        }
        }
        bw.newLine();
        }
        }
        bw.flush();
        bw.close();
        }
        catch (UnsupportedEncodingException e)
        {
        System.err.println(e.toString());
        }
        catch (IOException e)
        {
        System.err.println(e.toString());
        }
        catch (Exception e)
        {
        System.err.println(e.toString());
        }
        }
        }

        Happy coding.
        Kannan
        • Excel to CSV -- better use the andykhan.com java JExcel API
          2010-07-10 16:30:46  DJade [View]

          Hi Kannan,
          Good day to you.

          Can you please tell me where we need to put jxl jar file in java folder? is it java/bin?
          I am not that much experienced with java and trying to write a program for this and i get compilation errors as its looking for jxl classes and cannot find any.


          Thanks,
          DJade