The column number and row numbers are not fixed. I have attached a screenshot.
Columns can go beyond Z and same with rows.
How I do it manually:
- I copy the whole column one by one excluding the header (ex: A, B, C… till ‘n’ Columns)
- (In the screen shot i have selected only one column.)
- Then paste all the cells under the header in a webpage.
I have have created a bot for this which can perform this task but it pastes only one row item at a time. Ex: It will paste: A2 then A3 then A4 and so on. Then it loops through column and pastes B2 then B3 then B4…
Each header acts as a web link for me. I just concatenate the cell value. For example in A1 cell :
xyz.com/df/2332019 (A1 cell value)
So when the BOT loops through each column, it opens a new webpage, where the corresponding values (rows under the header) need to be pasted. So each header acts as a a weblink (for reference i have hyperlinked it).
How can I create a loop for this?