有的时候真的是很特别,要去你生成xml格式的excel,这个是将excel转成xml,也可以直接生成,下篇我们来写直接生成的代码。代码不要照抄,有些你不需要的删除掉就好。
//将excel转换成xml格式的excel
public void convertExcelToXml(InputStream in,OutputStream out) throws Exception {
Document document = DocumentHelper.createDocument();
Element workBook = document.addElement("Workbook", "urn:schemas-microsoft-com:office:spreadsheet");
workBook.addAttribute("xmlns:o","urn:schemas-microsoft-com:office:office");
workBook.addAttribute("xmlns:x","urn:schemas-microsoft-com:office:excel");
workBook.addAttribute("xmlns:ss","urn:schemas-microsoft-com:office:spreadsheet");
workBook.addAttribute("xmlns:html","http://www.w3.org/TR/REC-html40");
Element styles = workBook.addElement("Styles");
styles.addElement("Style").addAttribute("ss:ID", "Default").addAttribute("ss:Name", "Normal");
Element style = styles.addElement("Style").addAttribute("ss:ID", "s15");
style.addElement("Alignment").addAttribute("ss:Vertical", "Bottom");
style.addEle