Previous releases of PowerBuilder allow you to save DataWindow and graph data in Excel5 and Excel8 format, but with PowerBuilder 11.5.1 you can also save DataWindow and graph data in .XLSX and .XLSB (Excel12) format, with or without column headers. Because .NET Framework 3.0 or later must be installed on development and runtime computers to use this functionality, you cannot save data in these formats on Windows 2000 computers.
Other than the Windows 2000 platform restriction, the same
level of support is provided as for Microsoft Office 2003. You can
use the PowerScript SaveAs command with graphs
or DataWindow controls to save data to Excel 2007 formats by setting
the saveastype argument to XLSX! or XLSB! You
can also export DataWindow data to Excel 2007 formats by selecting
one of the Excel12 items from the drop-down list in the Save As
dialog box that displays when you select the Save Rows As menu item
in the DataWindow painter.
Excel 2007 support is dependent on the following strongly named assemblies:
Sybase.PowerBuilder.DataWindow.Excel12.dll This assembly is installed in the GAC.
PBDWExcel12Interop115.dll This assembly is installed in the Sybase/Shared/PowerBuilder directory.
These DLLs are deployed by the Runtime Packager when you select the the MS Excel12 Support check box.
