The following warnings occurred:
Warning [2] count(): Parameter must be an array or an object that implements Countable - Line: 795 - File: showthread.php PHP 7.4.33 (FreeBSD)
File Line Function
/showthread.php 795 errorHandler->error





Post Reply 
Question re accessing Spreadsheet Cells
12-18-2014, 08:13 AM (This post was last modified: 12-18-2014 08:18 AM by bobkrohn.)
Post: #1
Question re accessing Spreadsheet Cells
to programmatically address a Spreadsheet Cell according to the User Guide:

"Spreadsheet.A1" would retrieve the contents of Cell A1

Is there a way to use a variable for the Cell reference?
Something like:

MyCellRef:="A1";
Spreadsheet.MyCellRef;

or

MyCol:="A";
MyRow:=1;
MyCellRef:=MyCol + MyRow;
Spreadsheet.MyCellRef;


Nice if the Function for getting or setting a Cell was:

X:=Spreadsheet.(Row,Col);
or
X:=Spreadsheet.Cell(Row,Col);
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Question re accessing Spreadsheet Cells - bobkrohn - 12-18-2014 08:13 AM



User(s) browsing this thread: 1 Guest(s)