plotting a .xls spreadsheet

Convenience function for plotting spreadsheets specifying several variables and also conditions

335 Downloads

Updated Tue, 07 Feb 2012 08:59:07 +0000

View License

General-purpose script for plotting spreadsheets. You can plot multiple variables, select the plotting range and also the plotting conditions:

xlsplot( [xls file], [x variable], [y1 variable], [y2 variable], ....,
[condition 1], [condition 2], ..., options )
if the first ROW of the spreadsheet has a header line then variables are specified
by just partial unambiguous header titles, e.g. 'x column' or 'x col'
if the spreadsheet has no header titles, then use standard EXCEL headers,
such as 'A', 'B', ..., 'AA', 'AB', ...
to specify a variable in an expression use double quotes in the argument string,
i.e. '"x col"+"y col"' or 'hypot( "x col" + "y col" )'
to restrict the plotted dataset you can use logical commands, i.e.
'"x col">0'
you can also search for text strings within rows, i.e. 'good' or 'selec'
you can also specify which rows you want to plot using the syntax 'ROW
[r1, r2, r3...]'

to test this out, download the example XLS file called 'test.xls' and try
these commands

to turn off notifications about your plot, set options = 'QUIET'
to plot data where the x-values are sorted in ascending order, set options
= 'SORT'

[{plot handle}, {x variable}, {y1 variable}, {y2 variable}...] = xlsplot(...
returns the plot handle, and the data vectors used in the plot
*************************************************************
save this as spreadshet test.xls to run the following examples
a1 b c comment
1 1 1 good
3 9 9 bad
4 12.66666667 16 good
5 16.66666667 25 good
6 20.66666667 36 good
2 4 4 good

clf; xlsplot( 'test.xls', 'a1', '"b".^2', 'good' )
clf; xlsplot( 'test.xls', 'a1', '"b".^2', 'SORT' )
clf; xlsplot( 'test.xls', 'a1', '"b".^2', 'ROW [4:10]' )
clf; xlsplot( 'test.xls', 'a1', '"b".^2', '"a">3' )
clf; xlsplot( 'test.xls', 'a1', '"b".^2', '"a">3', 'QUIET' )
clf; set( xlsplot( 'test.xls', 'a1', '"b".^2', 'good' ), 'marker', 'o', 'color', 'r' )

Cite As

Stephan Koehler (2023). plotting a .xls spreadsheet (https://www.mathworks.com/matlabcentral/fileexchange/34942-plotting-a-xls-spreadsheet), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R13SP1
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
Version Published Release Notes
1.2.0.0

fixed minor bugs, and added SORT option

1.1.0.0

Fixed a bug relating to xlsread.

1.0.0.0