No License

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video

Highlights from
Spreadsheet

Join the 15-year community celebration.

Play games and win prizes!

» Learn more

4.2
4.2 | 5 ratings Rate this file 3 Downloads (last 30 days) File Size: 7.71 KB File ID: #6889 Version: 1.0
image thumbnail

Spreadsheet

by

 

09 Feb 2005 (Updated )

Demonstrates Microsoft Office Spreadsheet ActiveX Object.

| Watch this File

File Information
Description

SPREADSHEET is an example of how to use the Microsoft Office Spreadsheet Object.

This example, in response to the CSSM thread "ActiveX (Microsoft Office Spreadsheet)," demonstrates how to use the MS Office Spreadsheet object to display cell, character, logical and numeric matricies. It also demonstrates how to use an enumerated class workaround and how to
get the active cell, sheet, row and column from the spreadsheet. Various other methods and properties are explored and demonstrated. Much has been lifted from ML examples.

The Microsoft Office Spreadsheet object allows inputs and calcuations.

NOTE: TO SEE AN EXAMPLE OF HOW TO USE GRID OBJECTS WHICH HAVE SOME ADVANTAGES OVER THE MICROSOFT SPREADSHEET OBJECT,SEE MY EXAMPLE CALLED "GRAPH_AND_TABLE" WHICH IS AVAILABLE ON THE MATHWORKS FILE EXCHANGE:
          

http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=3477&objectType=file

NOTE: If you cannot instantiate the control, try changing 'OWC11.Spreadsheet.11' to 'OWC10.Spreadsheet.10' or even 'OWC9.Spreadsheet.9'

See Also: Grid_and_Table at the MATLAB File Exchange
          http://www.mathworks.com/matlabcentral/fileexchange

Keywords: grid spreadsheet ActiveX Active-X Active X GUI Table graph_and_table plot graph table grid object flexgrid msflexgrid ocx tabular

Thanks: TMW, Max Chtangeev, useActiveXControl, Brett Shoelson

IT'S NOT FANCY, BUT IT WORKS

MATLAB release MATLAB 7 (R14)
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (7)
16 Oct 2015 William Afonso

Hello world,

I tried to run the program shared above. However, at the following command "Spreadsheet1 = actxcontrol('OWC11.Spreadsheet.11',[0 0 psn(3:4)]);",
the following message displays:
"Error using feval
Input PROGID does not represent an Activex
control.
If this PROGID used to work before, please
check vendor's documentation for
equivalent activex control progid.

Error in actxcontrol/createControl (line
209)

Error in actxcontrol (line 180)

Error in Spreadsheet (line 107)
Spreadsheet1 =
actxcontrol('OWC11.Spreadsheet.11',[0 0
psn(3:4)]);"

I think the 'OWC11.Spreadsheet.11' activex control is not installed on my computer. Does anyone know how to solve this problem?

Thanks for your help

Comment only
27 Oct 2009 aa

aa (view profile)

Just great!

31 Jan 2008 BODET Vincent  
20 Sep 2007 Vladimir Chernatkin

How can I make another sheet tab active ('Sheet 2' instead of 'Sheet 1' for example)?

21 Aug 2007 parthiban p

extremely useful... keep posting stuffs like this so tht novice like me will find it really useful.

how to access the datas inputed by the user in the spread sheet in my mfile. is there direct methods to access by giving the corresponding cell name??

09 Nov 2005 Michael Robbins

Yes, use FastFillGrid to fill it without loops:

http://www.mathworks.com/matlabcentral/fileexchange/loadAuthor.do?objectId=828141&objectType=author

Comment only
20 Oct 2005 Rafe Austin

Good demonstration of properties. However, is there a way to fill the table without a nested loop? I.e. can I assign a Matlab vector to a column without looping through it?

Contact us