How to skip the last row from an excel source

Question

How to skip the last row from an excel source

bk 466

Hi All,
I am loading excel files into ADLS and then into SQLMI. The incoming excel files are from a third part reporting tool that spits the output as an excel. All these excel sheets have a "TOTAL" at the end. Is there a way to skip the last row when COPY ing the files into ADLS?
Thanks

1 answer

Your answer

Answer 1

Nandan Hegde 36,146 MVP Volunteer Moderator

Hey @bk ,

The below logic might help :

Get the overall row count of the excel sheet :
https://learn.microsoft.com/en-us/answers/questions/35029/how-to-get-row-counts-from-files-stored-in-azure-s.html

2) Then via Range parameter in excel dataset :
rownbr-1

That should help you to skip the last row and the column range would still be dynamic

Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator

2021-08-10T20:31:52.15+00:00

Hi @bk ,

Please let me know if you find above reply useful. If yes, do "Accept Answer". This will help other community members facing similar query to refer to this solution.

Thanks
Saurabh
bk 466 Reputation points

2021-09-02T14:08:44.833+00:00

@Nandan Hegde thanks and mu apologies for the late reply. I will try it today and will update you. Thanks again.
Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator

2021-09-08T17:59:29.277+00:00

Hi @bk ,

Following up to know if you are able to do it or if you need any help.

Thanks
Saurabh

Share via

How to skip the last row from an excel source

1 answer

Your answer