GSpreadsheets Component

Properties Methods Events Configuration Settings Errors

The GSpreadsheets component provides a simple interface to manage spreadsheets.

Syntax

nsoftware.InGoogle.Gspreadsheets

Remarks

GSpreadsheets allows you to easily create, query, update, and delete spreadsheet information.

Before using the component you must have a valid Google account.

Once you have a valid Google account, set User and Password to your e-mail address and password before calling any of the methods.

The component allows you to create, modify, and delete worksheets and rows in the spreadsheet. You can also modify individual cell contents. This is achieved through the following methods:

To perform a query on the cells, rows, spreadsheets, or worksheets first use AddQueryParam to build the list of parameters to use when querying (if any). Then call one of the following methods:

For more information please see the description for each of the individual methods.

Note: The Google Spreadsheets API supports fetching a list of spreadsheets and editing their contents for the authenticated user. However the Google Spreadsheets API does not allow you to create or delete spreadsheets. For these operations, you must use the GDocuments component.

This service supports authentication via OAuth 2.0. First, perform OAuth authentication using the OAuth component or a separate process. Once complete you should have an authorization string which looks like:

Bearer ya29.AHES6ZSZEJzATdZYjeihDn5W-VrXSsxEZu5p0pclxGdKKQ

Assign this value to the Authorization property before attempting any operations. Consult the Google documentation for this particular service for more information about supported scope values and more details on OAuth authentication.

Alternatively, this service also supports Client Login authentication by setting the User and Password configuration settings.

Property List

The following is the full list of the properties of the component with short descriptions. Click on the links for further details.


Authorization	OAuth 2.0 Authorization Token.
CellCount	The number of cells contained within a Google Worksheet Cell feed.
CellDateUpdated	Contains the date that a cell was updated.
CellDetails	The cell details for the current cell in a worksheet.
CellETag	The ETag of the current cell in a Google Worksheet Cell feed.
CellIndex	The index of the current cell in a Google Worksheet Cell feed.
CellProperties	A collection of properties for the current Google Worksheet Cell.
Cookies	Collection of cookies.
FeedProperties	The feed elements of a Google Data feed.
Firewall	A set of properties related to firewall access.
Idle	The current status of the component.
LocalHost	The name of the local host or user-assigned IP interface through which connections are initiated or accepted.
OtherHeaders	Other headers as determined by the user (optional).
ParsedHeaders	Collection of headers returned from the last request.
Proxy	A set of properties related to proxy access.
QueryParams	Addtional query parameters to be included in the request.
RowCount	The number of rows contained within a Google Worksheet Row feed.
RowDateUpdated	Contains the date that a row was updated.
RowDetails	The row details for the current row in a worksheet.
RowETag	The ETag of the current row in a Google Worksheet Row feed.
RowIndex	The index of the current row in a Google Worksheet Row feed.
RowProperties	A collection of properties for the current Google Worksheet Row.
SpreadsheetAuthor	Contains the name and e-mail address of the author that created the spreadsheet.
SpreadsheetCount	The number of spreadsheets contained within a Google Spreadsheet feed.
SpreadsheetDateUpdated	Contains the date that a spreadsheet was updated.
SpreadsheetETag	The ETag of the current spreadsheet in a Google Spreadsheet feed.
SpreadsheetIndex	The index of the current spreadsheet in a Google Spreadsheet feed.
SpreadsheetProperties	A collection of properties for the current Google Spreadsheet.
SpreadsheetTitle	Contains the title of the spreadsheet.
SSLAcceptServerCert	Instructs the component to unconditionally accept the server certificate that matches the supplied certificate.
SSLCert	The certificate to be used during SSL negotiation.
SSLServerCert	The server certificate for the last established connection.
Timeout	A timeout for the component.
WorksheetColumnCount	Contains the number of columns within the current worksheet.
WorksheetCount	The number of worksheets contained within a Google Worksheet feed.
WorksheetDateUpdated	Contains the date that a worksheet was updated.
WorksheetETag	The ETag of the current worksheet in a Google Worksheet feed.
WorksheetIndex	The index of the current worksheet in a Google Worksheet feed.
WorksheetProperties	A collection of properties for the current Google Worksheet.
WorksheetRowCount	Contains the number of rows within the current worksheet.
WorksheetTitle	Contains the title of the worksheet.
XAttributes	A collection of attributes of the current element.
XChildren	Collection of child elements of the current element.
XElement	The name of the current element.
XNamespace	The namespace of the current element.
XParent	The parent of the current element.
XPath	Provides a way to point to a specific element in the document.
XPrefix	The prefix of the current element.
XSubTree	A snapshot of the current element in the document.
XText	The text of the current element.

Method List

The following is the full list of the methods of the component with short descriptions. Click on the links for further details.


AddQueryParam	Adds a query parameter to the QueryParams properties.
Config	Sets or retrieves a configuration setting .
CreateRow	Creates a new row within the specified Google Worksheet.
CreateWorksheet	Creates a new worksheet within the specified Google Spreadsheets feed.
DeleteRow	Deletes a row within a Google Worksheet.
DeleteWorksheet	Deletes a worksheet within a Google Worksheets feed.
QueryCells	Queries a Google Worksheet Cells feed using the specified parameters.
QueryRows	Queries a Google Worksheet Rows feed using the specified parameters.
QuerySpreadsheets	Queries a Google Spreadsheets feed using the specified parameters.
QueryWorksheets	Queries a Google Worksheets feed using the specified parameters.
UpdateCell	Updates a cell within a Google Worksheet.
UpdateRow	Updates a row within a Google Worksheet.
UpdateWorksheet	Updates a Google Worksheet.

Event List

The following is the full list of the events fired by the component with short descriptions. Click on the links for further details.


CellList	Fired once for each cell entry retrieved.
Connected	Fired immediately after a connection completes (or fails).
Disconnected	Fired when a connection is closed.
EndTransfer	Fired when a document finishes transferring.
Error	Information about errors during data delivery.
Header	Fired every time a header line comes in.
RowList	Fired once for each row entry retrieved.
SetCookie	Fired for every cookie set by the server.
SpreadsheetList	Fired once for each spreadsheet entry retrieved.
SSLServerAuthentication	Fired after the server presents its certificate to the client.
SSLStatus	Shows the progress of the secure connection.
StartTransfer	Fired when a document starts transferring (after the headers).
Status	Fired when the HTTP status line is received from the server.
Transfer	Fired while a document transfers (delivers document).
UpdateACLResponse	Fired once for each entry returned after updating a document ACL.
WorksheetList	Fired once for each worksheet entry retrieved.

Configuration Settings

The following is a list of configuration settings for the component with short descriptions. Click on the links for further details.


CellValue	The value in the cell.
RowHeaderCount	Total number of cells in the header row.
RowHeader[i]	Value of the row header cell.
SetRowHeaders	Action to create and insert row header values.
AccountType	The type of account to request authorization for.
CaptchaToken	The token received from Google during a CAPTCHA challenge.
CaptchaURL	The image URL received from Google during a CAPTCHA challenge.
CaptchaValue	The value given by the person responding to the CAPTCHA challenge.
DateFormat	The format string to be used for formatting the DateTime values received from the server.
NameAndEmailFormat	Determines how the data of the name and e-mail properties will be formatted.
Source	The source parameter value for Google ClientLogin.
TransferredData	The contents of the last response from the server.
TransferredHeaders	The full set of headers as received from the server.
ServiceName	The name of the Google Data service.
User	The user's email address used for Client Login authentication.
Password	The user's password used for Client Login authentication.
AcceptEncoding	Used to tell the server which types of content encodings the client supports.
AllowHTTPCompression	This property enables HTTP compression for receiving data.
AllowIdenticalRedirectURL	Allow redirects to the same URL.
Append	Whether to append data to LocalFile.
Authorization	The Authorization string to be sent to the server.
BytesTransferred	Contains the number of bytes transferred in the response data.
EncodeURL	If set to true the URL will be encoded by the component.
FollowRedirects	Determines what happens when the server issues a redirect.
GetOn302Redirect	If set to true the component will perform a GET on the new location.
HTTPVersion	The version of HTTP used by the component.
IfModifiedSince	A date determining the maximum age of the desired document.
KeepAlive	Determines whether the HTTP connection is closed after completion of the request.
MaxRedirectAttempts	Limits the number of redirects that are followed in a request.
OtherHeaders	Other headers as determined by the user (optional).
ProxyAuthorization	The authorization string to be sent to the proxy server.
ProxyAuthScheme	The authorization scheme to be used for the proxy.
ProxyPassword	A password if authentication is to be used for the proxy.
ProxyPort	Port for the proxy server (default 80).
ProxyServer	Name or IP address of a proxy server (optional).
ProxyUser	A user name if authentication is to be used for the proxy.
TransferredDataLimit	The maximum number of incoming bytes to be stored by the component.
TransferredHeaders	The full set of headers as received from the server.
UseChunkedEncoding	Enables or Disables HTTP chunked encoding for transfers.
ChunkSize	Specifies the chunk size in bytes when using chunked encoding.
UserAgent	Information about the user agent (browser).
KerberosSPN	The Service Principal Name for the Kerberos Domain Controller.
ConnectionTimeout	Sets a separate timeout value for establishing a connection.
FirewallAutoDetect	Tells the component whether or not to automatically detect and use firewall system settings, if available.
FirewallHost	Name or IP address of firewall (optional).
FirewallPassword	Password to be used if authentication is to be used when connecting through the firewall.
FirewallPort	The TCP port for the FirewallHost;.
FirewallType	Determines the type of firewall to connect through.
FirewallUser	A user name if authentication is to be used connecting through a firewall.
KeepAliveTime	The inactivity time in milliseconds before a TCP keep-alive packet is sent.
KeepAliveInterval	The retry interval, in milliseconds, to be used when a TCP keep-alive packet is sent and no response is received.
Linger	When set to True, connections are terminated gracefully.
LingerTime	Time in seconds to have the connection linger.
LocalHost	The name of the local host through which connections are initiated or accepted.
LocalPort	The TCP port in the local host where the component binds.
MaxLineLength	The maximum amount of data to accumulate when no EOL is found.
MaxTransferRate	The transfer rate limit in bytes per second.
RecordLength	The length of received data records.
TCPKeepAlive	Determines whether or not the keep alive socket option is enabled.
UseIPv6	Whether to use IPv6.
TcpNoDelay	Whether or not to delay when sending packets.
ReuseSSLSession	Determines if the SSL session is reused.
SSLCipherStrength	The minimum cipher strength used for bulk encryption.
SSLEnabledProtocols	Used to enable/disable the supported security protocols.
SSLProvider	The name of the security provider to use.
SSLSecurityFlags	Flags that control certificate verification.
OpenSSLCADir	The path to a directory containing CA certificates.
OpenSSLCAFile	Name of the file containing the list of CA's trusted by your application.
OpenSSLCipherList	A string that controls the ciphers to be used by SSL.
OpenSSLPrngSeedData	The data to seed the pseudo random number generator (PRNG).
AbsoluteTimeout	Determines whether timeouts are inactivity timeouts or absolute timeouts.
FirewallData	Used to send extra data to the firewall.
InBufferSize	The size in bytes of the incoming queue of the socket.
OutBufferSize	The size in bytes of the outgoing queue of the socket.
CodePage	The system code page used for Unicode to Multibyte translations.