File path1 = new File(path); book = Workbook.getWorkbook(path1); Test test = new Test(); test.execute("delete from shi"); //获得第一个工作表对象 Sheet sheet = book.getSheet(0); //得到第一列第一行的单元格 sheet.getCell(0,0) for (int i=1;i<sheet.getRows();i++) { for(int j=0;j<sheet.getColumns();j++) { Cell cell = sheet.getCell(j,i);
try
{
String sheetId = null;
String sheetSum = null;
String goodsName = null;
String goodsZhong = null;
String result = null;
String SQL = null;
File path1 = new File(path);
book = Workbook.getWorkbook(path1);
Test test = new Test();
test.execute("delete from shi");
//获得第一个工作表对象
Sheet sheet = book.getSheet(0);
//得到第一列第一行的单元格 sheet.getCell(0,0)
for (int i=1;i<sheet.getRows();i++)
{
for(int j=0;j<sheet.getColumns();j++)
{
Cell cell = sheet.getCell(j,i);
if(j==0)
{
sheetId = cell.getContents();
}
else if(j==1)
{
sheetSum = cell.getContents();
}
else if(j==2)
{
goodsName = cell.getContents();
}
else if(j==3)
{
goodsZhong = cell.getContents();
}
}
if(sheetId!=null)
{
test.insert(sheetId,sheetSum,goodsName,goodsZhong);
}
System.out.println(sheetId);
}
book.close();
return 1;
}
catch (Exception e)
{
return 0;
}
我是直接生成在文件目录下的。
jxl.Workbook rw = jxl.Workbook.getWorkbook(new File(sourcefile));//创建可写入的Excel工作薄对象
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File(targetfile), rw);//读取第一张工作表
jxl.write.WritableSheet ws = wwb.getSheet(0);//获得第一个单元格对象
jxl.write.WritableCell wc = ws.getWritableCell(0, 0);//判断单元格的类型, 做出相应的转化
if(wc.getType() == CellType.LABEL)
{
Label l = (Label)wc;
l.setString("The value has been modified.");
}//写入Excel对象
wwb.write();//关闭可写入的Excel对象
wwb.close();//关闭只读的Excel对象
rw.close();
这是网上帮你找的个,
String filename = request.getSession().getId() + Math.random()
+ ".xls";
String filepath = getServlet().getServletContext().getRealPath(
"/exportFiles/" + filename);