Classes

cHeadingRow

Summary This is a special type of cDataRow and is used for managing the column headers of a cDataSet You can find the methods and properties documentation on github. And the source code is on Gitbub or below

 

Classes

cDataColumn

Summary This is a column of cCell . The rowId argument refers to the row either by row name (where we have enabled labels) or a row number. Where rowId optional and omitted the complete column is operated on. Where rowId is present the the cCell it […]

Classes

cDataRow

This is a row of cCell . The sid argument refers to the column either by column name or number. Where sid optional and omitted the complete row is operated on. Where sid is present the cCell it addresses in the cDataRow is operated on.  For example cDataRow.Refresh() […]

Classes

Promises in VBA

Using promises in JavaScript and other languages is the preferred way to orchestrate the completion of asynchronous activities. Here’s a (not perfect but fun) Promise implementation in VBA. Example includes getting data from Google Fusion tables. […]

Classes

cDataSet Model

What to download: All the examples contain all the classes needed for them to work and all projects can be found here. If you just want the main utility classes used throughout this site, in […]

Classes

CDataSets

Summary This is a collection of cDataSet You can find the methods and properties documentation on github. And the source code is here

Classes

cCell Class

  This class addresses and manipulates a single excel cell and its contents.  You can find the methods and properties documentation on github. The code is also below

 

Classes

cDataSet

Summary This is a block of cCell  consisting of a collection of  cDataRow, with an abstraction of a collection of cDataColumn The sid argument refers to the column either by column name or number and the rowID refers to the particular row by number, […]