Excel Datareader

Idea created by Bob Gill on Mar 27, 2018
    Open for voting
    Score8
    • heheimann
    • raym
    • Bob Gill
    • mklann
    • vminea@seniorsoftware.ro
    • pyurpaul
    • g.kohrs@sdg-consulting.de
    • rvandenberg

    Image result for excel cartoonImage result for arrow cartoon

     

    While I understand why CSV files can be more standardized and consistent for ETL processes, I think it's time to add Excel as an option for a datareader. A user can specify the filename, and tab name to be used for the datareader.

     

    Use Case

    • An excel file is produced and placed on a network share
    • A user clicks a button to run the Excel datareader to load data from a particular tab into BOARD

     

    Current Workaround

    • Open the file in Excel 
    • Save As...CSV file into a network folder
    • Open BOARD
    • Click a button to run a CSV datareader to load the data into BOARD

     

    Data can still be imported into BOARD without too much effort. This would be a nice-to-have feature to streamline the import of external files.