XLDS

XLDS is one of its kind add-in specializing in general data processing with the following features: Query/Import Data from External Data/Text/ASCII Files Query/Import Data from Multiple Closed Excel Files Query/Import Data from Remote Internet/Websites Query/Consolidate Data from Multiple Worksheets Query/Conditional Statistics on A Selected Range Operation/Conditional Highlight on A Selected Range Lookup Value based on Selected Range and Keyword Extract and Re-Arrange Record from A Table Compare Same Range of Two Different Sheets Assign Shortcut KeysUser-Defined Functions # Query/Import Data from Multiple External Data/Text/ASCII Files This feature is used to import data from multiple external text files. The external files can be stored under the same main directory but different subdirectories. Once the import criteria are setup, useful data can be imported directly into Excel table from hundreds of files. Of course, all the external files to be imported should have Similar data arrangement, like output files from the same program. The import criteria can be setup using absolute line/column numbers within the files, or relative line/column number comparing to a specific searchable keyword. This feature is very useful when user work on a sensitivity study and want to Create a summary table. Because all the output files are create from same program and thus have similar data arrangement. # Query/Import Data from Multiple Closed Excel Workbook Files This feature is used to extract useful information from multiple close Excel workbook files. These workbook files can be stored under the same main directory.