Does ASPOSE.Cells support XLL Add-Ins?

Aspose.Cells Product Family
1

More specifically, does it support them when running on the web? My company was hoping to move all of it’s excel based processes to using ASPOSE.Cells (completely on the web). However we currently use OSISoft’s PI System via PIDataLink, an Excel 2003 Add-In (PIPC32.XLL), to make external data access calculations and sync with the PI System.

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please elaborate your problems or requirements with screenshots, it will help us understand your needs better and we will help you asap.

Please Note:

Aspose.Cells for .NET will let you create and modify the new and existing xls/xlsx and Ms-Excel formats files.

You can import and export data from your and into your databases and Ms-Excel files using Aspose.Cells for .NET.

You can use Aspose.Cells for .NET in your desktop and web application without the need of Ms-Excel or any such Add-Ins you mentioned.

Please follow these links to get more familiar with Aspose.Cells and find out if it fits your needs.


All these resources are also available in VB.NET.

3

What I’m talking about is Excel Add-Ins (specifically XLL files). Our current process uses various excel sheets all of which use the OSISoft PIDataLink Add-In. This Add-In allows, for instance, a date to be changed in one cell, and formula to in another cell to use that date to directly pull data from the PI System (an external database), but it does much more than that, that’s only a simple example.

What I would like to know is if ASPOSE.Cells supports Excel Add-Ins and to what extent. Obviously if I use ASPOSE.Cells to load up an Excel template and deliver it to a desktop where the PIDataLink Add-In was already installed everything would work just fine. But if I were to load this into a APOSE.Cells grid I’m assuming the formula would break (as the formula definition is part of the Add-In). That is pending ASPOSE.Cells does not support Excel Add-Ins in someway.

So in the simplest terms, to what extent does ASPOSE.Cells support Excel Add-Ins?

4

I see here that XLA Add-In formulas are supported, but I see no mention of XLL Add-Ins (which are basically just DLLs).

5

Hi,

Thanks for your feedback.

I have forwarded your issue to development team to guide you better.

I have logged this issue in our database. Once, we will have some fix or update relating to it, we will let you know asap.

This issue has been logged as CELLSNET-40568.

6

Hi,

We support setting, reading and reading add-in functions.

If you want to set add-in functions, please use CellsHelper.AddAddInFunction(string function, int minCountOfParameters, int maxCountOfParameters, ParameterType[] paramersType, ParameterType fuctionValueType) method to add the functions to add-in functions list, then Aspose.Cells can process an unknown functions as add-in functions, otherwise it will be a macro function.

But we do not support to calculate add-in functions, please use Workbook.CalculateFormula(bool ignoreError, ICustomFunction customFunction) method and implement calculating formulas in ICustomFunction by yourself.

7

Good Afternoon,

We are currently evaluating Aspose Cells today and have run into the same issue.

Since this last post, I was wondering if there has been any support to calculate add-in functions? We are using an XLL file which we can't create in an ICustomFunction.

A quick response would be greatly appreciated since we only have today and tomorrow to evaluate your tool.

Thanks!

John Sandala

Accenture, Inc.

8

Hi John,

Thank you for considering Aspose products, and welcome to the Aspose.Cells support forum.

I am afraid; your required feature isn’t supported yet. Upon seeing our ticket tracking system, I have also confirmed that the ticket attached to this forum thread is still unresolved. A request has been logged for the relevant developer to provide the latest updates regarding this feature. As soon as we get any news from the development end, we will post here for your reference.

9

Hi,

We could not support calculating add-ins functions because we could not know how to call the function in XLL when running the project. If you could call the function(s) in XLL when running an application, please create an ICustomFunction to call them.

Thank you.

10

Amjad,

Thanks for getting back to me.

1. I thought that calling the following defined the XLL Add-In function.

ParameterType[] ParamArr1 = new ParameterType[4] { ParameterType.Value, ParameterType.Value, ParameterType.Value, ParameterType.Value }; 

            </p><p>CellsHelper.AddAddInFunction("XLLFunctionName", 4, 4, ParamArr1, ParameterType.Value);OK.  Just to clarify.</p><p>2. Since that is not the case.  Could you please give me a simple ICustomFunction example in C# of how we might do this with XLL Add-In example above?</p><p>Any help would be greatly appreciated.</p><p>Thanks.  John Sandala</p><p>Accenture</p>
11

Hi John,

Thanks for your posting and using Aspose.Cells for .NET.

We could not support calculating add-ins function. For ICustom function, we will look into it if we could provide you some example. We have logged your requirement in our database. Once, we will have some update for you, we will let you know asap.

12

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan