From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
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?
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.
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