ASP.NET - How to add vba code to excel sheet without using excel interop

Asked By balaji mogadali on 02-Jun-12 11:35 AM

hi frds

How to add vba code to excel sheet without using excel interop
please refer some good excel libarary that make functionality
pls help

santhosh replied to balaji mogadali on 02-Jun-12 02:07 PM

Hi

You have free and commercial tools for this.
OpenXML 2.0 from MS (free)
EPPlus (free)
NPOI (free)
Flexcel (commercial)

Below URLs might help.
http://www.exceltip.com/st/Writing_Your_First_VBA_Function_in_Excel/631.html
http://www.contextures.com/xlvba01.html
http://stackoverflow.com/questions/8331711/c-how-to-inject-vba-code-into-excel-xlsm-without-using-vba-project-object-mod

Jitendra Faye replied to balaji mogadali on 04-Jun-12 12:47 AM

If you don't want to use Excel InterOP the you can use OpenXml SDK.

this will allow you to integrate VBA code with Excel.

follow this link-

http://stackoverflow.com/questions/8331711/c-how-to-inject-vba-code-into-excel-xlsm-without-using-vba-project-object-mod

Hope this will help you.