cancel
Showing results for 
Search instead for 
Did you mean: 

Format Excel Sheet as a Table

I have excel files that are automatically generated from multiple systems as reports. I would like to use this data in multiple daily flows.

Each file contains a single sheet with records of data. The first row contains column headers and consecutive rows contain data records. As the reports are generated by a system, the data is not formatted as a table in excel and therefore I cannot use the 'Get Rows' action in flow.

 

I would like an action to format an excel sheet into a table. It should select all rows that contain data and mark the first row as column headers (in the same way Ctrl+T in Excel), then save the table with a given name.

 

Thanks,
Sam

Status: New
Comments
Level: Powered On

I agree with @ONYXJas. Until I started working with Flow I had no idea you could even make a table in Excel! I am having many difficulties using the current connectors with Flow and Excel. Can't get table rows AND use dynamic file names. MUST use a table. Seems all these things make it impossible to use excel files as starting input to a flow process for automation without custom connectors!

 

Create an excel connector where the filename comes from a dynamic source, and you can identify the header row (if not 1 then that row is the field names and all rows prior are skipped and all rows after are data), identify the column where data is required to know when to stop processing the worksheet, allow worksheet to be identifed or if not specified use the first in the excel document.