Excel File

The Excel File Data Source

AbstractData allows for the transfer of data between other data sources and Excel .xlsx files. The type in the scripting language is ExcelFile and can be referenced like this:

>> # The standard way to create a reference to a database
>> ExcelFile xlsx1 = "C:\the\path\to\the\file.xlsx"
>> # Or the Constructor Syntax
>> ExcelFile xlsx2 = new ExcelFile(fileName = "C:\the\path\to\the\file.xlsx")

The currently tested versions of Excel files found to be working for this have been files generated by Excel 2013 and 2016. More testing is needed on 2007 and 2010 versions. This database module is based on the ClosedXML Library located here: https://github.com/closedxml/closedxml