How to copy excel worksheet to activeX embedded Excel Spreadsheet

[thieny1]

Anyone know how to copy excel worksheet from a Excel file name to ActiveX embedded Excel Spreadsheet. Please see attached my

activeX sample embedded Excel spreadsheet.

Also, Is there a way to read/write to this ActiveX Embedded Excel Spreadsheet?

Anyhelp would be appreciated.

Thank you in advance.

[ebalci]

Hi,

I'm sure the NI sample project you started working with shows how to write on the embedded Excel sheet.

And Roberto has already suggested you to use the Excel ActiveX instruments (excel2000.fp or excelreport.fp) which will help you to read data from a file.

Even if there is not any other shorter way of doing it, you can read whatever data you need from an Excel file and write it inside the embedded Excel worksheet.

All you need is available in NI samples folder.

If you have another question, please make it clear. 

[thieny1]

Hi Eren,

Thank you for your info. When I run my excel200demo.prj (this is new project run with myexceldemo.uir) it return an error when I

try to write data to this excel spreadsheet.

              Error: Microsoft Excel Automation - Member not found

This project is a little bit different than Roberto has suggested, Please see attached project (myexceldemo.zip)

Also do you know is there a way to copy sheet1 from excel file "sample excel file.xls" (attached in the zip file) to the embedded excel

in the GUI myexceldemo.uir

Thanks

[Shako]

Has anyone found a solution Yet?