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
(3,050 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 2027 🙂 )
0 Kudos
Message 2 of 6
(3,048 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
(3,038 Views)
Without the RG toolkit, you cannot create reports from passing Excel templates.
Because those VIs come with it only.
- Partha ( CLD until Oct 2027 🙂 )
0 Kudos
Message 4 of 6
(3,030 Views)

Hi TIJU,

you can use the ActiveX functions.

Mike

0 Kudos
Message 5 of 6
(3,027 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,979 Views)