From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.


Showing results for 
Search instead for 
Did you mean: 

excel template

> i need to make an excel sheet from a template excel file that cannot be edited..
but i can only be displayed..
> Is it possible to open the excel sheets n labview software itself..
i mean without the tool Icons for Save, print..etc..
i should be only the display sheet..

Tiju Thomas
0 Kudos
Message 1 of 6

You can play with Excel, if you have the Report Generation toolkit for MS Office.

You can call a Excel template using the Excel VIs & generate a report as per it.

- Partha ( CLD until Oct 2024 🙂 )
0 Kudos
Message 2 of 6
  Do u have any example Vi's regarding this..
i dont want to Edit the Excel datas..
it seems i dont have report generation toolkit for Ms Office..

Tiju Thomas
0 Kudos
Message 3 of 6
Without the RG toolkit, you cannot create reports from passing Excel templates.
Because those VIs come with it only.
- Partha ( CLD until Oct 2024 🙂 )
0 Kudos
Message 4 of 6


you can use the ActiveX functions.


0 Kudos
Message 5 of 6
Your simplest solution is to display the Excel template in an IE window on your panel.  Place the IE container and use the Open URL node to load the XLS file.  This will have the appearance of a worksheet without the drop-down menu or the toolbar. 

The contents of the sheet can be edited by the user, but if you use a key focus property node to change the focus to another object they will never be allowed to type into any cell.
Michael Munroe, CLD, CTD, MCP
Automate 1M+ VI Search, Sort and Edit operations with Property Inspector 5.0, now with a new Interactive Window Manager!
Now supports full project automation using one-click custom macros or CLI.
0 Kudos
Message 6 of 6