excel

[4303]

i am doing test automation of powersupply.i want to send the results of
different test cases to different sheets of same excel file.is there
any way to do that.

[TiTou]

Yes there is, it is not trivial but it is possible to it directly.

Go to the Excel thread, there you'll find links to all the interesting threads about excel ; you'll find lots of example and explanations.
Also, when in that Excel Board, if you do a search with "sheet" or "sheets" I'm sure you'll find what you need.

Hope this helps 😉

[bochog]

good day!!!

About your question, i think it is possible to save data on different sheets of excel. Have you tried to use ActiveX? You can use the "Automation Open" function of activeX to run excel application remotely. Through the use of "property node" and "invoke node", all properties and methods of excel can be controlled in LabVIEW including the writing of data on a specific sheets.

as an additional note, not all active x objects of excel 2000 are supported in excel 2003. therefore, better to decide what version  of excel you will use so that you can have a flexible report generation vi.

hope these infos will help you. good luck!!!!

[4303]

bochog wrote:
> good day!!!
>  
> About your question, i think it is possible to save data on different sheets of excel. Have you tried to use ActiveX? You can use the "Automation Open" function of activeX to run excel application remotely. Through the use of "property node" and "invoke node", all properties and methods of excel can be controlled in LabVIEW including the writing of data on a specific sheets.
>  
> as an additional note, not all active x objects of excel 2000 are supported in excel 2003. therefore, better to decide what version  of excel you will use so that you can have a flexible report generation vi.
>  
> hope these infos will help you. good luck!!!!
>  
>  


hi bochog thank u for u r reply.i tried both the property and invoke
nodes of active x of excel application but, i did not find those
things.can u send me a simple example of relating to it.

[TiTou]

As I said in my previous post, if you use the search engine you will fine many example VI posted.

Check this one posted by K C

Hope this helps