image thumbnail

updated 5 days ago

Excel plot generator by michael arant

Generate plots in Excel directly from MATLAB (excel, plot, data export)

ep(data,col,tle,xlbl,ylbl,fn,dr,lne,rng,opn,opt,leg,sheet...

image thumbnail

updated 5 days ago

Number to Letter by michael arant

Simple program to convert base 10 numbers to base 26 (i.e. from 1, 2, 3, 26 to a, b, c, z) (xlswrite, excel)

num2let(num)

image thumbnail

updated 17 days ago

xlswritefig by Michelle Hirsch

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

image thumbnail

updated 17 days ago

xlswrite by Michelle Hirsch

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

image thumbnail

updated 17 days ago

Code Analyzer report in Microsoft Excel by Michelle Hirsch

Generate a Microsoft Excel spreadsheet with contents of a code analyzer report. (development environme..., mlint, excel)

image thumbnail

updated 24 days ago

delimread by Kirby Fears

Easily read text and numerical data from any delimited text file (such as CSV). (csv, data import, excel)

convertxlrange(rangestr)

delimread(fpath,delim,outstyle,varargin)

image thumbnail

updated 25 days ago

convertxlrange by Kirby Fears

Converts Excel ranges to row and column boundary values (utilities, excel, conversion)

convertxlrange(rangestr)

image thumbnail

updated 1 month ago

csv2Cell(csv_fname,delimiter,header_lines) by David Groppe

David Groppe (view profile)

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

csv2Cell(csv_fname,delimiter,header_lines)

image thumbnail

updated 2 months ago

Wind Rose by Daniel Pereira

Daniel Pereira (view profile)

Graph and table for Direction-Intensity data (excel, export)

WindRose.m

ExcelImportExport.m

WindRose_Doc.m

image thumbnail

updated 3 months ago

img2xlsx by H K.Berg

H K.Berg (view profile)

img2xlsx is a function which transfers one or multiple image(s) to a new or existing xlsx-file. (excel, xlsx, activex)

img2xlsx.m

image thumbnail

updated 3 months ago

adj2gephilab by Fabio Vanni

it writes two csv spreadsheet files for Gephi Data Laboratory (gephi, graph, network)

adj2gephilab(filename,ADJ,parameters)

image thumbnail

updated 4 months ago

wr_colwithheader by Jose Caballero

Simple file to output structure fields to an .xls, including field names as headers. (data export, excel)

wr_colwithheader(filename,struct_in, col_ofs,row_ofs, sheet)

image thumbnail

updated 5 months ago

xlRange, number2letter by Scott Williams

xlRange supports xlwrite downloadable user defined function. Column # used for range export/import (xlwrite, xlsread, xlrange)

number2letter( integer_)

xlRange( columnNum,rowNum )

image thumbnail

updated 5 months ago

Average over repetitions in Excel table by Weirong Chen

Read Excel table and average the data over unnecessary factors (repetitions) (excel)

ReadXlsAverageAcrossRep(XlsFName, IndepVariables, NewXlsF...

image thumbnail

updated 5 months ago

Write structure array into Excel sheet by Weirong Chen

Write a structure array into Excel sheet (excel)

WriteXlsFromStruct(DataStruct, outXlsName, sheet, ifOvewr...

image thumbnail

updated 5 months ago

Read Excel sheet into a structure array by Weirong Chen

Read Excel sheet into a structure array (excel)

xls2struct(xlsFName,sheetnum)

demo_xls2struct.m

image thumbnail

updated 5 months ago

RemoveSheet123 - remove default Excel sheets by Noam Greenboim

Remove default sheets ("sheet1" ,"sheet2", "sheet3") from an Excel file (xlswrite, excel, xlsread)

RemoveSheet123.m

image thumbnail

updated 6 months ago

Search( filetype,folderpath) by anthony bobbie

Recursively searh folder path (utility, development environme..., excel)

Search( filetype,folderpath)

image thumbnail

updated 8 months ago

The X Collection by Yvan Lengwiler

Yvan Lengwiler (view profile)

Collection of programs that ease interaction with Excel files. (excel, activex, data import)

XAddSheet(hBook,strName,hAfterSheet)

XCloseAllBooks(hExcel)

XCloseBook(hBook)

image thumbnail

updated 8 months ago

Number of columns to alphabet representation for Excel by Scott

Scott (view profile)

Converting number of columns to an alphabet representation (excel, column, coverter)

num2alp(numcol)

image thumbnail

updated 8 months ago

Java-based data table by Yair Altman

Yair Altman (view profile)

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

createTable.m

image thumbnail

updated 9 months ago

csvimport(filename) by Pratik Chhatbar

For mac lovers who cannot get xlsread or csvread to ever work (excel, mac, xlsread)

csvimport(filename)

image thumbnail

updated 9 months ago

csvexport(filename,cellVals) by Pratik Chhatbar

For those mac lovers who never got xlswrite or csvwrite to work (excel, mac, xlswrite)

csvexport(filename,cellVals)

image thumbnail

updated 12 months ago

xlscolor.m by meysam

meysam (view profile)

paint the cell of excel via matlab (paint, color, excel)

xlscolor(filename,CellIndex,RGB)

image thumbnail

updated 1 year ago

ReadMultipleSheetsInExcel.m by Thomas Hansen

Read multiple sheets in Microsoft Excel spreadsheet file (excel, xlsread, multiple sheets)

ReadMultipleSheetsInExcel(FILENAME,flag)

image thumbnail

updated 1 year ago

ERCOT Price Processing Toolbox by Mahdi Kefayati

ERCOT Price Processing Toolbox (price, ercot, excel)

XLS2TAB(workbookFile)

prcAsPriceData(dataPath)

prcDamPriceData(dataPath)

image thumbnail

updated 1 year ago

num2clip board with column names by Roberto

Easy function to copy a numeric array to the clipboard, allowing to write costum column names. (clipboard, excel, numeric)

num2clip(dat,varargin)

image thumbnail

updated 1 year ago

toTable: Simple Manual Matlab to Excel or Word Function by Kirk

Kirk (view profile)

Take data from Matlab to an Excel Spreadsheet or a Word Table. (excel, convert, matlab)

toTable(Input,varargin)

image thumbnail

updated almost 2 years ago

Dependency Analyzer by Alexander Mering

Starting from a given directory, the dependencies of all files are analyzed and visualized as a map. (dependency, files, call)

Build_Dependency_Map(root_dir, varargin)

Retrieve_Directory_Structure(root_dir, file_types, exclus...

Write_Dependency_Report(directory_structure, file_list, u...

image thumbnail

updated almost 2 years ago

Calculate Excel Range by Richard de Garis

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

base27dec(s)

dec2base27(d)

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

image thumbnail

updated 2 years ago

Excel Write Format by Tom

Tom (view profile)

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 2 years ago

Converting Dataset Simulation results to Excel Spreadsheet by Roni Peer

Roni Peer (view profile)

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

Dataset2XLS(DATA, filename)

XLS2Dataset(filename)

example_ReadDS.slx

image thumbnail

updated 2 years ago

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)

image thumbnail

updated 2 years ago

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)

image thumbnail

updated 2 years ago

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)

image thumbnail

updated 2 years ago

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)

image thumbnail

updated 2 years ago

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

Sky Sartorius (view profile)

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

MKXLSFUNC Example:

image thumbnail

updated 2 years ago

xlsrange by Richard Crozier

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

xlsrange(row1, col1, row2, col2)

image thumbnail

updated 2 years ago

Inverse of Normal Cumulative Distribution by Nassim Khaled

Nassim Khaled (view profile)

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

script.m

image thumbnail

updated 2 years ago

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

Alec de Zegher (view profile)

  • 1 file
  • 167 downloads
  • 4.83784

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

xlwrite(filename,A,sheet, range)

Test_xlWrite.m

image thumbnail

updated 2 years ago

StatisticsPlus Excel AddIn by Laszlo Balkay

Laszlo Balkay (view profile)

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

image thumbnail

updated 2 years ago

Grafica datos de excel by maynor

maynor (view profile)

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

graficadatosexcel(varargin)

image thumbnail

updated almost 3 years ago

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)

image thumbnail

updated almost 3 years ago

Excel auto alphabet cell range by Fuad Numan

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

letter_excel(N)

image thumbnail

updated almost 3 years ago

getxls by Yvan Lengwiler

Yvan Lengwiler (view profile)

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 almost 3 years ago

Write data to Excel by Gunnar Aronsen

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

w2excel.m

image thumbnail

updated 3 years ago

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) (java, xlswrite, mac)

Cell2JavaString.m

cell2char(C)

xlwrite(file,data,sheet)

image thumbnail

updated 3 years ago

Excel Column Conversion by Ragaar Ashnod

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

ExcelCol(x)

image thumbnail

updated 3 years ago

Excel Column Conversion by Mike Sheppard

Mike Sheppard (view profile)

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

ExcelCol(In)

image thumbnail

updated 3 years ago

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

Antonio (view profile)

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

xlsread1(file,sheet,range,mode,customFun)

Contact us