Use “Consolidate every tab of an Excel workbook into one table” in Recued. Reads every worksheet, including hidden ones, and appends one summary row per tab to a table you nominate.

How it works 24 steps

Inspect the data fetches, transforms, gates, and output this recipe runs.

Process (24 steps)

◆ session_raw recued-core.excel.session.create

Create session on excel

■ session_id default

Apply default

■ session_persists compare

Check if session raw result persistChanges does not equal false

■ have_persistent_session template

Generate text from a template

fail: step.session_persists equal false

◆ sheets_raw recued-core.excel.worksheet.search

Search worksheet on excel

■ sheets default

Apply default

■ have_sheets template

Generate text from a template

fail: step.sheets is_empty

■ sheet_count count

Count items in sheets

■ hidden_sheets filter

Filter by condition

■ hidden_count count

Count items in hidden sheets

◆ ranges recued-core.excel.worksheet.used_range.read

Read worksheet used range on excel

■ stats map

Extract from each item

■ usable filter

Filter by condition

■ read_count count

Count items in usable

■ every_sheet_read compare

Check if read count equals sheet count

■ total_rows sum

Sum values in

■ total_cells sum

Sum values in

■ values map

Extract from each item

■ value_row_count count

Count items in values

■ have_values template

Generate text from a template

fail: step.values is_empty

◆ append recued-core.excel.table.rows.add

Add table rows on excel

◆ close recued-core.excel.session.close

Close session on excel

■ card to_summary

Format results as a summary card

■ preview to_table

Format results as a data table

▼

Output

summary card

table preview

Settings 3 configurable

Configurable at install. Defaults shown — change them anytime in Recued.

item id setting = [object Object]

drive id setting = [object Object]

target table id setting = [object Object]