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();