Sheetname
xlschart(titles,m,chartypechart_title,) xlschart(titles,m,chartype,chart_title,filename) xlschart(titles,m,chartype,chart_title,xtitle,ytitle) xlschart(titles,m,chartype,chart_title,filename,sheetname) xlschart(titles,m,chartype,chart_title,xtitle,ytitle,filename)...
Platforms: Matlab
License: Freeware | Size: 10 KB | Download (46): xlschart Download |
Write a matrix to active Excel-session. Input is filename, sheetname and range to write to in addition to the matrix that should be written to the Excel file.Some simple checks are implemented.Partly based on code from Matlab, sendt on mail from Antti LdoTAytynoja(Application Engineer in...
Platforms: Matlab
License: Freeware | Size: 10 KB | Download (48): Write to open and active Excel-file Download |
SYNTAX xlsprotect(file,'protect_file',pwd2open,pwd2modify,read_only_recommended,create_backup) xlsprotect(file,'unprotect_file',pwd2open) xlsprotect(file,'unprotect_file',pwd2open,pwd2modify) xlsprotect(file,'protect_sheet',sheetname,password)...
Platforms: Matlab
License: Freeware | Size: 10 KB | Download (43): xlsprotect Download |
This program reads a (text data file) consisting of headers, column titles and column data (see attached data.txt). Then it opens or creates existing excel file and saves data into specified sheetname.NOTE: The program will automatically identify the number of headerlines, columns and the column...
Platforms: Matlab
License: Freeware | Size: 10 KB | Download (44): dat2xls Download |
VARARGOUT = READFROMEXCEL(FILELOC,VARARGIN) Uses ActiveX commands to read range(s) from an existing Excel spreadsheet. FILELOC: Enter a string representing the (absolute or relative) location of an Excel file. (Extension may be omitted, and will be assumed to be .xls.) Examples: 'c:brettmy...
Platforms: Matlab
License: Freeware | Size: 10 KB | Download (45): readfromexcel Download |
Syntax: plotdata; plotdata(hPlotFig); plotdata(figureName,sheetName,xdata,ydata, xAxisName,yHeaders,...); [hDataFig, hSpreadsheet] = plotdata(...); PLOTDATA(hPlotFig) scans the supplied figure handle for any plot axes; for each plot axes found, a new spreadsheet is created with the plot data...
Platforms: Matlab
License: Freeware | Size: 40.96 KB | Download (46): PlotData - display plot raw-data in data-tables Download |
xlscell(xcell,value)xlscell(xcell,value,filename)xlscell(xcell,value,filename,sheetname) xcell: cell name (range) (ex. C3 or A2:F19)value: value(s) to assign to specified cell.filename: Name of excel file.sheetname: sheet name. Examples:filename = 'file.xls';value =...
Platforms: Matlab
License: Freeware | Size: 10 KB | Download (44): xlscell Download |
xlsgraph(xtitle,ytitle,chartype,chart_title,filename,sheetname) xlsgraph : creates an Excel graph by searching specified sheet for selected columns headers.xtitle: title(s) of column to be x-axis (picked from titles).ytitle: title(s) of column to be y-axis (picked from titles).chartype: integer...
Platforms: Matlab
License: Freeware | Size: 10 KB | Download (41): xlsgraph Download |