upload data into spreadsheet of an activex control

Discussion in 'MATLAB' started by Xiang Zhang, Mar 13, 2007.

  1. Xiang Zhang

    Xiang Zhang Guest

    Hello all,
    I am a new user of Matlab. I created an ActiveX Control in a MatLab
    figure by selecting 'Microsoft Office Spreadsheet 11.0'. How can I
    upload an excel file into this ActiveX control? After I upload the
    file, I want to edit the file and then save the edited spreadsheet.
    Can I do this?

    Thanks a lot for your help,
    Xiang
     
    Xiang Zhang, Mar 13, 2007
    #1
    1. Advertisements

  2. Don't know if this works with the spreadsheet control. Why don't you
    open an Excel-Server instead?

    Excel=actxserver('Excel.Application');
    Excel.Visible=1;
    Workbooks=Excel.Workbooks;
    Workbook=Workbooks.Open('Book1.xls');
    ....
    Workbook.Save
    Excel.Quit

    /Peter
     
    Peter Koetzing, May 16, 2007
    #2
    1. Advertisements

  3. Xiang Zhang

    Xiang Zhang Guest

    It works well.
    Thanks a lot,
    Xiang
     
    Xiang Zhang, May 16, 2007
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.