FastFillGrid

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

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

Thanks Brett Shoelson, via CSSM

PUTCELLVALUE puts a value in an active cell

fastfillgrid is both a directory and a function.

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

The cell array may contain mixed types.

FastFillGrid(SPREADSHEET,M) populates SPREADSHEET with M

FastFillGrid(SPREADSHEET,M,DOPASTE) usage obsolete

FastFillGrid(SPREADSHEET,M,DOPASTE,DOWAITBAR) also uses a progress indicator if DOWAITBAR is 1 (default), does not if DOWAITBAR is 0

FastFillGrid(SPREADSHEET,M,DOPASTE,DOWAITBAR,MINR,MINC,MAXR,MAXC) specifies the minimum and maximum rows and cloumns to use

FastFillGrid(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.

FastFillGrid(SPREADSHEET,M,DOPASTE,DOWAITBAR,MINR,MINC,MAXR,MAXC,ASSTR,AUTOFIT) if AUTOFIT = 1, then FastFillGrid will automatically adjust the columnwidth to fit the widest entry.

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

IT'S NOT FANCY, BUT IT WORKS

See also Graph_and_Table, QuestDlgWithGrid, SearchAndReplaceMany, SpreadSheet, DatabaseEditingTool, DuplicateFileFinder,PutCellValue, nn2an, FillGrid, xlsread xlswrite xlsinfo

Keywords: grid spreadsheet ActiveX Active-X Active X GUI Table graph_and_table plot graph table grid object flexgrid msflexgrid ocx tabular xlsread xlswrite