Forum Discussion

SunnySchindler's avatar
SunnySchindler
Icon for Helper I rankHelper I
5 years ago
Solved

How get all sheet all workbooks folder ? stops at row error "File corrupt"

Power Query M stops at row 310 which shows "DataFormat.Error: File contains corrupted data". Assuming corruption is from a Workbook, how to get all workbooks w/o fixing corruption? = Excel.Workbook...
Need Help
  • SunnySchindler's avatar
    SunnySchindler
    5 years ago

    This is what I did to solve: Move all non-Excel documents to temporary folder beyond script reach.

    I used

    robocopy t:\ s:\ /L /S /MOVE /XF *.xl*

    which should but didn't catch all png and txt files.

    robocopy t:\ d:\ /S /MOVE *.png 

    robocopy t:\ d:\ /S /MOVE *.txt

     

    Scripting should be capable to exclude non-Excel documents but beyond my current capability.

SunnySchindler's avatar
SunnySchindler
Icon for Helper I rankHelper I
5 years ago

Unsucessful delete-hidden-files-that-start-with~ as solution (pointed out by Bob on 2021-04-23 at 19:28 says hidden temporary file with xlsm extension causing query problem.) .  

How to remove files from cmd-dir but not found by cmd-del? Disk Clean-up (Temporary Files same Size afterwards) unable to remove said files. w/o Admin Right to chkdsk NOR Error-Check...