How to speed Excel data dump?

[LVLV]

Hi,

It takes a long time to dump data into Excel (2003) spread sheet during data dump (test report). I need to speed up the process.

1)  How can I disable the update property of Excel (that may help speed the dumping data process...).

2)  I would like to turn off viewing of the  Excel spreadsheet (but dupming data in the background), that may help or not? How can I do that, and which VIs from the library can I use, any sample code?

I am using LabVIEW version 7.1 on XP.

Thanks for your help.

LVLV

[JohnBoy]

I've attached a vi showing how to turn off viewing of Excel (that is, make it invisible). Wire the appropriate control to False, for not visible.

[smercurio_fc]

To answer the first question, access the "EnableCalculation" property of the worksheet object.

[Michael_Munroe]

To answer the first question, set the ScreenUpdating property of the Application object to false.

[chilly_charly]

LVLV,

Could you tell us the improvement, if any, obtained after these optimisations ?

Thanks,

[LVLV]

Thank you all, it worked great.....

-LVLV

[Mathieu04]

Hello everybody,

I've the same problem using LabWindows.

I don't know how to disable the sreenupdating property.

Can you help me please ?

Thanks

Mathieu

[smercurio_fc]

Well, in terms of Excel, it's the same property/method. In terms of using ActiveX with LabWindows, you're better off asking this question in the LabWindows forum. This is the LabVIEW forum. LabVIEW is the graphical programming language.