From Thursday, May 23rd (05:00 PM CDT) through Friday, April 24th (1:30 AM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Read openOffice calc through LabView

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
(5,100 Views)

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
(5,085 Views)

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
(5,067 Views)

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 LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 4 of 7
(5,065 Views)

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
(5,061 Views)
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
(5,059 Views)
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
(5,053 Views)