These classes provide the tools and data structures needed to separate your physical data in your spreadsheet, from how you process it in your procedures. Notice that the row and column numbers begin at 1, and are relative to the start of the dataset (not the row/column on the spreadsheet), in order to abstract the cDataset from its physical location. This class is used throughout this site. Here are just a few examples of the projects illustrating its use. You may want to start with How to use cDataSet
cCell Class
This class addresses and manipulates a single excel cell and its contents. You can find …
cDataColumn
Summary
This is a column of cCell . The rowId argument refers to the row either by row name (wh…
cDataSet
Summary This is a block of cCell consisting of a collection of cDataRow , with an abstraction of …
cHeadingRow
Summary
This is a special type of cDataRow and is used for managing the column headers of…
Copying and filtering worksheets and Excel tables
What can you learn here?
Select worksheets to copy Choose selected columns cDataSets filtering …
Data Abstraction Example
Why abstract anyway? In a number of articles on this site and elsewhere, I have covered topics such …
Get Data from Outlook
How to get data into Excel from your outlook address book get it now
Here’s a common problem. Y…
How to use cDataSet
What can you learn here?
Get Started with cDataSet Short code snippets Abbreviated explanations…
cDataSet Model
What to download:
All the examples contain all the classes needed for them to work and all projects…
Clear data cells with cDataSet
Hopefully you will have read How to use cDataSet to see how to abstract data from your sheet and taken…
How to make a table from a cdataset
From Excel 2003, you could use Tables. A cDataSet is somewhat like a table in that is structured data,…
Tables and listobjects
Nowadays structured references are the preferred way to access table data in Excel and VBA. Although…
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 the Downloads section cDataSet.xlsm includes everything you need including some examples.
All classes have a tearDown method. You can use these to release up any memory when you are done. You execute this for the highest level class you use, typically a cDataSet, as follows
dim ds as cDataSetset ds=new cDataSetwith ds.populateData(someRange) ... do thingsend withds.tearDown()