List Excel Files with PowerQuery requests - (Moved)

[Profamor94]

Hi,

this utility was created to respond to a specific problem. How find excel files (*.xls*) with PowerQuery requests ?

I developed many tools with Excel powerQuery in many directories and after that i was unable to locate easily these files.

 

So I developed an utility to search all the excel files which contains PowerQuery requests.

For this purpose, I used the possibility to open excel files as a zip. Then i scan the content of this zip files to find reference to QueryTables.

To finish, i create a csv files with the list of all excel files with path, filename, powerquery request, protected, size.

 

You can find the autoit source file and an example of result.

ListFiles_v1.0.au3Fetching info... ListFiles_v1.0.csvFetching info...

[Andreik]

Probably this should be in Example Scripts forum if it's intended to be an utility but please fix you code because right now it's not runnable.

Few issues:

• 7Zip.au3 and FileListToArrayXT.au3 are not standard header files, please provide at least a link to download these files
• In line 36 you use Return keyword but not in the context of any function

[Melba23]

Moved to the appropriate forum.

Moderation Team