FastFillGrid

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

Description

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

• MATLAB release: MATLAB 7.0.4 (R14SP2)
• Other requirements: Microsoft Excel

[dave holden]

Found a few bugs,
% MaxR = min(L,MaxR); % orginal from Author
% MaxC = min(W,MaxC);
MaxR = min(L,MaxR) + MinR -1; % fix
MaxC = min(W,MaxC) + MinC -1;

[Yaser Norouzi]

There is a minor error in this program,