I've encountered while integrating the GemBox.Spreadsheet library into our system. While it works perfectly fine in C# .NET within Visual Studio, I'm consistently facing the following error after integrating it into OutSystems:
"Could not load type 'GemBox.Spreadsheet.SaveOptions' from assembly 'GemBox.Spreadsheet, Version=33.3.30.1100, Culture=neutral, PublicKeyToken=b1b72c69714d4847'."
I would greatly appreciate your assistance in resolving this issue. If any of you have encountered a similar problem or have insights into the possible cause and solution, your guidance would be invaluable.
Hi Gee,
Did you check whether the DLL is included in Integration Studio? On the Resource tab, the DLL shouldn't be greyed out, but present in Resources - Source - NET - Bin. For example, this is what it looks like for my Aspose.Cells extension:
Hi Kilian,
Yeah! the DLL is included in the resource tab.
Due to large size of xif shared the link for download
https://drive.google.com/file/d/1QjxUJOoUoVKLN_W3v2BZ69iEiDiIR5Cq/view?usp=sharing
That doesn't seem to be the same extension. The one I downloaded is called GemBox, with a single action GetExcel, but the error message shows the error originates in OS_Utilities, in the action ExcelTest.
Hi kilian,
I created the same implementation of osutilities in gembox xif and also in both getting the same error
Can you show the error (like you did above for the other extension) with the stack trace, so I can see where exactly it occurs?
Attached below
I think the problem here is that SaveOptions is an abstract class:
Which means, afaik (but I'm no C# guru), that it needs to be derived before it can be used.
I think instead of the SaveOptions, you need to use XlsxSaveOptions, which is such a derived class:
So change the code into:
That should fix the error.