Question

Unable to combine sheets using excel utility

Forum|Forum|9 months ago
October 15, 2025
19 replies
0 views

In our use case, multiple excel files should be combined to single excel but in different sheets.

When i try to combine the sheets using excel utility plugin i am getting below error,

2025-10-15 06:25:55,136 [pool-119-thread-1] ERROR com.appiancorp.sites.alerting.SiteErrorEmailAlertServiceImpl - Error reading error logs
java.lang.RuntimeException: java.io.IOException: (line 1103) invalid char between encapsulated token and delimiter

Could you please suggest any solution or alternative.

excel utility

harshas2775

What error are you seeing in the process model? The sheets you are trying to combine are they all properly populated?

kavyashren650312Author

No error on the process model. Excels just have one row for testing.

harshas2775

Does any of your files contain inverted commas in text like "text something" . This error is caused when the excel has special character like this. So look out for them and try with excels having clean data

shubhama926776

Hope you are using Combine Excel Sheet(Excel Utility).

Looking at the error, it seems your Excel files likely contain CSV-formatted data or special characters causing the delimiter error. I recommend starting with just two simple Excel files and trying to merge them first.

kavyashren650312Author

The sample files just has one word in it

shubhama926776

Could you share both of your sample excel?

Sign up

Login with SSO

Login to the community

Login with SSO