用JAVA将EXCEL文件解析存入ORACLE数据库
用用JAVA实现将EXCEL文件解析存入ORACLE数据库
大家有好的办法吗？请高手指点一下，谢谢！
[解决办法]
poi读取excel文件，执行业务后存入oracle
[解决办法]
标记下 有空 解决这个 现在忙
[解决办法]
2楼正解
[解决办法]
用jxl也行
[解决办法]
用jxl的优势可能要比poi好一点,我建议是使用jxl
[解决办法]
jxl
[解决办法]
楼主可以试一下jxls 是一个支持excel模板填充的开源软件
[解决办法]
有一个将excel文件转换成文本的例子，参考
import jxl.*;
import java.io.*;
import java.util.*;
public class ExcelToTxt
{
private String filePath=""; ///文件路径
private InputStream inputStream; ///输入流
private Workbook workbook; ///excel文件
private Sheet sheet; ///sheet
private Cell cell; ///元素
private String znkh; ///智能卡号
List list = new ArrayList();
private int rowCount; ///行总数
private int colCount=30; ///列总数
private int colIndex; ///列
static public String vStr = ""; ///信息
public ExcelToTxt()
{
}
public ExcelToTxt(File file) {
try{
inputStream = new FileInputStream(file);
}catch(Exception e){
System.err.println("*****************ImportZnk manager is error!******"+e.getMessage());
}
}
public void setInputStream(File file){
try{
inputStream = new FileInputStream(file);
}catch(Exception e){
System.err.println("*************ImportZnk setInputStream is error!******"+e.getMessage());
}
}
private void getworkBook(){
try{
workbook = Workbook.getWorkbook(inputStream);
inputStream.close();
}catch(Exception e){
e.printStackTrace();
}
}
private void getsheet(){
if (workbook == null)
getworkBook();
sheet = workbook.getSheet(0);
}
public int getrowCount(){
if (sheet == null)
{getsheet();}
rowCount = sheet.getRows();
return rowCount;
}
public int getcolCount() {
return sheet.getColumns();
}
/*
public List getZnkh(int rowIndex){
if (sheet == null)
{getsheet();}
for(int i=0;i<colCount;i++){
cell = sheet.getCell(i,rowIndex);
znkh = cell.getContents();
list.add(i,znkh);
}
return list;
}
*/
public String getCell(int rowIndex,int colIndex) {
cell = sheet.getCell(colIndex,rowIndex);
return cell.getContents();
}
public void workbookClose(){
if(workbook != null){
workbook.close();
}
}
public static void main(String[] args) throws Exception
{
String outFilePath = "d:\\cxt\\outr.txt"; //输出文件
File outFile = new File(outFilePath);
FileWriter o = new FileWriter(outFilePath);
String filePath="d:\\cxt\\memberr20060904.xls" ;
File file = new File(filePath);
ExcelToTxt imznk = new ExcelToTxt(file);
String s="";
//总共40列
//o.write("var ");
//String[] names = {"email","re_email","auth1","auth2","nativeDisplay","latinGiven","latinFamily","defaultName","gender","genderShowTag","currentCountry","currentProvince","currentCity","field","subField","currentStatus","wk_company","wk_position","wk_positionEnum","wk_start_date_Y","wk_start_date_M","wk_end_date_Y","wk_end_date_M","wk_tillNow","wk_dateShowTag","wk_country","wk_province","wk_school","wk_academy","st_country","st_province","st_school","st_academy","st_major","st_start_date_Y","st_start_date_M","st_end_date_Y","st_end_date_M","st_degree","acceptTerms"};
String[] names = {"email","re_email","auth1","auth2","nativeDisplay","latinGiven","latinFamily","defaultName","gender","genderShowTag","currentCountry","currentProvince","currentCity","field","subField","currentStatus","wk_company","wk_position","wk_positionEnum","wk_start_date_Y","wk_start_date_M","wk_tillNow","wk_dateShowTag","wk_country","wk_province","wk_school","acceptTerms"};
for(int i=0;i<imznk.getrowCount();i++)
{
String line = "dataArr["+i+"]=\"";//dataArr[0]=
for ( int j = 0 ; j < imznk.getcolCount() ; j++ )
{
s=imznk.getCell(i,j);
if (s == null || s.length() == 0)
{
s+=" ";
}
//line += names[j]+"="+imznk.getCell(i,j)+"&"; //取出内容，组合字符串
line += names[j]+"=" + s +"&";
}
line=line.substring(0,line.length() -1);//去掉最后的&
line+="\"";//加上 "
line+=";";//加上;
o.write(line+"\n");//换行
o.flush();
System.out.println(line);
}
o.close();
imznk.workbookClose();
}
}
[解决办法]
mark,我是来学习的
