Excel Datareader
Unknown
Active Partner
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.
11
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 325 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 192 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP