Chinaunix
标题:
我想用java怎么把EXCEL文件读出来?
[打印本页]
作者:
yangxinzhong
时间:
2005-05-26 10:29
标题:
我想用java怎么把EXCEL文件读出来?
我把orcle数据库里的表倒入EXCEL文件中,我想用java把它读出来,然后把各个字并成update语句。怎么并呢,还有为什么不能
读数字的字段呢?在线等待。谢谢!
Excel表个样式:
字段 ID NAME AGE RQ
数据 001 jack 20 1990-05-20 20:30:12
002 rose 24 2000-02-20 20:30:12
003 scott 25 2005-05-20 20:30:12
... ... ... ...
生成语句为:
update table t1 set name='(name)',age=(age),to_date('rq','yyyy-mm-dd hh24:mi:ss') where id='(id)';
作者:
yangxinzhong
时间:
2005-05-26 10:30
标题:
我想用java怎么把EXCEL文件读出来?
下边的代码不能实现啊?
import java.io.BufferedWriter;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFFooter;
import org.apache.poi.hssf.usermodel.HSSFHeader;
import org.apache.poi.hssf.usermodel.HSSFPrintSetup;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.contrib.HSSFCellUtil;
import org.apache.poi.hssf.usermodel.contrib.HSSFRegionUtil;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.hssf.util.Region;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import java.io.*;
import java.io.FileWriter;
public class ReadXL
{
public static String fileToBeRead = "D:\\t1.xls";
public static void main(String argv[]) {
try {
HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(
fileToBeRead));
HSSFSheet sheet = workbook.getSheetAt(0);
for(int i=0;i<6;i++){
HSSFRow row = sheet.getRow(i);
if(row==null)
continue;
System.out.println("-----------"+row);
for(int j=0;j<10;j++){
HSSFCell cell = row.getCell((short) j);
if(cell==null)
continue;
System.out.println("@@"+cell.getStringCellValue().toString());
}
}
}
catch (Exception e) {
System.out.println("已运行xlRead() : " + e);
}
}
}
作者:
笨狗
时间:
2005-05-26 18:15
标题:
我想用java怎么把EXCEL文件读出来?
发错版了吧
欢迎光临 Chinaunix (http://bbs.chinaunix.net/)
Powered by Discuz! X3.2