We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Visual Studio Tools for Office and Syncfusion??

Thread ID:

Created:

Updated:

Platform:

Replies:

100271 Jul 21,2011 05:35 AM Jul 28,2011 10:29 AM ASP.NET Web Forms (Classic) 6
loading
Tags: XlsIO
nakata
Asked On July 21, 2011 05:35 AM

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 [Syncfusion]
Replied On July 22, 2011 03:37 AM

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
Replied On July 22, 2011 10:28 AM

Thanks for replying so fast, Il'll try .


nakata
Replied On July 22, 2011 10:55 AM

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 [Syncfusion]
Replied On July 27, 2011 12:14 AM

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
Replied On July 27, 2011 10:57 AM

Thanks Jawahar for replying.


Jawahar Jeevanandan J [Syncfusion]
Replied On July 28, 2011 10:29 AM

Hi Nakata,

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

Thanks,
Jawahar.


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;