DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=43949>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND·
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=43949
Summary: corrupted damaged xls file (corrupted, excel repairs it
during opening)
Product: POI
Version: 3.0
Platform: Other
OS/Version: other
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: dersim@gmx.de
Hello.
My POI-Version: poi-bin-3.0.1-FINAL-20070705.zip
I've generated XLS-File with:
try {
HSSFWorkbook wb = new HSSFWorkbook();
HSSFCellStyle styleDate = wb.createCellStyle();
styleDate.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy"));
if (result != null) {
// create a new sheet
HSSFSheet s = wb.createSheet();
// declare a row object reference
HSSFRow r = null;
// declare a cell object reference
HSSFCell c = null;
wb.setSheetName(0, "RemovalInstallationList");
// first row with headings
r = s.createRow(0);
c = r.createCell((short) 0);
c.setCellValue(new HSSFRichTextString("Three Letter Code"));
....
c = r.createCell((short) 37);
c.setCellValue(new HSSFRichTextString("Description"));
s.setColumnWidth((short) (0), (short) ((50 * 4) / ((double) 1 / 20)));
....
s.setColumnWidth((short) (37), (short) ((50 * 4) / ((double) 1 / 20)));
Iterator it = result.iterator();
for (int i = 0; it.hasNext(); i++) {
RemovalInstallationReportResultRowModel resultModel = null;
resultModel = (RemovalInstallationReportResultRowModel) it.next();
// create a row with data
r = s.createRow(i + 1);
c = r.createCell((short) 0);
if (resultModel.getThreeLC() != null) {
c.setCellValue(new HSSFRichTextString(resultModel.getThreeLC()));
} else {
c.setCellValue(new HSSFRichTextString(""));
}
....
c = r.createCell((short) 37);
if (resultModel.getDescriptionPartNoInstalledComponent() != null) {
c.setCellValue(new
HSSFRichTextString(resultModel.getDescriptionPartNoInstalledComponent()));
} else {
c.setCellValue(new HSSFRichTextString(""));
}
}
return new RemovalInstallationReportCSVModel(Status.OK, wb.getBytes());
}
calling method:
byte[] resultAsByte = csvModel.getTransferObject();
if (result != null) {
inputStream = new ByteArrayInputStream(resultAsByte);
}
input();
return "exportCSV";
Struts-Config.xml
<result name="exportCSV" type="stream">
<param name="contentType">application/vnd.ms-excel</param>
<param name="inputName">inputStream</param>
<param name="contentDisposition">filename="document.xls"</param>
</result>
The result is a message from Excel during opening the file like:
Microsoft Excel Datei-Reparatur Protokoll
In Datei 'D:\tmp\exported_file_damaged_231107.xls' wurden Fehler festgestellt
Die folgenden Reparaturen wurden durchgeführt:
Die Zusammenfassungs-Information des Dokumentes ist verloren gegangen.
The resulting exported file is attached.
Kind regards.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
|