I would like to be able to open the Open Office spreadsheet SCALC using LabVIEW - is this possible?

[johnsold]

NeilJohn,

Do you want to open a spreadsheet created by OO Calc in LV and use the data in LV?  Or do you want LV to launch OO Calc and have Calc open a specified spreadsheet?

If the former, save the file as a CSV file from Calc and open it in LV using the Read from Spreadsheet File.vi with the appropriate delimiter.

If the latter, it will depend on your OS.  On my Mac I can use Apple Events to launch NeoOffice and open the .ods spreadsheet file.

Lynn 

[pallen]

Opening just the application is easy.  You could probably do this from a command line call if you know where the .exe for Scalc is on your computer.

But I'm guessing you probably want to do something a little more complex than that. 

Here are a couple of links that should point you in the right direction. 

http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/ProUNO/Bridge/Automation_Bridge

Open Office API

[NeilJohn]

Thank you for your replies.

What I would like to do is use SCALC to access certain cells on a certain sheet within an .xls file. I was wondering whether it was possible to use, for example, the open automation VI - if the active x control was available for SCALC - just as it is used for EXCEL in the   read_excel_values.llb    on the National Instrument Website. If it is possible some way - how can it be done? I am using a Desk Top PC with Windows XP.

[F._Schubert]

There is some work going on to make it possible over on LAVA

From there: 

The toolkit will be based on AODL, a .NET API for Open Document Format. It's still in beta (v1.3) and includes only Text Documents and Spreadsheets, but it's a complete interface. It's a complicated API, but after spendig a few days poking around it, it's a quite simple mechanics.

So far no code is available yet, but you could give the AODL a try on your own (and your own risk -> beta). 

Felix