java中,将stringWriter中的内容写入excel,如果超过65536行,将会被自动截掉,各位老大有没有什么办法写成多个sheet,部分代码如下:StringWriter sWriter = new StringWriter();
StringWriter textTarget = new StringWriter();
FormatConverter.convertXML2EXCEL(
new InputStreamReader(new FileInputStream(new File(currDir, "genhtml.xslt")), "UTF-8"),
new InputStreamReader(new FileInputStream(new File(currDir.getParent(), "exBodyFoot.xslt")), "UTF-8"),
sWriter); StringReader sReader = new StringReader(sWriter.getBuffer().toString());
FormatConverter.convertXML2EXCEL(
xml, sReader,
textTarget); sWriter.close();
sReader.close(); binaryOut = response.getOutputStream();
binaryOut.write(textTarget.getBuffer().toString().getBytes("UTF-8"));
binaryOut.close();
StringWriter textTarget = new StringWriter();
FormatConverter.convertXML2EXCEL(
new InputStreamReader(new FileInputStream(new File(currDir, "genhtml.xslt")), "UTF-8"),
new InputStreamReader(new FileInputStream(new File(currDir.getParent(), "exBodyFoot.xslt")), "UTF-8"),
sWriter); StringReader sReader = new StringReader(sWriter.getBuffer().toString());
FormatConverter.convertXML2EXCEL(
xml, sReader,
textTarget); sWriter.close();
sReader.close(); binaryOut = response.getOutputStream();
binaryOut.write(textTarget.getBuffer().toString().getBytes("UTF-8"));
binaryOut.close();
我是菜鸟,望高手指教
超過的new 一個sheet