Visual Studio Tools for Office and Syncfusion??

[nakata]

Is it possible to use Syncfusion with Visual Studio Tools for Office?

For example, I want to create an Excel Add In thanks to VSTO and I want to use Syncfusion XlsIO classes and methods to populate a worksheet and to access cells.

Thanks for answering.

[Jawahar Jeevanandan J]

Hi Nakata,

Thank you very much for using syncfusion products.

Yes it is possible to create add-ins using Syncfusion XlsIO. The following code snippet explains you how to create the add-ins using our XlsIO.

Code Snippet (c#):

IAddInFunctions functions = workbook.AddInFunctions;
functions.Add(@"C:\Documents and Settings\ Administrator\Application Data\Microsoft\AddIns\Discounts.xla", "discount"); sheet.Range["A3"].Formula = "discount(A1,A2)";

I have also attached the sample tested at our side along with this update. Please try this at your side and let us know whether this helps you.

Please let us know if you have any clarifications.

Thanks,
Jawahar.



Sample_c1bc63b9.zip

[nakata]

Thanks for replying so fast, Il'll try .

[nakata]

Sorry but I think that you didn't understand my requirement. In fact, I have used VSTO to create an Add in with a Ribbon, Winform etc.. But I want to use Syncfusion classes to access cells cause it's easier to manipulate cells and formula.

So the real question is :

"From a ribbon, buttons created with VSTO, can I use Syncfusion method to access cells"

[Jawahar Jeevanandan J]

Hi Nakata,

Thank you very much for your patience.

Vsto is specially created for interop library. From the button created using vsto it is not possible to access the cells with syncfusion classes and methods.

Please let us know if you have an clarifications.

Thanks,
Jawahar.

[nakata]

Thanks Jawahar for replying.

[Jawahar Jeevanandan J]

Hi Nakata,

Thank you very much for your update. Hope the response provided in the previous update was very useful.

Thanks,
Jawahar.