>I would like to generate a report in XLS format using Foxypreviewer without showing toolbar (not preview)
>I am trying this way
>
>
>DO FOXYPREVIEWER.APP
> _Screen.oFoxyPreviewer.lSaveAsXLS = .T.
> _Screen.oFoxyPreviewer.lDirectPrint = .T.
> _Screen.oFoxyPreviewer.cDestFile = m.nmplanilha
>REPORT FORM myreport
>
>
>But the XLS file is not generated
>
>Is there way to do this?
Olá Carlos
Try this way:
DO FOXYPREVIEWER.APP
REPORT FORM TeuReport OBJECT TYPE 13 TO FILE (m.nPlanilha)
This is all documented in FoxyPreviewer.
Make sure to use the latest version, because many new enhancements have been added in the XLS output recently.
There is a sample in the main folder, called "MakeXLS". You may find it helpful to look at it as well
Abraço
César