how create work sheet at defined index inside workbook of Excel in labview

[mukesh121]

hi all,

how create work sheet at defined index inside workbook of Excel in labview.

Excel programming 

how to add worksheet  at  any index( 0, 1,....n)  inside workbook   using labview.

Thanks & Regards

Mukesh Kumar

[LV_user1]

YOu can use activex controls to perform many operations on the excel.

Adding worksheet to the workbook is one of them.

Using property and invoke nodes you can do this.

[P@Anand]

If you are using Report generation toolkit its pretty easy to add worksheet and also you can play a lot. ActiveX method is one another way you can do the same, actually many.

[Hooovahh]

Another option depending on your situation is to create a TDMS file, where each group is a workbook.  Then convert that to Excel using the free addon by NI.  Here is one example of how that could work.  

Of course you don't have much control with this method and without knowing more about what you want to do I'd recommend the report generation toolkit.  It comes with the developer suite if you have that.