Is there any method to delete a worksheet using Report generation toolkit.

[cancancanopen]

Hello,

I have a excel report, everytime when I open this report a worksheet gets added to the report. 

Is there any way to delete worksheetm rather any worksheet. 

Thanks in advance,

[Viru]

Hi cancancanopen:

I don't know exactly what's your software doing? But if you want to delete the worksheet from your excel report then check the below image. It might give you some idea to deal with excel.

Thanks

[cancancanopen]

Hello Viru,

I cannot see any image.

[Viru · Accepted solution]

I posted the whole code on my last reply.

Please check attached.

Thanks

[cancancanopen]

Hello Viru,

Why am I getting error saying  you are passing null refnum ?

[Viru]

Check Attached VI.

It is required to open LabVIEW 8.0 or newer.

Thanks

[aeastet]

You need a reference to Excel and the Workbook that you are using. Look at this forum it should help.

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

[Viru]

Hi Everyone:

I donot figure out what's problem but it is working in my system. So let me know what is the exact problem.

Thanks

[aeastet]

Try this

[cancancanopen]

Hello,

@ Viru Extremely sorry, it was my programming error, I got the solution thanks.

@  aeastet Thanks for the link.