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