Hello everyone,
here is my case:
I am tracking leave request of employee using list on sharepoint online. I need to export to excel all items created in this list. But when i click "export to excel" and save result as query.jpy, run it, it only shows 1 item, not all off items in that list. But it shows all items when i click export to csv. Please show me how to fix it? These are pics:
all items:

export to excel query.jpy:

export to csv:

Thank you so much.