Jun 11 2021 01:31 AM
Hello
I get Data from a extern Excel file with Power Query I know I can bring this information to a sheet that’s not the topic but I want to bring this information directly to an Array ! How can I do that?
If i have the information in the Array I can send cell by cell the information to the excel sheet.
I need this option because if there still an information in the cell then it should not send the information in them
Jun 11 2021 01:46 AM
Afraid that's not an option, Power Query returns data to table and/or data model only.
Jun 16 2021 07:24 AM
Jun 20 2021 09:57 AM
Hi @Klaus1615,
Can you elaborate on:
"If i have the information in the Array I can send cell by cell the information to the excel sheet.
I need this option because if there still an information in the cell then it should not send the information in them"
post some screenshots and we'll see what is possible.
cheers