Publisher review: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 arrayThanks Brett Shoelson, via CSSMPUTCELLVALUE puts a value in an active cellfastfillgrid is both a directory and a function.FastFillGrid populates a grid, i.e. Microsoft Spreadsheet Object, with a cell arrayThe cell array may contain mixed types.FastFillGrid(SPREADSHEET,M) populates SPREADSHEET with MFastFillGrid(SPREADSHEET,M,DOPASTE) usage obsoleteFastFillGrid(SPREADSHEET,M,DOPASTE,DOWAITBAR) also uses a progress indicator if DOWAITBAR is 1 (default), does not if DOWAITBAR is 0FastFillGrid(SPREADSHEET,M,DOPASTE,DOWAITBAR,MINR,MINC,MAXR,MAXC) specifies the minimum and maximum rows and cloumns to useFastFillGrid(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 WORKSSee also Graph_and_Table, QuestDlgWithGrid, SearchAndReplaceMany, SpreadSheet, DatabaseEditingTool, DuplicateFileFinder,PutCellValue, nn2an, FillGrid, xlsread xlswrite xlsinfoKeywords: grid spreadsheet ActiveX Active-X Active X GUI Table graph_and_table plot graph table grid object flexgrid msflexgrid ocx tabular xlsread xlswrite Requirements: ยท MATLAB Release: R14SP2
FastFillGrid is a Matlab script for Development Tools scripts design by Michael Robbins.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
FastFillGrid populates a grid, i.e. Microsoft Spreadsheet Object, with a cell array.
Operating system:Windows / Linux / Mac OS / BSD / Solaris