I WANT TO SPLIT SHEETS INSIDE AN EXCEL WORKFLOW BOOK TO INDIVIDUAL SHEETS

KNIME Analytics Platform
1

Hello Team,

i created the workflow to split sheets inside excel workbook. flow is working fine but when uploaded to the knime server for consumer to user the flow is throwing an error “ERROR Compress Files/Folder (Table) 3:44: Execute failed: Direct access to the local file system is not allowed on KNIME Server.”

so if some one can provide me with solution for this it will really great. the problem is not able download the splitted sheets when the workflow is ran in the knime server.

EXCEL WORKBOOK SHEET SPLITTER_v1.knwf (428.5 KB)

2

did your finger slip on the capslock button or why is the title in all caps?

did you try the search function searching for your error? there are enough threads that describe your issue and the solutions.

1 Like
3

@Jithin1893 you can allow file access on the KNIME server. Another option might be to create a temporary folder which might allow to write a file to use instantly.

https://docs.knime.com/latest/server_admin_guide/index.html#local-fs-access