excel template

[TIJU]

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

[parthabe]

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.

[TIJU]

  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

[parthabe]

Without the RG toolkit, you cannot create reports from passing Excel templates.

Because those VIs come with it only.

[MikeS81]

Hi TIJU,

you can use the ActiveX functions.

Mike

[Michael_Munroe]

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.