I want to create a excel file with one work-book

[Zhichao Chen]

and Only one worksheet.
How can I do? I know we can use excel ActiveX in labVIEW.
But hen I create the excel file, it always
has 3 worksheet.

[Dennis_Knutson]

The default for Excel is to have 3 sheets in a new workbook. You can change this in Tools>Options>General. If you want to programatically delete a sheet, use the Delete method.

[Zhichao Chen]

If I delete the worksheet, Excel will
prompt whether I make sure. I don't like the popup dalog box

[Ivaylo Iltchev]

Use Excel.Application.DisplayAlerts = false

"bunny" wrote in message
news:506500000005000000BD220000-986697009000@quiq.com...
> If I delete the worksheet, Excel will
> prompt whether I make sure. I don't like the popup dalog box

[Gorka Larrea]

There's an activeX call in a property node called SheetsInNewWorkbook, set this to one and it's done. But don't forget to set it to default value at the end, if you want Excel to create workbooks with that number of sheets, the change is "forever". If you have problems, I can send you an example.

[Zhichao Chen]

Thank you. Please sent me your example.
It is urgent for me.

[Zhichao Chen]

I can't find the prooerty node you mentioned.
Could you give me a example?

[Zhichao Chen]

I am looking forward to seeing your example.
You can email to zhichao_chen@Yahoo.com

[Gorka Larrea]

I've posted the example but the mail was returned, you could take the example from this page (posted already) or provide me a valid e-mail address.

[Gorka Larrea]

Here's the example, it simply makes Excel visible and creates a workbook with one worksheet. It's made with LabVIEW 5.0.1f1 and Excel 97, for further versions of Excel, or earlyer ones, the property nodes may change, so check them. And of course, you can continue wiring more and more property and invoke nodes to do anything you could do with Excel. Good luck and hope this helps, if need more help, just write.