[Push] Pushing excel file with non existing sheets should fail

[zelima]

Currently, if you try and push excel file and define non-existing sheet it will not fail and push data from the first sheet of excel file.
Another problem is that if you select even existing sheet, it'd push the first one, which means we're not able to push a sheet other than first one.

Reproduce

Try to push excel file with 2 sheets named sheet1 and sheet2. The following command will push the data from the first sheet

• run data push myexcel.xlsx --sheets=3
• run data push myexcel.xlsx --sheets=2
• run data push myexcel.xlsx --sheets=1,2
• run data push myexcel.xlsx --sheets=all

Expected behaviour

• If sheet does not exist should terminate process and tell me about it
• If sheet exists it should push that one

Dependencies

• issue in data-cli
• issue in datahub-clinet etc

[AcckiyGerman]

TESTED:
If an empty sheet is pointed by user, the program will reply with > Error! You cannot push an empty sheet. Please, add some data and try again.
FIXED.

[zelima]

@AcckiyGerman this is not about pushing empty sheet but pushing non-existing sheet. Eg: I have excel file with 2 sheets and trying to push 4th sheet data push my.xlsx --sheets=4 - Are you sure it's fixed?

[AcckiyGerman]

@zelima yes, I tested with
--sheets=5000
--sheets=all
--sheets=1,2
--sheets=2,3
--sheets=all
etc
with an empty xlsx file and xlsx file with three sheets, where 1,3 has data, 2 is empty