Thanks for asking for more details.
It would be appreciated if you could look at the attached project file.
The purpose of this project is data scraping of 700 web pages. Each page’s Extracted data table has 6 rows with 1 column. I turned this into a data table ( ExtractDataTable_transposed) with 1 row with 6 columns using the Transpose DataTable activity (I tried also your Transpose DataTable activity). And the goal is to get the final file (result.xlsx) with 700 rows.
Please let me know the following:
Why does ExtractDataTable_transposed.Rows.Count.ToString show ‘0’? “tempResult.xlsx” is blank.
How to add each row to excel file (result.xlsx)?
한식메뉴사전_Case2.zip (60.8 KB)