Import N lines from source Excel file

[ajocius1]

My source file contains header with some relevant info followed by data table. Can I using Power Query import:

1. Top N lines from source;
2. Data starting from line N+1 (in a separate query).

Also, my source excel file is generated once per month, contains only one sheet, but the name of the sheet is always different (refers to invoice number). Can I use Sheet1 (as it is the only sheet in the file) instead of default usage of sheet name?

 

[SullyWYO]

When you use Power Query to import data, one of the first options under the HOME tab is to "Remove Rows". You can remove the top or bottom "x" rows from there.

Without seeing your data, it's hard to give much more advice than that - Power Query is very intuitive. Give it a shot and see if that works. Also, "Sheet 1" should not be an issue, but again hard to say without seeing the exact files.

 

[ajocius1]

Thanks for the answer,

I did exactly that. And one step in between, which is counting number of rows. In order to tell number of rows to remove from bottom, I needed to deduct top rows from total.

Initially I was hoping that you can only import what is necessary and therefore save time, instead of loading everything and then removing what you do not need.

 

[SullyWYO]

In order to tell number of rows to remove from bottom, I needed to deduct top rows from total.

Did you notice that there is also a "Keep Rows" option? I'm not sure you need to count the rows - just keep the first "n" rows, and everything below is deleted from the data set. From your post, it looks like you may need two separate queries - one for keeping the top few rows, and one for keeping the rest.