import java.io.*;
import jxl.*;
import java.util.*;
import jxl.Workbook;
import jxl.read.biff.*;
class readXls
{
public static void main(String[] args) throws IOException, BiffException
{
String filename = "D:/Documents and Settings/nzq4pt/Desktop/TNEWS_05/TNEWS_VRT.XLS";
readContentsFromExcel(filename);
}
private static ArrayList readContentsFromExcel(String filename)
{
ArrayList readDataShet = new ArrayList();
WorkbookSettings ws = new WorkbookSettings();
ws.setLocale(new Locale("en", "EN"));
Workbook workbook;
try
{
workbook = Workbook.getWorkbook(new File(filename),ws);
Sheet s = workbook.getSheet(0);
readDataSheet1(s);
workbook.close();
} catch (BiffException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return readDataShet;
}
private static void readDataSheet1(Sheet s)
{
// Find the labeled cell from sheet
LabelCell qname = s.findLabelCell("Email");
for(int j = 1; j
Cell dispcell = s.getCell(0,j);
String content = dispcell.getContents();
System.out.println("'"+content+"',");
}
}
}

No comments:
Post a Comment