#117 When using ExcelExporter, generated xls file has errors.
Hi,
I have problems trying to export data to excel files. It loses formating and sometimes even values. I tried loading the generated file back into another spereadsheet and i get the following error.
An error occurred while evaluating function "s:getCellOuterAttrs"
If i extend the exporter to add onFailure and onSuccess it reports a success.
The versions used are
zk-bin-3.5.2
zk-zss-bin-1.0.0-RC1
My example
The zul contains
<zk>
<window title="checking">
<spreadsheet id="function" use="MySpreadsheet" url="/function.xls" maxrow="40" maxcolumn="20" height="600px" width="908px"/>
<button label="click me" onClick="function.write()" />
</window>
</zk>
My spreadsheet class is as follows
public class MySpreadsheet extends Spreadsheet {
public void write() {
ExcelExporter ee = new RupeeExcelExporter();
File file = new File(
Executions.getCurrent().getDesktop().getWebApp().getRealPath("/generated.xls"));
ee.exports(getBook(), file);
Spreadsheet s = new Spreadsheet();
s.setSrc("/generated.xls");
s.setParent(getParent());
}
}
Excel 2007 says there is a data error in the file generated.xls
I have attached the generated.xls file. The function.xls file is the same as the one used in the zssfunction demo from smalltalks.
The file generated by excelexporter