Freeze Excel rows

[Nagaraju]

Dear sir,

 

I want to freeze first three rows of the excel sheet.

 

I tried this link http://forums.ni.com/t5/LabVIEW/excel-freeze-panes/td-p/379677, but some SubVIs are missed.

 

Please let me know about the implementation.

 

 

Thanks & Regards,

S Nagaraju

[hooovahh]

I think this might be the missing VI, it is in VI.lib and just converts row and column values into strings that the ActiveX function uses to form a cell like A1

 

<LabVIEW Install Director>\vi.lib\addons\_office\_exclsub.llb\Row Col To Range.vi

 

The other missing VIs just relate to the ActiveX reference, which you can get using the Excel Get ActiveX Reference in the report generation palette.