This causes error during the import step with the following error message:
Error: An error occurred while importing file [File Name]: File has wrong format. End of Central Directory record could not be found.
Source: action “Import Excel spreadsheet”, table “Imported table 1”
Is there any way to exclude these temporary files from the import step at all?
You can use a RegEx expression to filter out any of the temporary files starting with “~”.
Under “Selection mode” at the top, switch to “Search”. Use the down arrow to the left of the text box below the buttons and select “Regexp” (Regular Expression). Enter the following RegEx pattern:
I’m no RegEx wizard, but that should read as: "looking from the start of the string, select strings that do not include the “~” character. More or less.
Sharing two screen clips of a file list I have that includes two temp files at the bottom - before and after applying the RegEx filter. You’ll note the bottom/temp files drop out of the list.
As there isn’t a file extension filter in play here - and it doesn’t look like you have one set in your original post - you’ll just have to be sure that all files in the folder are EasyMorph-readable (unlike my list of files that includes .docx and .pdf files).