Has anyone succeeded to integrate LibXL from StarZen with VPE4VDF reports. I tried today but got stuck.
Bengt
Has anyone succeeded to integrate LibXL from StarZen with VPE4VDF reports. I tried today but got stuck.
Bengt
what exactly are you trying to do?
Michael Salzlechner
StarZen Technologies, Inc
http.://www.starzen.com
IT Director at Balloons Everywhere
Development Blog
http://www.salzlechner.com/dev
DataFlex Package Manager (aka Nuget for DataFlex)
http://windowsdeveloper.com/dfPackage
In VPE-reports when choosing Export, I would like to have a new alternative "Excel file". I often add another alternative, semicolon separated csv-file which easily can be opened in Excel, but with them it is not possible to format the cells, make several sheets and other Excel possibilities. It would be much better to have the possibility to write .xlsx-files.
I tried to create the .xlsx-file in Procedure RunReport. I succeded to create the file, but when I tried to close it at the end of the procedure I got a curious error.
Bengt
you have a few options
you can set the export type to custom and then override the following
OpenExportFile
DoExportString
DoExportEOL
CloseExportFile
or you can override methods at other points
here is some info on exports
at the beginning OpenExportFile is called and at the end CloseExportFile
for each row the following are called inside RequestExportRow
OnBeforeRowExport
DoExportFieldNames (if enabled and not exported yet)
ExportAllSubheaders
ExportBody
ExportAllSubtotals
DoExportEOL
OnAfterRowExport
when exporting data each sections DoExportSection is called
Michael Salzlechner
StarZen Technologies, Inc
http.://www.starzen.com
IT Director at Balloons Everywhere
Development Blog
http://www.salzlechner.com/dev
DataFlex Package Manager (aka Nuget for DataFlex)
http://windowsdeveloper.com/dfPackage