Get Workbook Sheets Names

by Sopra Steria Ltd.

<100

This activity allows you to automate Excel files and delete the desired Excel worksheet from it

by Internal Labs

2.6k

This process makes it simple to make queue items for subsets of data in an Excel sheet.

by Feat Systems Inc.

<100

Find column header letter in an Excel file.

by Internal Labs

4.7k

Pass the DataTable and Column Name or Column Index and get the Column Letter within an Excel Worksheet.

by Ankit Pandya

9.4k

Get a list of visible only worksheets from an Excel Workbook.

by Cloudwerx Pty Ltd.

<100

Workflow to read all the sheets present in Excel files inside folders and their subfolders. As an output creates one Excel file per read sheet.

by Internal Labs

<100

Extract tables from XML files as DataTables which can be then used for further processing or writing to Excel sheets directly.

by Akshay Yadav

116

Rename an Excel Sheet

by Novigo Solutions

268

This activity takes DataTable as input and returns a dictionary containing column name and the respective cell name

by Kunal Hore

<100

Validate runtime input-file template with the agreed business input-file template. Verifies sheet names, header names and locations.

by Parthasarthi Pathinathan

248

This snippet will convert the passed inputs to Excel column name and row number

by Anas Pv

218

This activity helps to export your pivot table directly to HTML or as an image, so can be later used in email bodies or presentations.

by Sopra Steria Ltd.

<100

This activity allows you to automate Excel files and delete the desired Excel worksheet from it

by Internal Labs

2.6k

This process makes it simple to make queue items for subsets of data in an Excel sheet.

by Feat Systems Inc.

<100

Find column header letter in an Excel file.

by Internal Labs

4.7k

Pass the DataTable and Column Name or Column Index and get the Column Letter within an Excel Worksheet.