How do I get row range in Excel format as Input

[yosukewatanabe]

Hi,

I want to get the specific range of row in Excel file.

For example, the following Excel file, I want get the data of 2nd and 3rd row.

best regards,

[patrick_digan]

@yosukewatanabe For an xlsx file, you can use the SQL editor to write something like:

SELECT * FROM `Sheet1$A2:I3`

Here is a picture.

Alternatively, you could also bring in the entire file like normal and then use the select records tool to grab those 2 rows. You could use the dynamic rename if you needed to rename the columns.

[yosukewatanabe]

Hi @patrick_digan

Thank you for your reply.

Certainly, this method is used when the number of columns is identical.

However,what if the number of columns is not identical?

for example, one excel worksheet has 8 colums(A-H), the other one has 10 colums(A-J).

Best regards,

[patrick_digan · Accepted solution]

@yosukewatanabe how about 

SELECT * FROM `Sheet1$2:3`

That seemed to work.

[yosukewatanabe]

Thank you for your answer.

I had get the data in row range!