Results 1 to 4 of 4

Thread: LibXL with VPE4VDF

  1. #1
    Join Date
    Feb 2009
    Posts
    1,039

    Default LibXL with VPE4VDF

    Has anyone succeeded to integrate LibXL from StarZen with VPE4VDF reports. I tried today but got stuck.
    Bengt

  2. #2
    Join Date
    Feb 2009
    Location
    Stuart, FL
    Posts
    5,321

    Default Re: LibXL with VPE4VDF

    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

  3. #3
    Join Date
    Feb 2009
    Posts
    1,039

    Default Re: LibXL with VPE4VDF

    Click image for larger version. 

Name:	VPEreport.jpg 
Views:	87 
Size:	46.9 KB 
ID:	13231

    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

  4. #4
    Join Date
    Feb 2009
    Location
    Stuart, FL
    Posts
    5,321

    Default Re: LibXL with VPE4VDF

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •