Icon

Move corrupted Excel Files from folder with row counting

There has been no title set for this workflow's metadata.

Demo workflow to find all corrupted xlsx files in a folder and move them to a "bad" folder.

Find all .xlsx filesin c:\temp folderchange this to yourrequired folderget each file path as variableattempt to openhandle errorstop branch no errorbottom branch - failurewe assume that if there is an errorin opening file, it is becausefile is corrupt!move file to "bad" folderdo nothing simply here to allow usto connect flow to the lower branchdo nothing simply here to allow usto connect flow to the lower branchopen a blank "template" copyof the spreadsheetcontaining the headings but not data.This is used in place of a corrupted filereplace this with Variable Loop Endif simply removing bad files, and don't need to consolidatethe rows from each execute to view workflow data area foldersget row andcolumn countAppend file pathget pathas stringadd 1 (to include header rowtoo)Remove this if just counting data rowsremove "number of columns"Append failure indicatorList Files/Folders Table Row ToVariable Loop Start Excel Reader Try (VariablePorts) Catch Errors(Data Ports) Java IF (Table) End IF Transfer Files NoOp (Table) NoOp (Table) Excel Reader Loop End Open File or Folder Extract TableDimension ConstantValue Column Path to String(Variable) Table Transposer Math Formula Column Filter ConstantValue Column Find all .xlsx filesin c:\temp folderchange this to yourrequired folderget each file path as variableattempt to openhandle errorstop branch no errorbottom branch - failurewe assume that if there is an errorin opening file, it is becausefile is corrupt!move file to "bad" folderdo nothing simply here to allow usto connect flow to the lower branchdo nothing simply here to allow usto connect flow to the lower branchopen a blank "template" copyof the spreadsheetcontaining the headings but not data.This is used in place of a corrupted filereplace this with Variable Loop Endif simply removing bad files, and don't need to consolidatethe rows from each execute to view workflow data area foldersget row andcolumn countAppend file pathget pathas stringadd 1 (to include header rowtoo)Remove this if just counting data rowsremove "number of columns"Append failure indicatorList Files/Folders Table Row ToVariable Loop Start Excel Reader Try (VariablePorts) Catch Errors(Data Ports) Java IF (Table) End IF Transfer Files NoOp (Table) NoOp (Table) Excel Reader Loop End Open File or Folder Extract TableDimension ConstantValue Column Path to String(Variable) Table Transposer Math Formula Column Filter ConstantValue Column

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: bbate
Created at: 2023-08-26
On NodePit since: 2023-08-29
Last update: 2024-11-21
Created with KNIME version: v5.1.0
Tags: Error Handlingcorrrupt xlsx

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!