1

HI All,

I want to export the excel file using c# and in excel it should have a ribbon (button in excel) called as refresh which will get the latest data from server.

Please let me know how to go forward..

Improve this question

1 Answer 1

Reset to default
2

You should have a look at VSTO. Visual Studio Tools for Office allows you to customize Office applications, using .Net. For Excel, you can customize specific documents or write add-ins, working from Visual Studio, in VB.Net or C#.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Thanks for the reply, After creating a ribbon using VSTO, is it possible to create the event in the excel which will refresh the data.
It should not be a problem. Your code in VSTO is .Net, so you should have no problem calling your server, and you have complete access to Excel via Interop. The VSTO dev center has a bunch of tutorial videos here: msdn.microsoft.com/en-us/vsto/dd164303.aspx The 2 following demonstrate how to interact with a database, and how to write to a worksheet: msdn.microsoft.com/en-us/vsto/cc337994.aspx msdn.microsoft.com/en-us/vsto/cc337989.aspx

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.