ExcelDataSet

Excel Data Manipulation Classes

Add a Review
1 Download (This Week)
Last Update:
  Browse Code Git Repository

Screenshots

Description

In Excel have you ever wanted to have database like functionality be able to run from within VBA. You could link to an MDB which can be slow, and a bit cumbersome. You could also custom write functions to work in the Excel worksheet. If you really want speed you could use an Array in memory, but it can be a bit tiresome writing the code to manipulate the array. ExcelDataSet takes the idea of the C# DataSet and implements an in memory data manipulation framework. It is fast, based on the Windows Scripting Dictionary object. It also outputs to XML.

Crucially it is very easy to load Excel data into the ExcelDataSet tables via an array, manipulate the data in memory and then output it back into an array and the spreadsheet if needed.

ExcelDataSet Web Site

Features

  • Perform Database like operations quickly in memory
  • Field - Record - Table - Table Collection objects
  • Recordset like record navigation
  • Input / Output to XML
  • Method Chaining

Update Notifications





Write a Review

User Reviews

Be the first to post a review of ExcelDataSet!

Additional Project Details

User Interface

Win32 (MS Windows)

Programming Language

Visual Basic for Applications (VBA)

Registered

2012-03-16
Screenshots can attract more users to your project.
Features can attract more users to your project.

Icons must be PNG, GIF, or JPEG and less than 1 MiB in size. They will be displayed as 48x48 images.