ExcelDataSet
- Downloads:
- Views:
- Rating:

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.
Perform Database like operations quickly in memory, Field - Record - Table - Table Collection objects, Recordset like record navigation, Input / Output to XML, Method Chaining
ExcelDataSet License - Creative Commons Attribution License
Free download from Shareware Connection - In Excel have you ever wanted to have database like functionality be able to run from within VBA.
Version: 1.0 | Platform: WinOther
Released Date: | Rating: 0 | Title: ExcelDataSet
Author Url: http://exceldataset.sourceforge.net
Program Info Url: http://exceldataset.sourceforge.net
Download Url: http://exceldataset.sourceforge.net
Screenshot Url: http://sourceforge.net/projects/exceldataset/screenshots/Capture.PNG
Excel to MySQL Import, Export & Convert
MS Excel viewer
Steam Calculator
Excel Split Names & Addresses Into Multiple Cells (Columns) Software
Excel Invoice Template Software
PDF2XL OCR: Convert PDF to Excel
Excel Access Import, Export & Convert Software
Excel Unique & Duplicate Data Remover
Excel Add, Subtract, Multiply, Divide All Cells Software
Asset Register PRO For Excel
Multiple Regression Analysis and Forecasting
eTikr - Free Stock Quotes for Excel
Excel MySQL Import, Export & Convert
ExcelFIX Data Recovery
Business Cards & Labels
Business Performance Management
Database Management
Finance
Graphics
Inventory Systems
Invoice, Time & Billing
Legal
PDF Tools
Personal Information Management
Presentation Tools
Project Management
Spreadsheets
Sticky Notes
Vba Excel Run Crystal
Vba Excel Run Crystal Reports
Access Vba Run Report Excel
Excel Vba Run Crystal Report
Excel Run Sql External Database
Shareware Connection periodically updates pricing and software information of 'ExcelDataSet' from company source 'Exceldataset' , so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft, Using 'ExcelDataSet' crack, password, serial numbers, registration codes, key generators is illegal and prevent future development of ExcelDataSet.
Trend Micro HouseCall - With time, PC users find it increasingly difficult to keep their systems free of malware and rogue apps, despite using latest and feature packed security software. This is mostly owing to the evolving nature of malware and newer types of ...
Sculptris - For 3D modeling and design, there are so many apps to pick from noondays. From feature laden and expensive apps of Autodesk to mid level and lesser known contenders, users are spoilt for choice. However, it is also possible to use a decently ...
Skitch - Skitch is a user friendly and lightweight image capturing app for OS X that has been in the scene for quite some time. After its purchase by Evernote, the nifty Mac screen-capture tool has undergone some changes. You can still perform tasks with ...
CherryPlayer - When you want to watch movies, online videos or listen to music tracks, using a suitable application is required. There is no hard and fast rule that you have to stick to Windows default media player software for such needs. There are plenty of ...
Xion Audio Player - People use computers for various reasons including official work and entertainment. However, it is quite natural for a workaholic to play music files to alleviate boredom at times. If you have no penchant for the WMP bundled with your copy of ...
Portable SMPlayer - Using media player software is something PC users are not alien to, as it is. Even the most workaholic users indulge in listening to music tracks at times. While the WMP, which comes with Windows, may serve needs for some users, it is not ...
SumatraPDF - The PDF format is used worldwide to distribute document files without changing formatting, alignment and layout. It can also be used to share complex engineering designs and diagrams along with massive amounts of text. The biggest benefit of this ...
MusicBee - Irrespective of what type of a PC you use, it will be necessary to use a media player app from time to time. If the WMP is not your cup of tea, you will have to pick from third-party music player apps. The problem with some such apps is that ...
Nero Kwik Media - Nero is known mostly for its legendary disc burning software that has metamorphosed into a media editing powerhouse over a decade. The multimedia suite offered by the company caters to needs of intermediate and advanced users well but its price ...
Norton Power Eraser - Getting rid of malware and other types of rogue applicationlications with a regular antivirus can prove to be a tough task nowadays. The way malicious users are becoming smarter with time; it makes sense to use an additional layer of protection ...
