01-11-2016 11:33 PM
hi,
How can i add header programatically to excel file. I am using activex component in labview8.2.and i don't have report generation toolkit.
Solved! Go to Solution.
01-12-2016 01:01 PM
What's not working? I ran the VI and it worked for me, the table was added at the row specified.
Unofficial Forum Rules and Guidelines
Get going with G! - LabVIEW Wiki.
16 Part Blog on Automotive CAN bus. - Hooovahh - LabVIEW Overlord
01-12-2016 01:12 PM
You should stick to your original post. This will avoid duplication of effort.
01-12-2016 01:20 PM
@GokulGKM wrote:
hi,
How can i add header programatically to excel file. I am using activex component in labview8.2.and i don't have report generation toolkit.
It also works fine with me. You will not see the page header in normal display mode, switch to page layout view mode.
Ben64
01-12-2016 03:54 PM
I mentioned in your other post that your code did add the Header, but you only see it in the printed version, as the Header is part of printing. Did you not read this? Did you not understand what I wrote?
Bob Schor
01-12-2016 10:59 PM
ha i know it will show page layout .how can i view page layout mode programatically.and one more thing all even row color change how.
01-13-2016 08:40 AM
@GokulGKM wrote:
ha i know it will show page layout .how can i view page layout mode programatically.
So why didn't you say so at first?
You need to set the View property of the active window (returned by the Item method) of the Windows collection of the Workbook object. Set it to xlPageLayoutView.
Benoit
01-14-2016 03:05 AM
s thanks i got page layout..now i am trying the following think.
1).How to add header picture and resize header margin and header color chage
2).how to left corner align the center header text
3).How to marge cell.
here i attached XL sheet manually created what i am trying.through labview
and i find header picture propery but this read only not able to write.
01-14-2016 07:15 AM
y i am again ask mean there is no help window and no example for ActiveX excel propery..if any activeX Excel property pdf manual..
01-14-2016 07:32 AM
@GokulGKM wrote:
there is no help window and no example for ActiveX excel propery..if any activeX Excel property pdf manual..
There are plenty of examples of using ActiveX in LabVIEW to control Excel, some of them can be seen in this very thread. Others can be found in the example finder. There's also this old toolkit that was made for LabVIEW 6.x which uses lots of ActiveX.
http://forums.ni.com/t5/LabVIEW/how-to-save-data-into-an-excel-file/m-p/108091#M65482
Beyond that there is no PDF manual of all the functions built into excel, but there are tons of dedicated forums on how to control Excel using VBA which essentially is what ActiveX is calling.
Another fun trick is I will use the Macro feature in Excel. Just have it record, then you perform the actions you want, then stop. Now look at the macro it made and the source is the VBA that you can then translate into LabVIEW using ActiveX.
Unofficial Forum Rules and Guidelines
Get going with G! - LabVIEW Wiki.
16 Part Blog on Automotive CAN bus. - Hooovahh - LabVIEW Overlord