Adding Worksheets to an Excel File

[Jeff - PPL]

Is it possible to send data to two different worksheets in an excel file? For example, I have raw data and then calculations from that raw data. Right now I have the raw data being sent to the excel file. I would like to be able to send the calculation results to the same file but a new worksheet. Is this possible?

Thanks

[Doug (CapeFl)]

Yes, you'll just have to separate the raw and calculated data into 2 different 'write' functions where you programically have each set written to its own worksheet. There are good answers on how to send data to a new Excel worksheet. Look at the attached link and see if they fit your need, or at least give you some ideas.

http://exchange.ni.com/servlet/ProcessRequest?RHIVEID=101&RPAGEID=135&HOID=506500000008000000B1240000&UCATEGORY_0=_49_%24_6_&UCATEGORY_S=0

Good luck with it,
Doug

[Spencer]

In a similar thread from a few days ago:
Albert Geven wrote:
> You can also download from the developer zone our excel (goop)
>library.
>search for philips and you'll find it.

We've used this with good success for creating multiple worksheets. If you
like goop, its great. It may be worth a look for you. It's at this link
http://zone.ni.com/devzone/devzoneweb.nsf/opendoc?openagent&42E12CDCDBD1C682
8625699D004EEFA8&cat=9C6DF90777E5A78206256874000FA14E

Spencer


"Jeff - PPL" wrote in message
news:50650000000800000001250000-993342863000@exchange.ni.com...
> Is it possible to send data to two different worksheets in an excel
> file? For example, I have raw data and then calculations from that
> raw data. Right now I have the raw data being sent to the exc
el file.
> I would like to be able to send the calculation results to the same
> file but a new worksheet. Is this possible?
>
> Thanks