Go Back
Union Multiple Excel Worksheets
Publisher
: Lingk
Run In Lingk
Description
This recipe unions the data form multiple worksheets into a single in-memory database to query. To use this recipe, upload the file into the Local File connector for your Environment.
Browse the knowledge base
Twitter
E-Mail
# This recipe unions the data form multiple worksheets into a single in-memory database to query # To use this recipe, upload the file into the Local File connector for your Environment # CONNECTORS specify what data will be pulled into the in-memory database during processing connectors: - name: sampleFile type: localFileReader format: excelFormat properties: fileName: "multiple_worksheet.xlsx" # FORMATS specify how files should be processed as they are being read or written to formats: - name: excelFormat type: excel properties: worksheets: Subaru,Ford useHeader: "true" # STATEMENTS specify how the file should be processed while in memory statements: - statement: (data) => select * from sampleFile - statement: print data - statement: (dataCount) => select count(*) from sampleFile - statement: print dataCount
JSON (S3 hosted) to Excel File Conversion
Join Multiple Excel Spreadsheets and Output Excel