10.04.2026
21:04
Hi everyone,
In my scenario, the user uploads an Excel file with multiple sheets. Each sheet has the same structure but contains different data.
I need to create an SDK plugin that processes the file and adds entries to an item list, using the sheet name as a reference.
Has anyone dealt with a similar case or can suggest the best approach/methods to handle this?
Best regards!
10.04.2026
22:07
Hi,
I've no clue how to write a SDK plugin yet. I'm interested in the answer too.
My alternative approach is to use PowerShell Universal (PSU). As you already seem to have the *.xlsx file in WEBCON through its upload this may not be a good way to use an external system instead of using an internal SDK plugin. So this doesn't answer your SDK question but maybe it's fitting other use cases for you or others too. With PSU you can just put your PowerShell scripts in there and get a REST API endpoint for each script. The endpoint can get invoked in WEBCON BPS. That's the way how I e.g. read *.csv and *.xlsx files (from other systems) and just transform them to a JSON object that I return from the endpoint.
You can have a look here if you want to get more details: https://community.webcon.com/posts/post/external-powershell-via-rest-api-endpoints-with-support-for-return-of-parameters/567/18
Kind regards
Sébastien
13.04.2026
13:55
Hi,
I think I used this dll in the past for working with Excel server side without installed Excel.
https://www.nuget.org/packages/EPPlus/4.5.3.3
I'm unsure because I've primarily used the PowerShell module "ImportExcel" when working with worksheets.
There's also later version but as of version 5 of EPPlus you need an commercial license. May still be worth it.
https://epplussoftware.com/en/LicenseOverview/
Best regards,
Daniel
