Using Labview how can one store different data in different sheets of same excel file, I mean how to select different sheets to store data??

[Sim5]

Hello Everyone,

I want to store various data but in different sheets of excel file. So how to select Different sheets of same excel file???

Thanks so much 

Pallavi 

[Sim5]

Hello Everyone,

For above question, one more addition without using active X and report generation toolkit... Is it possible to select different sheets of same excel file?? 

Thanks a lot...

Pallavi 

[PaulG.]

No. I do not believe you can access different sheet data from Excel without Active-X. AX is integral to Microsoft Office.

[smercurio_fc]

You can also use ADO. Don't know if it works with the newest versions of Excel.

If you do a search on this forum for "ADO Excel" you'll find some threads on the topic.

Message Edited by smercurio_fc on 11-13-2009 07:53 AM

[aeastet]

Why do you not want to use Active X?

[Sim5]

Hi,

Thanks so much... You have an example how to use active X then... So i can do it... I tried but unable to get output. So....

I want to store data from spectrum analyzer  into different sheets...

Thanks once again....

Pallavi 

[Sim5]

I dont want to use active X as i am not getting results... by using write to spreadsheet in am getting results but on just one sheet... I want different data on different sheets of same excel file. So....

Can anyone help me in this...

Thanks so much...

Pallavi 

[smercurio_fc]

---

aeastet wrote:
Why do you not want to use Active X?

---

One very good reason that I can think of is that MS keeps changing their ActiveX interface with each version of Excel, so code written for one version of Excel using ActiveX may not work for another version of Excel, even though the basic functionality hasn't changed. A perfect example is when MS changed the "Value" property to "Value2". Yeah, that made a whole lot of sense.

---

pals wrote:

I dont want to use active X as i am not getting results... by using write to spreadsheet in am getting results but on just one sheet... I want different data on different sheets of same excel file. So....

Can anyone help me in this...

---

Then it's something you're doing. Please post your code. Have you tried a search on this forum for ActiveX and Excel? There have been tons of posts on it, including lots of examples. There's also the Excel thread.

[Sim5]

SORRY FOR THE MISTAKE.... I WANT TO USE IN LABVIEW SO.... ACTIVE X OR OTHER OPTION.....

[aeastet]

Here is the one to get the data

This one processes the data

You can also look through this forum

http://forums.ni.com/ni/board/message?board.id=BreakPoint&thread.id=2391&view=by_date_ascending&page...