SAP Knowledge Base Article - Preview

2001779 - Microsoft Excel cannot open the XLSX saved by SaveAs containing the ASCII control code

Symptom

When the PowerBuilder application saves Data Window as XLSX format using the SaveAs function, Microsoft Excel cannot open the generated XLSX file.
Excel raised following error.

"Excel found unreadable content in 'xxx.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

This problem occurs, when the ASCII control code(except for TAB, LF and CR.) is contained in a string data of Data Window.


Read more...

Environment

  • SAP PowerBuilder 12.x

Product

PowerBuilder 12.5 ; Sybase PowerBuilder 12.0

Keywords

PowerBuilder, SaveAs, Excel, XLSX, ASCII  control code, CR, 760085 , KBA , BC-SYB-PB , PowerBuilder , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.