Home Devices
New Blog Posts: Merging Reports - Part 1 and Part 2

textradevices to excel -> setting sheet name

edited February 2005 in Devices
Hi,

We use textradevices and reportbuilder.

One of our customers has a problem with our application in that before
he is able to load the output from the excel spreadsheet (created with
textradevices) is that he has to open the spreadsheet and rename the
sheet to (unfortunately) the default name 'sheet1'. Is this any property
within the textradevices whereby I can set the name of the sheet when
the report is output to an excel spreadsheet.

Or would I have to perform this function after the report (as an excel
spreadsheet) has been generated through ole type commands?

Thanks,
Tim C

Comments

  • edited February 2005
    Hi,

    The problem is the export format, this is Excel 4 format wich doesn't
    support multiple sheets and thus no sheet names. I would like to know if
    there's a solution to this as well!

    Greetings,

    Mark

  • edited February 2005
    If the user cannot load the output, how can he rename the sheet?

    James Waler
    Waler Ltd
    http://www.waler.com
  • edited February 2005
    Mark W wrote:

    I tried using early/late binding binding via ole (excel97, excel2000)
    and received different errors. Using early binding I get an old error
    800A03EC. I looked this up on the web but cant recall the exact reason.
    Using late binding I can change/set the sheet name, but then if you open
    into the excel it complains about the spreadsheet being damaged. Im am
    looking at other components to export reports in a native format.

    Tim C
  • edited February 2005
    James Waler wrote:

    Its not a case of being able to load the output... As far as the
    component goes in terms creating a excel spreadsheet - it does this fine
    - except that it is in an excel 4 format. If you load this spreadsheet
    into excel, again no problems, the name of the sheet is the same as
    filename.

    Now our customer has an application that takes the information from the
    excel spreadsheet and imports this data (for other purposes). For this
    to work successfully, the excel file (spreadsheet) needs to:

    1. have a worksheet.

    2. the worksheet needs to be named 'sheet 1' (or whatever the default
    name for excel).

    Having the name of the sheet, either non-existent or the name of the
    file does not work. Here the customer has the load the file into excel,
    set the name of the sheet (upgrading from version 4 to ???) before that
    data can be loaded into the other application.

    This is the problem that we are trying to overcome.

    Tim C
  • edited February 2005
    Hello there,

    I just thought you may want to have a look at eDocEngine as it supports
    exporting ReportBuilder reports to Excel *workbooks* (Excel 5). eDocEngine also
    provides an event that you can use to give your own names to worksheets.

    For the full feature trial version and documentation, please follow this link:
    http://www.gnostice.com/edocdownload.asp

    To get a quick feel of eDocEngine and to export your own reports (.RAF files),
    please try the EXE demo:
    http://www.gnostice.com/download/v200p/edocpdfv2_demo.zip

    --
    Girish Patil
    Gnostice Information Technologies www.gnostice.com
    ---------------------------------------------------------------------
    Gnostice eDocEngine (http://www.gnostice.com/edoc_engine.asp) -
    Electronic document creation, Report Export, PDF eForms creation...

    Gnostice PDFtoolkit (http://www.gnostice.com/pdftoolkit.asp) -
    View, Print, Convert, Modify, Enhance PDF docs, process PDF eForms...
    ---------------------------------------------------------------------

  • edited February 2005
    Thanks for the great explanation. I understand now and I will add the sheet name.

    James Waler
    Waler Ltd
    http://www.waler.com
  • edited February 2005
    Thanks. Any idea on timing as to when this functionality would be available?

    Tim C

    PS. We use one of the earlier versions of extra devices. Would I have
    access to the updated version? Or would an upgrade need to be purchased?
    (As soon as I find out what version we have, I will email you the details.)

  • edited February 2005
    It should be available in a few days. Updates are free for current users.

    James Waler
    Waler Ltd
    http://www.waler.com
This discussion has been closed.