textradevices to excel -> setting sheet name

rbuser

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

rbuser

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

rbuser

If the user cannot load the output, how can he rename the sheet?

James Waler
Waler Ltd
http://www.waler.com

rbuser

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

rbuser

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

rbuser

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...
---------------------------------------------------------------------

rbuser

Thanks for the great explanation. I understand now and I will add the sheet name.

James Waler
Waler Ltd
http://www.waler.com

rbuser

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.)

rbuser

It should be available in a few days. Updates are free for current users.

James Waler
Waler Ltd
http://www.waler.com