Home > By category > Business & Productivity Tools >Spreadsheets > ExcelDataSet



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.

Publisher: Exceldataset | License: Freeware | Price: 0.00
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

ExcelDataSet related downloads:

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.

New Reviews

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




New Downloads

Joyoshare Media Cutter for
Mac

Joyoshare Media Cutter for Mac
is an all-in-one video cutter
that can cut any video and
audio file, including MP4,
AVI, ...

StarCode Express POS and
Inventory

StarCode Express Plus is
standalone POS (Point of Sale)
and Inventory Manager. Best
suited for small businesses
and ...

EximiousSoft Logo Designer

EximiousSoft Logo Designer is
great software for logo
creator, logo maker. You can
create any shape graphics with
drawing ...

Alpha Clipboard Recorder

Free Clipboard Record. Alpha
Clipboard is a lightweight,
handy and convenient solution
to expand your Windows
clipboard ...

LeoPictute

LeoPicture provides a
convenient instrumentation for
manipulating images for broad
spectra of customers from
digital ...

SSuite Photo Gallery
Portable

SSuite Photo Gallery Portable
is a program which allows you
to easily create albums from
your image files, in a ...

VistaTrades

A free stock screener with
back testing. Enter actual
trades and get emails to your
smartphone for actions to take
on ...

XnConvert

XnView shell extension allows
for viewing a thumbnail of the
selected image in the context
menu of MS Explorer.

ManageEngine ServiceDesk
Plus

ServiceDesk Plus is a web
based, easy to use Help Desk
and Asset Mgmt software with
integrated project
management. ...

XnView

XnView is a fast multi-format
graphics browser, viewer, and
converter. It reads more than
400 file formats. Its main ...

Staff Scheduler Pro

Employee management software
with stunning set of features.
Software to manage employee
information, scheduling and
...

HourGuard Timesheet Free
for Mac

HourGuard timesheet software
free for Mac OS X is an easy
time recording software that
is ideal for freelancers and
...