image thumbnail

updated 10 days ago

The X Collection by Yvan Lengwiler

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

XAddSheet(hBook,strName,hAfterSheet)

XCloseAllBooks(hExcel)

XCloseBook(hBook)

image thumbnail

updated 26 days 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 26 days 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 4 months ago

xlscolor.m by meysam

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

xlscolor(filename,CellIndex,RGB)

image thumbnail

updated 5 months ago

ReadMultipleSheetsInExcel.m by Thomas Hansen

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

[sheets, RAW]=ReadMultipleSheetsInExcel(FILENAME,flag)

image thumbnail

updated 6 months ago

xlswritefig by Michelle Hirsch

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

image thumbnail

updated 6 months ago

xlswrite by Michelle Hirsch

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

image thumbnail

updated 6 months 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 8 months ago

ERCOT Price Processing Toolbox by Mahdi Kefayati

ERCOT Price Processing Toolbox (price, ercot, excel)

ErcotAsPrices=prcAsPriceData(dataPath)

ErcotDamPrices=prcDamPriceData(dataPath)

ErcotRtmPrices=prcRtmPriceData(dataPath)

image thumbnail

updated 8 months 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 12 months ago

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

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

toTable(Input,varargin)

image thumbnail

updated 1 year 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 1 year 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 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

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

image thumbnail

updated 1 year 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 1 year 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 1 year 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 1 year 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 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 1 year ago

xlsrange by Richard Crozier

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

xlsrange(row1, col1, row2, col2)

image thumbnail

updated almost 2 years ago

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

image thumbnail

updated almost 2 years ago

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. (xlswrite, excel, xlwrite)

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

Test_xlWrite.m

image thumbnail

updated almost 2 years ago

StatisticsPlus Excel AddIn by Laszlo Balkay

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

image thumbnail

updated almost 2 years ago

Grafica datos de excel by maynor

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

graficadatosexcel(varargin)

image thumbnail

updated 2 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 2 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)

[indx]=letter_excel(N)

image thumbnail

updated 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

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

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

cell2char(C)

image thumbnail

updated 2 years ago

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)

image thumbnail

updated 2 years ago

Excel Column Conversion by Mike Sheppard

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

Out=ExcelCol(In)

image thumbnail

updated 2 years ago

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, faster xlsread)

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

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

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

image thumbnail

updated 3 years ago

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)

image thumbnail

updated 3 years ago

Excel column header by Gunnar Aronsen

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

ExcelColHeader(input)

image thumbnail

updated 3 years ago

Excel column number by Gunnar Aronsen

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

ExcelColNo(input)

image thumbnail

updated 3 years ago

Probability Distribution Plotter by Andrew O'Connor

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

PDFBeta(varargin)

ProbDistPlot(varargin)

betahaz(t,A,B)

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

XLS Import tool by Findlay Yeates

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

DBDump(DatabaseFileXls)

image thumbnail

updated 3 years ago

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, webinar, mathworks)

Energy Forecast Demo

ForecastGUI(varargin)

createSurfaceFit(thisHour, thisTemp, thisPower)

image thumbnail

updated almost 4 years ago

pivottable by Zhiqiang Zhang

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

pivottable.m

image thumbnail

updated 4 years ago

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)

image thumbnail

updated 4 years ago

Convert index to Excel A1 notation by Matt Brunner

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

idx2A1(idx)

image thumbnail

updated 4 years ago

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)

image thumbnail

updated 4 years ago

ExcelWrapper by Fayssal El Moufatich

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

ExcelWrapper

image thumbnail

updated 4 years ago

MAT2XLS v2.0 by Elmar Tarajan

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

mat2xls

image thumbnail

updated 4 years ago

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)

Contact us