Data Manipulation Classes

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

Page Content hide

1 cCell Class

2 cDataColumn

3 cDataRow

4 cDataSet

5 CDataSets

6 cHeadingRow

7 Copying and filtering worksheets and Excel tables

8 Data Abstraction Example

9 Get Data from Outlook

10 How to use cDataSet

11 cDataSet Model

12 Clear data cells with cDataSet

13 How to make a table from a cdataset

14 Tables and listobjects

14.1 What to download

cCell Class

The cCell class addresses and manipulates a single excel cell and its contents.  You can find the ...

cDataColumn

Summary cDataColumn is a column of cCell  . The rowId  argument refers to the row either by row nam...

cDataRow

cDataRow is a row of cCell  . The sid  argument refers to the column either by column nam...

cDataSet

Summary CdataSet is a block of cCell  consisting of a collection of  cDataRow , with an abstraction of...

CDataSets

  Summary   CDataSets is a collection of cDataSet You can find th...

cHeadingRow

  Summary cHeadingRow 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. ...

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() 

Subpages