Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Feb 6, 2016

Import data from multiple excel sheets at once into a single datatable

When an excel file with multiple files have to be imported, it will always allow to choose one sheet at a time to create a data table. Whereas what he / customer is looking for is to merge all the data from different sheets into one data table when importing into Spotfire.

  • Attach files
  • Guest
    Reply
    |
    Nov 5, 2018

    I have many instances where I keep the data for a specific dashboard in one Excel workbook as multiple sheets.  Being able to import multiple sheets as multiple tables would be definitely streamline the process.

  • Guest
    Reply
    |
    Nov 3, 2018

    Would also like to import multiple sheets as multiple tables in one import procedure (without having to relocate the file and re-select sheets for each sheet import)

    I think since Spotfire X automatically recognizes similar columns for "add rows", if you were able to do the above then the merging process might possibly handle itself (?)