SharePoint REST Connector

PetteysJ · 2022-03-22T20:02:05+00:00

There was an error rendering this rich post.

Hoping someone has run into this when connecting an Excel sheet from a SharePoint.

My header row (row 10 as it happens) has a blank in cell A of that row. Instead of pulling it in as Column_1 as I would expect, it removes that cell and shifts all other headers over. Not only do the headers end up shifted, but it fails to pull the last column of the sheet I need.

Is there a way around this?

Find more posts tagged with

Connectors

Excel

Accepted answers

All comments

MarkSnodgrass

If you are able to edit the Excel document and put some dummy data in that cell, that seems like the easiest solution.

Another option would be to start at an earlier row and then filter out the header rows in the ETL by looking for certain information and then create your own column names with the select columns tile in the ETL.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of