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
Taxi App Development 7.3
RentALL-Airbnb clone script 1.8.0
VisualNEO Web 19.4.5
PHP Ecommerce Script 1.3.2
dbForge Studio for PostgreSQL 2.1
Rentonn - Airbnb clone 1.0
VisualNEO for Windows 18.08.31.0
SentiVeillance SDK Trial 7.0.191272
dbForge SQL Complete 6.1
Uber for E-Scooters 1.0
ODBC Driver for MySQL 2.4
dbForge Schema Compare for MySQL 4.4
dbForge Studio for MySQL 8.1
dbForge Query Builder for MySQL 4.4
dbForge Data Compare for MySQL 5.5
Top Code
JChartLib 1.0
Efficient Conjugate Gradient Method for Symmetric Banded Matrix 1.0
Binary MLM Plan 1.0.2
Content Management Framework (CMF) 1.5.0
decision based median filter 1.0
PHP Cheat Sheet
Knapsack problem 1.0
untrimmed median filter 1.0
DSPLAB for Delphi 2.01
b64 -- Base64 Encode/Decode Utility 1.0
Using GetDate Function in an SQL Statement
Tutorials on Creating, Compiling and running CUDA Accelerated programs in Matlab 1.0
The Travelling Salesman Problem using GA 1.0
Comment Approval Notification 1.1.1
EBookLibrary 1.0
Top Rated
Paste phpSoftPro 1.4.1
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
Invoice Manager by PHPJabbers 3.0
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
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