ExcelDataSet Icon


Excel Data Manipulation Classes

Add a Review
10 Downloads (This Week)
Last Update:
  Browse Code Git Repository



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


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


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)



Thanks for helping keep SourceForge clean.

Screenshot instructions:
Red Hat Linux   Ubuntu

Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)

More information about our ad policies

Briefly describe the problem (required):

Upload screenshot of ad (required):
Select a file, or drag & drop file here.

Please provide the ad click URL, if possible:

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks