FillGrid

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

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