java怎么操作excel转xml文件importjava.io.FileInputStream;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.PreparedStatement;
importorg.apache.poi.hssf.usermodel.HSSFCell;
importorg.apache.poi.hssf.usermodel.HSSFRow;
importorg.apache.poi.hssf.usermodel.HSSFSheet;
importorg.apache.poi.hssf.usermodel.HSSFWorkbook;
/**
*
*@authorasima
*@data2006-10-18
*/
publicclassXlsToAccess
{
HSSFSheetglobalSheet=null;
/*读取一个指定单元格内容*/
publicStringreadCellValue(Stringpos)
{
intxpos;
shortypos;
intcellType;/*取得此单元格的类型0-Numeric,1-String,3-null*/
Stringresult;/*返回取得的单元格的值*/
ypos=(short)(pos.toUpperCase().charAt(0)-65);
xpos=Integer.parseInt(pos.substring(1,pos.length()))-1;
HSSFRowrow=null;/*定义excel中的行*/
HSSFCellcell=null;/*定义excel中的单元格*/
/*根据xPos和yPos取得单元格*/
row=globalSheet.getRow(xpos);
cell=row.getCell(ypos);
/****************此处如果是空需要修改***********************************/
cellType=cell.getCellType();
switch(cellType)
{
case0:/*0-Numeric*/
result=String.valueOf(cell.getNumericCellValue());
break;
case1:/*1-String*/
result=cell.getStringCellValue();
break;
case3:/*3-null*/
result=””;
break;
default:
result=””;
break;
}
returnresult;
}
/*读取excel文件并把内容插入到access表中*/
publicvoidinsertIntoTable()throwsException
{
//创建对Excel工作簿文件的引用
HSSFWorkbookworkbook=
newHSSFWorkbook(newFileInputStream(“D:/temp/test.xls”));
//获得一个sheet
globalSheet=workbook.getSheetAt(0);
Stringvalue1=readCellValue(“c1”);
Stringvalue2=readCellValue(“c2”);
Stringvalue3=readCellValue(“c3”);
Stringvalue4=readCellValue(“c4”);
System.out.println(value1);
System.out.println(value2);
/*插入数据库*/
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
Stringurl=”jdbc:odbc:asima”;
Connectionconn=DriverManager.getConnection(url);
PreparedStatementstmt=
conn.prepareStatement(“insertintocustomvalues(?,?,?,?)”);
//定义查询的SQL语句
stmt.setString(1,value1);
stmt.setString(2,value2);
stmt.setString(3,value3);
stmt.setString(4,value4);
stmt.executeUpdate