Unable to find spreadsheet otion in ActiveX Control

[NI SCADA]

I am using labview 8.6, In this i am unable to find Spreadsheet control in ActiveX Control......

So please tell me how i can resolve my this issue..

[GerdW]

Hi NI SCADA,

which ActiveX control? Which spreadsheet control? What are you talking about?

[parthabe]

---

NI SCADA wrote:

I am using labview 8.6, In this i am unable to find Spreadsheet control in ActiveX Control......

---

Do you mean you want an ActiveX Spreadsheet-like Table control to be picked up from somewhere in the pallette & being placed into an ActiceX container?

Be a bit more clear of what you want to do...

[JK1]

Are you trying to access excel using the activeX from LabVIEW?

[smercurio_fc]

The Microsoft Office Spreadsheet Control is part of the Office Web Components. It can get installed when you install Office. If you don't have Office, then you can download the Office Web Components from Microsoft.

Be aware that this is NOT an Excel workbook, or anything related to Excel. It's a completely different beast. There is no Excel ActiveX control that you can place on a front panel of anything, whether it's LabVIEW or any other language. 

[NI SCADA]

Dear Partha,

                   I want to display an excel spreadsheet using activeX container on front panel using labview 8.6.  If you see labview 8.5 there is a option in ActiveX container Spread Sheet 10 or 11. But in labview 8.6 there is a no such kind of option. I have office 2007 in my PC. My motive is to directly call an excel spreadsheet on front panel.

Thanks and Regards

Himanshu Goyal

[NI SCADA]

Dear Proven,

                   labVIEW 8.5 supports spreadsheet 10 or 11 in activeX Container.So i seek a similar approach for labVIEW 8.6

Himanshu Goyal

[JK1]

Hi,

i could find the spread sheet control in LV 8.6 also.

Post back for queries.

[LV_user1]

hi all....

i have doubt regarding same topic excel spreadsheet...

i can open the excel sheet using activex container but what i m getting is blank excel sheet.

even if my excel sheet contain matter after using "export" invoke node for activex container i m getting only blank excel sheet without any data....

why this is happening??

any help?

thanks..

[FraggerFox]

Place an automation refnum on front panel and give it microsoft excel 10.0>application class. place an invoke node and select range. give the range ref to a property node. Define the cell numbers and row/columns from where you need to read data. I tried this out on LV 8.6 and it worked