PDF to Excel

[Amritha.Datta]

Is it possible to convert PDF data report to excel thru VB.NET?

Currently I am generating PDF report in my application using crystal.
The requirement is to also generate the same report in Excel. I know we
can do this by creating Excel template and filling the template with
required data. But wondering if there is any easy way to conver the PDF
report to Excel thru API calls.


Thanks in advance.

 

[Ken B]

Is it possible to convert PDF data report to excel thru VB.NET?

Currently I am generating PDF report in my application using crystal.
The requirement is to also generate the same report in Excel. I know we
can do this by creating Excel template and filling the template with
required data. But wondering if there is any easy way to conver the PDF
report to Excel thru API calls.

You can export to Excel from Crystal Reports.

 

[Plamen Ratchev]

If you already use Crystal Reports to generate PDF reports then you can use
Crystal to generate your Excel reports too. For example:

To generate PDF you probably use this:
ReportObject.ExportOptions.ExportFormatType =
CrystalDecisions.[Shared].ExportFormatType.PortableDocFormat

To generate an Excel file you just change it to:
ReportObject.ExportOptions.ExportFormatType =
CrystalDecisions.[Shared].ExportFormatType.Excel

Regards,

Plamen Ratchev
http://www.SQLStudio.com

 

[Amritha.Datta]

That works! Thank you all

If you already use Crystal Reports to generate PDF reports then you can use
Crystal to generate your Excel reports too. For example:

To generate PDF you probably use this:
ReportObject.ExportOptions.ExportFormatType =
CrystalDecisions.[Shared].ExportFormatType.PortableDocFormat

To generate an Excel file you just change it to:
ReportObject.ExportOptions.ExportFormatType =
CrystalDecisions.[Shared].ExportFormatType.Excel

Regards,

Plamen Ratchev
http://www.SQLStudio.com

Is it possible to convert PDF data report to excel thru VB.NET?

Currently I am generating PDF report in my application using crystal.
The requirement is to also generate the same report in Excel. I know we
can do this by creating Excel template and filling the template with
required data. But wondering if there is any easy way to conver the PDF
report to Excel thru API calls.


Thanks in advance.