how to create new worksheet in excel without using report generation toolkit

[Jay_Ram]

Hi,

    Im trying to create an excel file with 8 worksheets. I'm currently using the write to spreadsheet file vi for this. But how do i create multiple worksheets in an excel file without using the NI's Report generation toolkit module?

Regards

Jay

[NitzZ · Accepted solution]

Hi,

You can use the property nodes with selected class as Activex Excel and create all the Excell tools. Check out the example attached.

Regards,
NizZ

(Give Kudos to Good Answers, Mark it as a Solution if your problem is Solved;)) 

[EvenDeejay]

Hi!

You can also check out this and this 

[Jay_Ram]

Thanks Nizz... Thats exatly what i wanted.

Regards

Jay