Row data not loading with getRows() function

[prasanjit101]

I have a spreadsheet with data populated as above. I am trying to load the row data. But complete data is not loaded. Only the first columns data are loaded for a row (as shown in below image).

[theoephraim]

Did you make sure to the header row to 4? (so it knows that this is where the important headers are) Also what happens if you unmerge the cells in those top rows?

[prasanjit101]

Yeah, in the SS the headerRow isn't set to 1 but with it even set to 4. The data is not loading. Unmerging the cell might work but I wanted to retain the structure. So the workaround that worked for me is using getCells instead of getRows.

[theoephraim]

without setting the header row to the row that contains the headers, it assumes you have a table of rows that only have 1 column - with the title "Marketing Activity Log". I suspect if you get that set correctly, it should work!