Java-based data table by Yair Altman

Spreadsheet display/editing/sorting of data with multiple features (example, uitable, java)

createTable.m

Excel Write Format by Tom

Write data to Excel through MATLAB and format the spreadsheet. (excel, spreadsheet, office)

Display_Excel_Format_Options(varargin)

Excel_2_Numeric(ExcelString)

Excel_Ref_Check(refStr)

Converting Dataset Simulation results to Excel Spreadsheet by Roni Peer

Two simple functions that convert a Dataset parameter, containing Simulink Simulation data, to excel (excel, dataset, simulink)

Dataset2XLS(DATA, filename)

XLS2Dataset(filename)

example_ReadDS

Protect or unprotect worksheets in Excel file by Guilherme Coco Beltramini

Protect or unprotect selected worksheets in Excel file, with or without password (excel, protect worksheets)

xls_check_if_open(xlsfile,action)

xls_protect_sheets(xlsfile,sheets,action,password)

Delete worksheets in Excel file by Guilherme Coco Beltramini

Delete selected worksheets or all empty worksheets in Excel file (excel, delete worksheets)

xls_check_if_open(xlsfile,action)

xls_delete_sheets(xlsfile,sheets)

Run MS Excel macro by Guilherme Coco Beltramini

Run MS Excel macro with or without parameters (excel, macro)

xls_check_if_open(xlsfile,action)

xls_run_macro(xlsfile,macro,params)

Check if XLS file is open and close it by Guilherme Coco Beltramini

Determine if Excel file is open. If it is open in MS Excel, it can be closed. (xls file, excel)

xls_check_if_open(xlsfile,action)

MKXLSFUNC: Easily integrate legacy spreadsheet tools into MATLAB by Sky Sartorius

Creates an m-file function that does analysis within your specified Excel-based analysis tool. (xls, xlsread, xlswrite)

MKXLSFUNC Example:

xlsrange by Richard Crozier

Generates an excel range from row and column number (xls, excel)

xlsrange(row1, col1, row2, col2)

Inverse of Normal Cumulative Distribution by Nassim Khaled

This is a simple example for finding the inverse normal cumulative distribution using Matlab & Excel (normal distribution, inverse normal distri..., norminv)

script.m

xlwrite: Generate XLS(X) files without Excel on Mac/Linux/Win by Alec de Zegher

Generates ‘.xls’ & '.xlsx' files on Mac/Linux/Win without Excel, using same syntax as xlswrite. (apache poi, excel, jexcelapi)

[status, message]=xlwrite(filename,A,sheet, range)

Test_xlWrite.m

StatisticsPlus Excel AddIn by Laszlo Balkay

This Excel AddIn contains some Matlab functions from the Statistical Toolbox. (statistics, excel, excel addin)

Grafica datos de excel by maynor

grafica datos desde cualquier hoja de excel (excel, mathematics)

graficadatosexcel(varargin)

Save plots from Matlab into an Excel file by Amit Doshi

This utility allows users to save their plot(one at a time)in an Excel file at a single click. (plots, excel, actxserver)

PlotInExcel(DataX,DataY)

Excel auto alphabet cell range by Fuad Numan

This code generates the alphabetical index of any cell in excel doc., (excel, auto, cell range)

[indx]=letter_excel(N)

getxls by Yvan Lengwiler

GETXLS is a GUI that allows you to easily transfer data from an Excel file into Matlab's workspace. (excel, spreadsheet, com server)

getxls(style)

Write data to Excel by Gunnar Aronsen

Write matrix to Excel-file, and leave the files open. File written to is not saved. (dataexport, openfile, xlswrite)

w2excel.m

xlwrite : Export Data to Excel from Matlab on Mac/Win by Marin Deresco

xlwrite allows you to export data (2d/3d arrays of double/cell) to Excel from Matlab (Mac/Win) (xlswrite, excel, mac)

Cell2JavaString.m

[Result]=xlwrite(file,data,sheet)

cell2char(C)

Excel Column Conversion by Ragaar Ashnod

Converts a numeric input to a column name, for Excel representation. (data export, data import, excel)

output=ExcelCol(x)

Excel Column Conversion by Mike Sheppard

Converts between column name and number for Excel representation (data import, data export, excel)

Out=ExcelCol(In)

Function for faster data transfer Matlab <--> Excel by Antonio

This modified version makes the original xlsread.m faster and also allows add-ins to be loaded. (data export, data import, active x)

[data, text, rawData, customOutput]=xlsread1(file,sheet,ran...

Convert an A1-style spreadsheet column label to a number. by DS

ABC2NUM translates an A1-style (absolute) column label reference to a number; NUM2ABC does inverse. (excel, spreadsheet, string conversion)

abc2num(S)

num2abc(D)

Example for creating Multiple Entities for SimEvents - from excel by Roni Peer

An Excel file contains information about time and number of units to dispatch - use in SimEvents. (simevents, excel, import)

MultipleEntities_Excel

Convert row & column number into xlswrite compatible format by Sebastian W

Converts the row & column number to work with xlswrite range input argument. (xlswrite, range, excel)

conv2xlscell(row, cln)

Excel column header by Gunnar Aronsen

Take column number as input argument, and return Excel columheaders as letters. (columnheaders, excel)

ExcelColHeader(input)

Excel column number by Gunnar Aronsen

Convert Excel column header to colum number. (excel, column number)

ExcelColNo(input)

Probability Distribution Plotter by Andrew O'Connor

Plots pdf, cdf & hazard rate of probability distributions and exports as Excel Chart, pdf, jpg (cdf, reliability, probability)

PDFBeta(varargin)

ProbDistPlot(varargin)

betahaz(t,A,B)

csv2cell by David Groppe

Simple function that imports a 2D text file spreadsheet into a 2D cell array. (spreadsheet, comma delimited, tab delimited)

csv_matrix=csv2cell(csv_fname,delimiter)

XLS Import tool by Findlay Yeates

XLS importing tool for variable datasets (excel, convert, xls)

DBDump(DatabaseFileXls)

Demo files for "MATLAB for Excel Users" webinar by Jiro Doke

This is the demo used in March 22, 2011 webinar "MATLAB for Excel Users". (excel, curve fitting, webinar)

Energy Forecast Demo

ForecastGUI(varargin)

createSurfaceFit(thisHour, thisTemp, thisPower)

pivottable by Zhiqiang Zhang

PIVOTTABLE Groups a matrix into a pivot table, is flexible as in Excel (data exploration, pivottable, excel)

pivottable(inMatrix, pivotRow, varargin)

Calculate Excel Range by Richard de Garis

Calculates full target range in Excel A1 notation. (excel, range)

xlcalcrange(refCell,r,c,m,n)

Excel File Reader by michael arant

Rather simple tool to read all data from all sheets in an excel file. (excel)

read_xls_file(fne,dre)

Convert index to Excel A1 notation by Matt Brunner

Convert index to Excel A1 notation used in xlswrite (xlswrite, excel, a1 notation)

idx2A1(idx)

Column Converter for Excel by Kevin Crosby

Convert Excel column letters to numbers or vice versa, for processing data to/from XLSREAD/XLSWRITE. (data export, data import, excel)

xlscol(a)

ExcelWrapper by Fayssal El Moufatich

Wraps common operations on an Excel Workbook into a MATLAB class (excel, dataset, wrapper)

ExcelWrapper

MAT2XLS v2.0 by Elmar Tarajan

Stores and customizes numeric array or cell array in Excel workbook using ActiveX interface. (xslx, automation, xlswrite)

mat2xls

XLSrange by Yvan Lengwiler

The function returns the range address as used by Excel. It is useful in connection with XLSWRITE. (excel, data export)

XLSrange(sizeofarray, topleft)

xls2struct by Ashish Uthama

Load Excel file contents as a structure (data export, xls, xls excel read variab...)

xlsStruct=xls2struct(file,flag)

Generate vertices, faces and color for u3d format by Sven Koerner

Generate vertices, faces and color for u3d format and display it in pdf or doc, xls and ppt (3d, u3d, excel)

u3d_pre

improved xlswrite.m by Barry Dillon

Makes xlswrite use 'persistent' actxserver and hence much faster (xlswrite, excel, utility)

[success,message]=xlswrite(file,data,sheet,range)

Files used in "Matlab For Excel Users" (Japanese version) / 「ExcelユーザのためのMATLAB」Webセミナーのファイル by Teja Muppirala

Webinar files: "MATLAB for Excel Users" (Japanese) Webセミナー「ExcelユーザのためのMATLAB」で使われたファイルです (excel, builder ex)

createSurfaceFit(thisHour, thisTemp, thisPower)

energyModel(thisHour, thisTemp, thisPower, H, T)

MainAnalysis.m

M-Lint report in Microsoft Excel by Scott Hirsch

Generate a Microsoft Excel spreadsheet with contents of an m-lint code analysis report. (development environme..., mlint, excel)

mlintexcel(fn,excelfn)

xlswrite by Scott Hirsch

Easily create a Microsoft Excel format spreadsheet from MATLAB®. (excel, activex, data import)

xlswrite(m,header,colnames,filename,sheetname)

MAT2CLIP by Jiro Doke

Copies the contents of a matrix to the CLIPBOARD. (data import, data export, copy)

mat2clip(a, delim)

Simple Excel sheet editing program by Peter Lindberg

Simple Excel sheet editing program (fontsize, format, activex)

xlcontrol(range,params,file,sheet)

Updating MATLAB(R) figure inserted on a Excel(R) Sheet by Martti

How to insert an automatically updating MATLAB(R) figure to an Excel(R) sheet. (excel, visualization, builder)

...

MATLAB(R) for Excel Users by Dan Doherty

Demo files from MATLAB for Excel Users webinar (excel, statistics, link)

checkmotor(rpm, motordata)

createfigure(x1, y1, y2)

dockfigures.m

msopen by Fahad Al Mahmood

Opens Microsoft Office files (Word, Excel, Power Point, Project, & Access). (access, word, files)

msopen(varargin)

xlswritefig by Scott Hirsch

Write a MATLAB figure to a Microsoft Excel spreadsheet. (excel, data export)

xlswritefig(hFig,filename,sheetname,xlcell)