Report: Excel Format and PDF.

[Jefferson.sn]

Good morning everybody this is my first post.
I would like to know if exist some component to "convert" a reporter that was made using excel format (ExcelAPP and other's) to PDF.
Nowadays we create (in the company that I work) the reporters in a PDF format using a kind of command's that look like pixel's.

For example, in the dot.net platform they has a kind of component that convert the excel format to PDF format.

If my question doesn't look so clear please let me know, English isn't my native language.
Best regards,
Jefferson Nascimento

 

[Jefferson.sn]

I'v heard some comments about a kind of library called vpxPrint or xprint(something near of it).
Anyway have already use?

 

[Mike Clark]

Hi

We use vpXprint 8 to develop/create print files in PDF format and find it very useful.

They are at
www.4gl.fr

Regards
Mike

 

[Jefferson.sn]

Thanks Mike the link was very useful.

I found a solution to my problem.

/* Program created by Jefferson S nascimento. 12/11/2010 São Paulo - Brazil
Generating PDF via excel(only work with version 2007 or 2010)

*/

DEF VAR excelAPP AS COM-HANDLE NO-UNDO.
DEF VAR chworkbook AS COM-HANDLE NO-UNDO.
DEF VAR m-caminho AS CHAR NO-UNDO.

m-caminho = "C:\tmp\".

CREATE "Excel.Application" excelAPP.
excelAPP:VISIBLE = FALSE.
chworkbook = excelAPP:workbooks:ADD.
excelAPP:Range("A1"):VALUE = "Test".
excelAPP:Range("C10"):VALUE = "Using Excel to convert to PDF".

chworkbook:ExportAsFixedFormat(0,m-caminho + "Test",0,true,,,,,) no-error.


RELEASE OBJECT excelAPP NO-ERROR.
RELEASE OBJECT chworkbook NO-ERROR.

 

[joey.jeremiah]

Hello Lee,

You might want to check the free DocxFactory project for generating both Excel and Word files, and covnverting them to PDF or another file formats.

Disclosure: I wrote the project.

Alon