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)

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:

GetGoogleSpreadsheet by Daniel

Download a google spreadsheet as csv and import into a Matlab cell array. (google, spreadsheet, import)

GetGoogleSpreadsheet(DOCID)

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)

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)

tsvread: importing tab-separated data by Stephan Koehler

Similar to csvread, but has a lot more user-friendly options and can deal with non-numeric data. (csvread, spreadsheet, tsvread)

tsvread( varargin )

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)

Struct array conversion by Ged Ridgway

Convert in either direction between struct-array and structure of arrays (struct, database, spreadsheet)

Examples of processing basic database from an xls spreadshe...

struct2struct(old)

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)

Image2spreadsheet by Joao Silveira

Collects coordinates from several pictures in a spreadsheet (gui tools, example, image)

image2spreadsheet(varargin)

javaTable by Matt Dunham

Simple function to display cell array data in a nice looking Java JTable (java, jtable, table)

javaTable(data,columnNames,tableName)

Excel2Matlab by Stephen Lienhard

Spreadsheet to pass data between Excel and MATLAB (spreadsheet, excellink, excel)

pic2xls by Fahad Al Mahmood

This function inserts a picture into an Excel file (insert, xls, excel)

pic2xls(pic,file,sheet,param)

FastFillGrid by Michael Robbins

Populates a grid, i.e. Microsoft Spreadsheet Object, with a cell array. (gui tools, example, grid)

FastFillGrid(Spreadsheet1,M,DoPaste,DoWaitbar,MinR,MinC,Max...

GetActCell(Spreadsheet1,ActSheet,r,c)

PutCellValue(ActCell,M,AsStr)

Spreadsheet2Structure by Michael Robbins

Reads in a spreadsheet and converts it into a structure whos field names are taken from the column h (path, directories, files)

Spreadsheet2structure(TXT,ULHeaderValue)

WideOKDlgWithListBox by Michael Robbins

produces a simple OK dialog to be used to display long help messages but may really be used for many (gui tools, example, questdlgwithgrid)

WideOKDlgWithListBox(varargin)

Text File IO for Non-uniform Data by John McArthur

Takes a non-uniform text file and imports it similar to Excel import function. (data import, data export, excel)

DataInput.m

FillGrid by Michael Robbins

Populates a grid, i.e. Microsoft Spreadsheet Object, with a cell array. (gui tools, example, grid)

FillGrid(Spreadsheet1,M,DoPaste,DoWaitbar,MinR,MinC,MaxR,Ma...

PutCellValue(ActCell,M,AsStr)

nn2an(r,c)

Spreadsheet by Michael Robbins

Demonstrates Microsoft Office Spreadsheet ActiveX Object. (activex, example, grid)

Spreadsheet1=Spreadsheet

QUESTDLGWITHGRID by Michael Robbins

questdlg, with the useful addition of a grid object to display the data. (gui tools, example, quesdlg)

QuestDlgWithGrid(varargin)

OKDLGWITHLISTBOX by Michael Robbins

Produces a simple OK dialog to be used to display long messages. (gui tools, example, help)

OKDlgWithListBox(varargin)

AUTOHELP by Michael Robbins

Generates a helpfile automatically. (gui tools, example, help)

AutoHelp(handles)

dat2xls by Fahad Al Mahmood

Copying (ASCII) data file (including headers & column names) to XLS. (data import, data export, excel)

dat2xls(varargin)

xlsheets by Fahad Al Mahmood

Creating sheets and naming them in Excel. (data import, data export, excel)

xlsheets(sheetnames,varargin)

xlcolumn by Fahad Al Mahmood

Converts Excel column name to column number and vise versa. (data import, data export, excel)

xlcolumn(column)

xlsgraph by Fahad Al Mahmood

Creates graphs from existing Excel sheet containing column data. (excel, spreadsheet, data import)

xlsgraph(xtitle,ytitle,chartype,chart_title,varargin)

xlsfont, xlsalign, xlsborder, xlswordart, xlscomment by Fahad Al Mahmood

5 functions to modify Microsoft Excel cell format & adds comments and WordArt (excel, border, font)

xlsalign(filename,sheetname,varargin)

xlsborder(filename,sheetname,varargin)

xlscomment(filename,sheetname,cell,comment,visible)

xlscell by Fahad Al Mahmood

Assigns a value or Excel formula to a specified cell in excel sheet. (data import, data export, excel)

xlscell(xcell,value,varargin)

xlschart by Fahad Al Mahmood

Writes column headers and a matrix to excel and graphs all columns or two specified columns. (graph, spreadsheet, excel)

xlschart(titles,m,chartype,chart_title,varargin)

XLSWriteMex by Gordon Ray

MATLAB MEX function to create an Excel spreadsheet. (data import, data export, write)