java excel xml_如何在Java中将Excel转化为XML格式文件

packagetest;importjava.io.File;importjava.io.FileInputStream;importjava.io.FileNotFoundException;importjava.io.FileOutputStream;importjava.io.IOException;importjava.io.InputStream;importjava.io.OutputStreamWriter;importjava.io.UnsupportedEncodingException;importjava.util.ArrayList;importjava.util.List;importorg.junit.Test;importcom.sppm.kds.entity.Policy;importjxl.Cell;importjxl.Sheet;importjxl.Workbook;public classImportTest {

@Testpublic voidtest01(){

File file= new File("E:\\import\\语料.xls");

readExcelAddXML(file,"E:\\import");

}public voidreadExcelAddXML(File f,String path){

OutputStreamWriter pw= null;try{

List list =readExcelFileOutList(f);//String tempFile = "E:\\import\\test.xml";

File file = new File(path,"tianlong.xml");if (!file.exists()) {

file.createNewFile();

}//确认流的输出文件和编码格式，此过程创建了“test.txt”实例

pw = new OutputStreamWriter(new FileOutputStream(file),"utf-8");

pw.write(""+"\n");

pw.write(""+"\n");

pw.write(""+list.size()+""+"\n");

pw.write(""+"\n");for(int i=0;i

pw.write(""+"\n");

pw.write(""+list.get(i).getId()+""+"\n");

pw.write("

"+list.get(i).getTitle()+""+"\n");

pw.write(""+list.get(i).getDepatment()+""+"\n");

pw.write(""+list.get(i).getRelease_date()+""+"\n");

pw.write(""+list.get(i).getTimeliness()+""+"\n");

pw.write(""+list.get(i).getProvince()+""+"\n");

pw.write(""+list.get(i).getCategory()+""+"\n");

pw.write(""+list.get(i).getEffect_level()+""+"\n");

pw.write(""+list.get(i).getSource()+""+"\n");

pw.write(""+list.get(i).getContent()+""+"\n");

pw.write(""+list.get(i).getPost_date()+""+"\n");

pw.write(""+list.get(i).getIssued_number()+""+"\n");

pw.write(""+list.get(i).getImplement_date()+""+"\n");

pw.write("");

pw.flush();

}

pw.write("\n"+"");

pw.flush();

}catch(UnsupportedEncodingException e) {

e.printStackTrace();

}catch(FileNotFoundException e) {

e.printStackTrace();

}catch(IOException e) {

e.printStackTrace();

}finally{try{

pw.close();//关闭流

} catch(IOException e) {

e.printStackTrace();

}

}

}private static ListreadExcelFileOutList(File f) {

System.out.println("进入到readExcelFileOutList()");

List list = new ArrayList();

InputStream is= null;try{

is= newFileInputStream(f);

Workbook rwb=Workbook.getWorkbook(is);//获得总的Sheets，得到sheet的层数

Sheet[] sheets =rwb.getSheets();int sheetLen =sheets.length;//获得第一个Sheets 的结果

jxl.Sheet rs = rwb.getSheet(0);int num_row = rs.getRows();//得到行数

int num_column=rs.getColumns();//得到列数

System.out.println("行:"+num_row+"列:"+num_column);for(int j=1;j < num_row ;j++){

Cell[] cell= rs.getRow(j);//得到第j行的所有值

for(int column_index=0;column_index

String id= cell[column_index++].getContents();

String title= cell[column_index++].getContents();

String department= cell[column_index++].getContents();

String release_date= cell[column_index++].getContents();

String timeliness= cell[column_index++].getContents();

String province= cell[column_index++].getContents();

String category= cell[column_index++].getContents();

String effect_level= cell[column_index++].getContents();

String source= cell[column_index++].getContents();

String content= cell[column_index++].getContents();

String post_date= cell[column_index++].getContents();

String issued_number= cell[column_index++].getContents();

String implement_date= cell[column_index++].getContents();

list.add(newPolicy(id, title, department, release_date, timeliness, province, category, effect_level, source, content, post_date,issued_number,implement_date));

}

}

}catch(Exception ex) {

ex.printStackTrace();

}finally{try{if(is != null) is.close();

}catch(IOException e) {

e.printStackTrace();

}

}returnlist;

}

}