how to call sharepoint end point to load excel from a row A6: as header?

Question

I can load multiple excel files on SharePoint Online with token in a foreach(first row as header and all following rows are data). But the last step is: read rows from A6 as header and following rows as data.

The sheet example can be like below:

I leaned that Workflow can do filter tasks but it can't call sharepoint with exactly same configurations I did on copy activity.

Answer 1

Hi @Simon Zhang
You can follow this document to retrieve specific cells in excel file.
https://learn.microsoft.com/en-us/azure/data-factory/format-excel#dataset-properties
You can set specific cell in Range

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---

Answer 2

Hi @Simon Zhang ,

Thank you for sharing details.

Error Invalid excel header with empty value will come when your headers values are empty in your excel. To avoid this error we can consider using dataflows and implement small trick which explained in below thread. Kindly check it and try the same.

https://learn.microsoft.com/en-us/answers/questions/761277/invalid-excel-header-with-empty-value-when-last-ce.html

Hope this helps. Please let me know if any further queries.

--------------------

Please consider hitting Accept Answer button. Accepted answers help community as well.