Excel handling with ActiveX

[andreas_p]

Hi,

I know there is thousands of posts about Excel but I have not found a solution to my problem so here it goes. I want to be able to load a excel file, present it in a table on the front panel, and manipulate the cells any way I want and then be able to save the sheet with the new values or whatever. So basically a simple form of Excel. I should mention that I am able to load a file and view it. But I can not figure out the way to write to the sheet. I mean you either have read or write, not both at the same time. Or am I missing something here? And I know you can write to specific cells but I want to be able to interact just with the table, not have to specify "ok I want to write a 3 in cell B5" with 5 different property nodes or whatever. I use ActiveX btw.

Best regards

Andreas

[F._Schubert]

You should be able to show Excel inside an ActiveX container (use the front panel Controls to load it instead of Automation Refnum on the BD). Then the user can directly interact with excel.

The other option would be to have your own (LabView) table and use the .csv format to import it into excel.

Felix

[Dennis_Knutson]

And if you want to keep your LabVIEW table, just make it a control and write to it by using a local variable.

[andreas_p]

Thanks. Ill give it a try!