Code covered by the BSD License  

Highlights from
getxls

4.75

4.8 | 4 ratings Rate this file 15 Downloads (last 30 days) File Size: 7.81 KB File ID: #27799
image thumbnail

getxls

by

 

30 May 2010 (Updated )

GETXLS is a GUI that allows you to easily transfer data from an Excel file into Matlab's workspace.

| Watch this File

File Information
Description

There are of course many ways to import data from an Excel file into Matlab. For instance, by clicking on an Excel file in the 'Current Folder' window within Matlab, one can select data and then push it into a variable in the base workspace. One can also use 'xlsread' to import data programmatically. Moreover, with the ExcelLink Toolbox, you can easily transfer data between Excel and Matlab in both direction, if you have this toolbox (which I don't). 'getxls' is just another possibility which, personally, I find often easier for quickly getting the data into Matlab. The GUI allows you to import eiher the raw data, just the numeric cells, only the dates cells, or only string cells. If you choose to import only date cells, then the GUI transforms the Excel date code to the corresponding Matlab date code.

The program can be instructive for other software developers as it has a few possibly unusual features. First of all, this GUI was created programmatically, without the help of GUIDE. This makes it, I think, somewhat more transparent. Secondly, and contrary to the code generated with GUIDE, it uses nested functions, which has the advantage that all variables that are defined in the main function are also in the scope of the nested functions. Thirdly, the program demonstrates how to use the Excel COM server. And finally, it demonstrates how to access Matlab's editor and create a new Matlab skript programmatically.

Acknowledgement: A small part of the program is heavily inspired by XLSREAD.

Please comment if you like it or if you find it useful.

MATLAB release MATLAB 7.10 (R2010a)
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (8)
18 Aug 2013 Yvan Lengwiler

Hwang, thank you for the four stars you gave to my software. I am glad you like the program. It would be helpful for me if you could tell me what prevented you from giving it five stars. Do you have any suggestions for improvements?

17 Aug 2013 Hwang  
30 Jul 2013 Yvan Lengwiler

Dear Joseph. I'm sorry for your troubles. Also, I was traveling and could not answer earlier. I've checked the problem now. It is most likely due to a ~code, which is used in more recent versions of Matlab to indicate an output variable that is not used. Earlier versions do not understand this. I suggest that you make a global 'search and replace' in the code swapping '~' for 'temp'. I might do this in the next revision of the program to make it more friendly to older versions of Matlab. Hope this helps --- if not, let me know.

12 Jul 2013 JOSEPH

I downloaded this file on my laptop and when I run it matlab gives an error message says unexpected matlab operator in line 309 column 37. Not really good at matlab, please help

04 Feb 2013 Shahab

useful

14 Nov 2012 Graeme Cumming

As a Mac user, some pre-download warning that this seems to be written for Windows would have been handy! But some of the other details are neat -- thanks :)

20 Jan 2011 Moeti Ncube

Dude, u are the man!

06 Jul 2010 Yuan  
Updates
01 Jun 2010

Some improvements:
(1) callback to edVariable,
(2) toggle row/col headings and buttons for font size,
(3) use of 'genvarname' in case the user selects an invalid variable name,
(4) 'style' argument,
(5) tooltip texts to all objects in the GUI.

07 Jun 2010

Added 'Dates' filter to extract only cells that have some date format.

23 Jun 2010

these updates:
 - added 'generate m-file' functionality
 - fixed bug when resizing window too small
 - fixed bug that manifested on empty worksheets

03 Jul 2010

Fixed a minor bug that caused the variable to be pushed to the base workspace twice sometimes.

13 May 2011

- If no range is selected, the whole worksheet is imported.
- 'Generate M-File' now reads the variablename and uses it for the generated script.

17 Sep 2011

Fixed bug that happened when only a single cell is selected. Moreover, showing Row/Col headings is now the default.

25 Oct 2012

'editorservices' is no longer supported by the latest version of ML. The new version of GETXLS adapts to this change.

Contact us