PDF to Excel

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Amritha.Datta@gmail.com

    #1

    PDF to Excel

    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

    #2
    Re: PDF to Excel

    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.


    Comment

    • Plamen Ratchev

      #3
      Re: PDF to Excel

      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.Ex portOptions.Exp ortFormatType =
      CrystalDecision s.[Shared].ExportFormatTy pe.PortableDocF ormat

      To generate an Excel file you just change it to:
      ReportObject.Ex portOptions.Exp ortFormatType =
      CrystalDecision s.[Shared].ExportFormatTy pe.Excel

      Regards,

      Plamen Ratchev



      <Amritha.Datta@ gmail.comwrote in message
      news:1167750957 .123210.237010@ 48g2000cwx.goog legroups.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.
      >

      Comment

      • Amritha.Datta@gmail.com

        #4
        Re: PDF to Excel

        That works! Thank you all


        Plamen Ratchev wrote:
        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.Ex portOptions.Exp ortFormatType =
        CrystalDecision s.[Shared].ExportFormatTy pe.PortableDocF ormat
        >
        To generate an Excel file you just change it to:
        ReportObject.Ex portOptions.Exp ortFormatType =
        CrystalDecision s.[Shared].ExportFormatTy pe.Excel
        >
        Regards,
        >
        Plamen Ratchev

        >
        >
        <Amritha.Datta@ gmail.comwrote in message
        news:1167750957 .123210.237010@ 48g2000cwx.goog legroups.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.

        Comment

        Working...