LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Read openOffice calc through LabView

Highlighted

I need to open a data sheet and cells of OpenOffice calc through LabView, but I don't know how to do it.

Does anybody know how to do it? Or anybody has an example?

 

Thanks!

 

 

0 Kudos
Message 1 of 7
(3,375 Views)
Highlighted

You should take a look here: http://forums.lavag.org/Reports-with-OpenOfficeorg-t3368.html.

 

OpenOffice has an ActiveX control so you may also be able to do it that way.

 

Another option is to save the data sheet as a text file and the use the Read From Spreadsheet File VI (File I/O palette).

0 Kudos
Message 2 of 7
(3,360 Views)
Highlighted

This idea is good, but I would want to select the cells that I would need to read. For example: A1 and after D5.

How do I would do this with text file?

0 Kudos
Message 3 of 7
(3,342 Views)
Highlighted

Hi aline,

 

the text file will have separators between the values. So you can easily change it to a 2d array. After this it's also easy to select row1-column1 (A1) or row4-column5 (D5) Smiley Wink

Best regards,
GerdW

using LV2011SP1 + LV2017 (+LV2019 sometimes) on Win10+cRIO
0 Kudos
Message 4 of 7
(3,340 Views)
Highlighted

I think very good, but I didnt find none example this. Anyone has?

 

Im studying the example "Read from Text File".

My LV is 7.1.

 

Tks!

 

 

 

0 Kudos
Message 5 of 7
(3,336 Views)
Highlighted
It will be easier if you use the Read From Spreadsheet File VI as I had mentioned, since that will return a 2D array for you directly.
0 Kudos
Message 6 of 7
(3,334 Views)
Highlighted
If you have other than numeric data, there are detailed instuctions on the block diagram of Read From Spreadsheet on how to convert it to read strings. Make sure to save it with a new name and to a new location.
0 Kudos
Message 7 of 7
(3,328 Views)