image thumbnail

updated 7 hours 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 19 days 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 28 days ago

Search( filetype,folderpath) by anthony bobbie

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

Search( filetype,folderpath)

image thumbnail

updated 2 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 3 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 3 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 4 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 4 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 7 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 8 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 10 months ago

xlswritefig by Michelle Hirsch

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

image thumbnail

updated 10 months ago

xlswrite by Michelle Hirsch

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

image thumbnail

updated 10 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 11 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 11 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 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 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 almost 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 almost 2 years 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 almost 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 almost 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 almost 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 almost 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 almost 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 almost 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
  • 206 downloads
  • 4.83333

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

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 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 almost 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)

output=ExcelCol(x)

image thumbnail

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

Out=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)

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

image thumbnail

updated 3 years ago

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

DS (view profile)

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

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

David Groppe (view profile)

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

XLS Import tool by Findlay Yeates

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

DBDump(DatabaseFileXls)

image thumbnail

updated 4 years ago

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

Jiro Doke (view profile)

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

pivottable by Zhiqiang Zhang

Zhiqiang Zhang (view profile)

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

michael arant (view profile)

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)

Contact us