Skip to main content

I have a table that I need to export to an Excel file. To this file I want to apply some styling. I’ve written a Python script that works well: it uses a FeatureWriter followed by a PythonCaller, and the result is an Excel file with the desired formatting, including filters, colors, and so on.

Now I’d like to split this Excel output using a fanout expression, which generates 23 separate Excel files. Each of these files should then be processed by the PythonCaller. However, that’s where things go wrong — the process seems to get stuck. I’m using the _dataset variable from the Summary output port of the FeatureWriter as the location for the Excel files, which the PythonCaller should loop through.

Is there something I might have overlooked?

Hey Elbert, 

that’s where things go wrong — the process seems to get stuck.

Could you elaborate? Do you have any logs to share?

Keep in mind that Excel files are locked while they are open by another process. Maybe your Python script is trying to access a locked file?