FastFillGrid
Nessuna licenza
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
Cita come
Michael Robbins (2024). FastFillGrid (https://www.mathworks.com/matlabcentral/fileexchange/8436-fastfillgrid), MATLAB Central File Exchange. Recuperato .
Compatibilità della release di MATLAB
Compatibilità della piattaforma
Windows macOS LinuxCategorie
Tag
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Scopri Live Editor
Crea script con codice, output e testo formattato in un unico documento eseguibile.
Versione | Pubblicato | Note della release | |
---|---|---|---|
1.0.0.0 |