Problem with "Add a row into a table" for a transposed HTML table

(0) Share

Report

Posted on by ashraf999

Hello all,

I have created a transposed HTML table that looks like the following:

My problem is populating the excel table in worksheet , "testing.xlsx", that I created with this data. The dates may change depending on the source data so the number of the date columns, 2024-07, 2024-08, etc. is not fixed. They change over time

I tried to use "Add Rows into a table" but I am stuck here. Only one row of the "Portfolio" names is populated without "Count". The table should look exactly like the first image posted earlier

Categories:

Business Process Flows

All responses (4)

Answers (0)

ashraf999 21 on at

Like (0)

Report

Problem with "Add a row into a table" for a transposed HTML table

Is there a simpler way to do it by Office Scripts ?
lbendlin 7,828 on at

Like (0)

Report

Problem with "Add a row into a table" for a transposed HTML table

You do that via Graph API calls.
ashraf999 21 on at

Like (0)

Report

Problem with "Add a row into a table" for a transposed HTML table

Which code or tool can I use to delete and recreate the table headers every time?
lbendlin 7,828 on at

Like (0)

Report

Problem with "Add a row into a table" for a transposed HTML table

Use the untransposed data to write to Excel. Otherwise you would have to include code to delete and recreate the table headers every time.