Search
Code Directory
 ASP
 ASP.NET
 C/C++
 CFML
 CGI/PERL
 Delphi
 Development
 Flash
 HTML
 Java
 JavaScript
 Pascal
 PHP
 Python
 SQL
 Tools
 Visual Basic & VB.NET
 XML
New Code
Magento Australia Post eParcel Extension 1.0
Airbnb Script - Airbnb Clone 1.0.3
Hotel Restaurant Reviews and Feedback Script 1.0.3
Documenter for MySQL 1.0
ODBC Driver for xBase 1.1
ODBC Driver for FreshBooks 2.0
AnyGantt JS Gantt Charts 8.4.2
The C# Barcode Library 4.0.2.2
ConyEdit for Windows 1.1.0
wolfSSL 3.15.5
Taxi Booking App Like Uber 1.0
IP2Location Geolocation Database 2018
Food Delivery Script 1.0.3
ODBC Driver for Magento 1.3
dbForge Studio for SQL Server 5.6
Top Code
Computational Statistics: Feature Selection, Regularization, and Shrinkage 1.0
Cuckoo Search (CS) Algorithm 1.0
Cuckoo Optimization Algorithm 1.0
AllWebMenus WordPress Menu Addin 1.0.8
Visual Basic game template 1.0
Open Source Visual Basic.Net Compiler 1.0
Basic 7 7
RAM Library b.2.7
DJ Java Decompiler 3.11.11.95
Guestbook-Comment Script 2.0
Top Rated
Deals and Discounts Website Script 1.0.2
ADO.NET Provider for ExactTarget 1.0
Solid File System OS edition 5.1
Classified Ad Lister 1.0
Aglowsoft SQL Query Tools 8.2
ICPennyBid Penny Auction Script 4.0
PHP Review Script 1.0
ATN Resume Finder 2.0
ATN Site Builder 3.0
Availability Booking Calendar PHP 1.0
PHP GZ Blog Script 1.1
ATN Jobs Software 4.0
ATN Mall 2.0
WeBuilder 2015 13.3
PHP Digital Download Script 1.0.4
FastFillGrid 1.0
File ID: 86983






FastFillGrid 1.0
Download FastFillGrid 1.0http://www.mathworks.comReport Error Link
License: Shareware
File Size: 51.2 KB
Downloads: 4
Submit Rating:
FastFillGrid 1.0 Description
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

License: Shareware

Related: fastfillgridspreadsheetm, Logical, Abc, it039s, Fancy, questdlgwithgrid, graph table, Works, actxcontrol owc spreadsheet, Spreadsheet, adjust, Automatically, autofit, columnwidth, widest, figure, Entry, searchandreplacemany

O/S:BSD, Linux, Solaris, Mac OS X

File Size: 51.2 KB

Downloads: 4



More Similar Code

FASTGETGRID extracts values and formuals form all worksheets in a Microsoft Office Spreadsheet Object (OWC). It also provides the numerical and the string variables seperately

USAGE:

>> h = actxcontrol('OWC11.Spreadsheet.11',[0 0 550 420]);
>> FastFillGrid(h, ...
{'Maturity' ,'4/15/09','' ; ...
'coupon' ,8.63 ,'ANN' ; ...
'redemption' ,100 ,'' ; ...
'Yield' ,10.1660 ,'' ; ...
''...

User Review for FastFillGrid
- required fields
     

Please enter text on the image