FastFillGrid 1.0

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

Requirements:	No special requirements
Platforms:	Matlab
Keyword:	Abc,  Actxcontrol Owc Spreadsheet,  Adjust,  Autofit,  Automatically,  Columnwidth,  Entry,  Fancy,  Fastfillgridspreadsheetm,  Figure,  Graph Table,  It039s,  Logical,  Questdlgwithgrid,  Searchandreplacemany,  Spreadsheet,  Widest,  Works
Users rating:	0/10