How to open an excel template and display onto a table in Laview

[keng]

Hi all,
I would like to open an excel template file. Once called up, I would like to display it onto a table in Labview. From there, I would like to write data to the colums or rows in it. Can I do that? What do functions do I need. Please show some steps....
Many thanks.

[Zvezdana S.]

What you would like to do is very easily done with the Report Generation Toolkit for MS Office. It has slightly different VI that the NIReports llb, in the way that those VIs also support Word and Excel reports. If you don�t have this toolkit, you will need to use the activeX properties and methods to set this up.
If you would only like to open an Excel spreadsheet, you can use the File I/O VIs. To read an Excel tab deliminated file, use Read From Spreadsheet File.vi. One of its outputs is a 2D array that you feed into a LabVIEW table. Once you have the data in a LabVIEW table, you can just treat as a 2D array, and perform array functions on it to manipulate with the data
If you do have the toolkit, please look at the examples that ship with the toolkit.

Zve
zdana S.