One Liners

Page Content hide
1 What can you learn here?
2 Complex stuff in a few lines of code get it now
3 References
4 cDataSet class
4.1 Clear data cells with cDataSet
4.2 Coloring maps and other shapes
4.3 Create a list of unique values
4.4 Excel to Json and output to file
4.5 General copy and filter worksheet
4.6 Getting data out of scraperWiki
4.7 How to identify and modify rows hidden by autofilter
4.8 Make a copy of a sheet and respect autofilter
4.9 Make a copy of a worksheet
4.10 Make a copy of some of the columns in a worksheet
4.11 Make a filtered copy of a worksheet
5 cJobject class
6 cRest class
7 cPersistence class

What can you learn here?

  • Using ramblings libraries
  • Short code snippets
  • Abbreviated explanations

 

Complex stuff in a few lines of code  get it now

This section is going to cover how to do complex stuff in just a few lines, mainly using the classes and modules you can find in the cDataSet.xlsm (or the Google Apps Version), which you can download here. In many cases you may not actually be using these classes, just leveraging some of their inbuilt properties and methods. They probably wont be exactly ‘one liners’, but pretty close.

 

References

You may need some additional VBA references, all of which are defined in the cDataSet.xlsm file. If you use that, all the references are already defined.

 

cDataSet class

This class abstracts data from its physical location and lays  a common object model over Excel and Google Apps Script to allow for easy migration. See How to use cDataSet to get started.

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 …
Read More
Coloring maps and other shapes
In Using Google Maps I covered how to create various web based interactive maps. Of course many would like to use Excel …
Read More
Create a list of unique values
How to use cDataColumn.uniqueValues() to create a list The .uniqueValues() method of cDataColumn will return a collection of cells – …
Read More
Excel to Json and output to file
Let’s say you want to do Excel JSON conversion and output the result to a file. Here’s how Sub ExCelToWebFile() …
Read More
General copy and filter worksheet
Copying and filtering to columns on a target worksheet In Make a filtered copy of a worksheet I covered how …
Read More
Getting data out of scraperWiki
What is scraper wiki Scraper wiki is an environment which allows you to put some structure around data published in web …
Read More
How to identify and modify rows hidden by autofilter
In Make a copy of a sheet and respect autofilter I covered a one liner to make a copy only …
Read More
Make a copy of a sheet and respect autofilter
In General copy and filter worksheet I showed how to copy a sheet using filters passed as arguments to the …
Read More
Make a copy of a worksheet
How to use cDataSet.bigCommit() to create a copy of the values in a sheet The .bigCommit() method of cDataSet will …
Read More
Make a copy of some of the columns in a worksheet
How to use cDataSet.bigCommit() to create a copy of the values in a sheet, re-ordering and/or only copying some of …
Read More
Make a filtered copy of a worksheet
How to use cDataSet.bigCommit() to create a copy of the values in a sheet, and filter the results In Make …
Read More

 

cJobject class

This class is used to make javaScript like objects available in VBA, and to convert stuff to and from jSon. See How to use cJobject for more information and is available in both VBA and Google Apps Script

 

cRest class

This class is used in the Rest to Excel library in order to query REST APIs and decode the responses. There is both a VBA   version and a Google Apps Script version

 

cPersistence class

This class is used to store data from user forms in a hidden shape to make it persistent from one use to the next.

Take a look at Get Started Snippets for more tips like this. In the meantime why not join our forum, follow the blog or follow me on twitter to ensure you get updates when they are available.