image thumbnail

FillGrid

version 1.0.0.0 (50.9 KB) by Michael Robbins
Populates a grid, i.e. Microsoft Spreadsheet Object, with a cell array.

2.3K Downloads

Updated 03 Jun 2005

No License

FILLGRID populates a grid, i.e. Microsoft Spreadsheet Object, with a cell array

The cell array may contain mixed types.

FILLGRID(SPREADSHEET,M) populates SPREADSHEET with M
FILLGRID(SPREADSHEET,M,DOPASTE) usage obsolete
FILLGRID(SPREADSHEET,M,DOPASTE,DOWAITBAR) also uses a progress indicator if DOWAITBAR is 1 (default), does not if DOWAITBAR is 0
FILLGRID(SPREADSHEET,M,DOPASTE,DOWAITBAR,MINR,MINC,MAXR,MAXC) specifies the minimum and maximum rows and cloumns to use

FILLGRID(SPREADSHEET,M,DOPASTE,DOWAITBAR,MINR,MINC,MAXR,MAXC,ASSTR) forces all values to be placed as strings, instead of the default behavior which populates the grid with numbers when possible.

Example:
figure;
spreadsheet = actxcontrol('OWC11.Spreadsheet.11',[0 0 200 200]);
M = {'abc', 123; 12.17, logical(1)};
FillGrid(spreadsheet,M);

Cite As

Michael Robbins (2022). FillGrid (https://www.mathworks.com/matlabcentral/fileexchange/7765-fillgrid), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R13
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!