This is the Windows app named ExcelDataSet whose latest release can be downloaded as cDataset.xlsm. It can be run online in the free hosting provider OnWorks for workstations.
Download and run online this app named ExcelDataSet with OnWorks for free.
Follow these instructions in order to run this app:
- 1. Downloaded this application in your PC.
- 2. Enter in our file manager https://www.onworks.net/myfiles.php?username=XXXXX with the username that you want.
- 3. Upload this application in such filemanager.
- 4. Start any OS OnWorks online emulator from this website, but better Windows online emulator.
- 5. From the OnWorks Windows OS you have just started, goto our file manager https://www.onworks.net/myfiles.php?username=XXXXX with the username that you want.
- 6. Download the application and install it.
- 7. Download Wine from your Linux distributions software repositories. Once installed, you can then double-click the app to run them with Wine. You can also try PlayOnLinux, a fancy interface over Wine that will help you install popular Windows programs and games.
Wine is a way to run Windows software on Linux, but with no Windows required. Wine is an open-source Windows compatibility layer that can run Windows programs directly on any Linux desktop. Essentially, Wine is trying to re-implement enough of Windows from scratch so that it can run all those Windows applications without actually needing Windows.
SCREENSHOTS
Ad
ExcelDataSet
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.
Features
- Perform Database like operations quickly in memory
- Field - Record - Table - Table Collection objects
- Recordset like record navigation
- Input / Output to XML
- Method Chaining
User interface
Win32 (MS Windows)
Programming Language
Visual Basic for Applications (VBA)
Database Environment
Project is a tool for a proprietary database file format
Categories
This is an application that can also be fetched from https://sourceforge.net/projects/exceldataset/. It has been hosted in OnWorks in order to be run online in an easiest way from one of our free Operative Systems.
