From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, 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: 

excel template

Hello..
 
> 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
Regards

Tiju Thomas
0 Kudos
Message 1 of 6
(2,736 Views)

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
(2,734 Views)
  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
 
Regards

Tiju Thomas
0 Kudos
Message 3 of 6
(2,724 Views)
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
(2,716 Views)

Hi TIJU,

you can use the ActiveX functions.

Mike

0 Kudos
Message 5 of 6
(2,713 Views)
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
(2,665 Views)