import jxl.*;
import java.util.*;
class ConvertExcelToCSV
{
public static void main(String[] args)
{
try
{
String filename = "C:/Documents and Settings/motidara/Desktop/
WorkbookSettings ws = new WorkbookSettings();
ws.setLocale(new Locale("en", "EN"));
Workbook w = Workbook.getWorkbook(new File(filename),ws);
File f = new File("C:/Documents and Settings/motidara/Desktop/new.
OutputStream os = (OutputStream)new FileOutputStream(f);
String encoding = "UTF8";
OutputStreamWriter osw = new OutputStreamWriter(os, encoding);
BufferedWriter bw = new BufferedWriter(osw);
for (int sheet = 0; sheet < w.getNumberOfSheets(); sheet++)
{
Sheet s = w.getSheet(sheet);
bw.write(s.getName());
bw.newLine();
Cell[] row = null;
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 (Exception e)
{
System.err.println(e);
}
}
}
}
}
If you want to avoid doing the coding and the error then use this Excel file to csv converter it also uses java language to convert not only your excel files but all your MS Office files.
ReplyDelete