image thumbnail

updated 4 months ago

xlswrite by Michelle Hirsch

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

image thumbnail

updated 1 year ago

Java-based data table by Yair Altman

Spreadsheet display/editing/sorting of data with multiple features (gui tools, example, table)

createTable.m

image thumbnail

updated 1 year ago

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)

image thumbnail

updated 1 year ago

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:

image thumbnail

updated almost 2 years ago

GetGoogleSpreadsheet by Daniel

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

GetGoogleSpreadsheet(DOCID)

image thumbnail

updated almost 2 years ago

getxls by Yvan Lengwiler

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

getxls(style)

image thumbnail

updated 2 years ago

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)

image thumbnail

updated 3 years ago

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 )

image thumbnail

updated 3 years ago

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)

image thumbnail

updated 3 years ago

Matlab to Google Spreadsheets by Claudiu Giurumescu

Matlab functions to send data to Google Spreadsheets. (data export, data import, spreadsheet)

[aTokenDocs,aTokenSpreadsheet]=connectNAuthorize(userName)

[cellValue,cellFormula]=getWorksheetCell(spreadSheetKey,w...

changeWorksheetNameAndSize(spreadsheetKey,worksheetKey,ro...

image thumbnail

updated 4 years ago

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 spreads...

struct2struct(old)

image thumbnail

updated almost 5 years ago

MAT2CLIP by Jiro Doke

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

mat2clip(a, delim)

image thumbnail

updated 6 years ago

Image2spreadsheet by Joao Silveira

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

image2spreadsheet(varargin)

image thumbnail

updated 6 years ago

javaTable by Matt Dunham

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

javaTable(data,columnNames,tableName)

image thumbnail

updated 7 years ago

Excel2Matlab by Stephen Lienhard

Spreadsheet to pass data between Excel and MATLAB (data import, data export, excel)

image thumbnail

updated almost 9 years ago

pic2xls by Fahad Al Mahmood

This function inserts a picture into an Excel file (data import, data export, excel)

pic2xls(pic,file,sheet,param)

image thumbnail

updated 9 years ago

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,M...

GetActCell(Spreadsheet1,ActSheet,r,c)

PutCellValue(ActCell,M,AsStr)

image thumbnail

updated 9 years ago

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)

image thumbnail

updated 9 years ago

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)

image thumbnail

updated 9 years ago

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)

image thumbnail

updated 9 years ago

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,...

PutCellValue(ActCell,M,AsStr)

nn2an(r,c)

image thumbnail

updated 9 years ago

Spreadsheet by Michael Robbins

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

image thumbnail

updated 9 years ago

QUESTDLGWITHGRID by Michael Robbins

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

QuestDlgWithGrid(varargin)

image thumbnail

updated 9 years ago

OKDLGWITHLISTBOX by Michael Robbins

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

OKDlgWithListBox(varargin)

image thumbnail

updated 9 years ago

AUTOHELP by Michael Robbins

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

image thumbnail

updated 10 years ago

dat2xls by Fahad Al Mahmood

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

dat2xls(varargin)

image thumbnail

updated 10 years ago

xlsheets by Fahad Al Mahmood

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

xlsheets(sheetnames,varargin)

image thumbnail

updated 10 years ago

xlcolumn by Fahad Al Mahmood

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

xlcolumn(column)

image thumbnail

updated 10 years ago

xlsgraph by Fahad Al Mahmood

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

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

image thumbnail

updated 10 years ago

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

5 functions to modify Microsoft Excel cell format & adds comments and WordArt (data import, data export, excel)

xlsalign(filename,sheetname,varargin)

xlsborder(filename,sheetname,varargin)

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

image thumbnail

updated 10 years ago

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)

image thumbnail

updated 10 years ago

xlschart by Fahad Al Mahmood

Writes column headers and a matrix to excel and graphs all columns or two specified columns. (data import, data export, excel)

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

image thumbnail

updated 10 years ago

XLSWriteMex by Gordon Ray

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

Contact us