How to intergrate syncfusion for vsto excel Add-in in c#

Hi!

Is there an easy way to integrate syncfusion WinForms for vsto excel add-in in c#?
Thanks for your support!

3 Replies 1 reply marked as answer

SB Sweatha Bharathi Syncfusion Team February 20, 2024 02:24 PM UTC

Hi Trieu ,


To integrate Syncfusion WinForms Control into a VSTO Excel add-in, follow the steps below:


Here is an example for integrating the SfDatagrid in VSTO Excel add-in.

Step 1: Start Visual Studio.

Step 2: Create a VSTO Excel Add-in project.


Step 3: Include a Form in VSTO Excel Add-in project and load the SfDataGrid control. Refer the DataGrid Control related details in below link.

UG Link : https://help.syncfusion.com/windowsforms/datagrid/overview


Step 4: In the ThisAddIn class, within the ThisAddIn_Startup event , use the form.Show() method to display the Form.

Code Snippet:


private void ThisAddIn_Startup(object sender, System.EventArgs e)

 {

     Form1 form = new Form1();

     form.Show();

 }


Step 5: Run the application; you will see Excel with Syncfusion controls, as shown in the image below:

Output Image Reference:


We have provided a sample for integrating the SfDataGrid in a VSTO Excel add-in for your reference. Based on your requirement, you can modify the sample. Kindly refer to the sample and let us know if you have any further concerns on this.


Attachment: VSTOExcelAddInSample_c228ea25.zip

Marked as answer

TI Tim February 20, 2024 02:59 PM UTC

thanks for your response!



SB Sweatha Bharathi Syncfusion Team February 21, 2024 12:21 PM UTC

Hi Trieu ,



Glad that your issue is resolved!! We are closing this ticket now. Please open a new ticket if you need any assistance.


Loader.
Up arrow icon