Spreadsheet component with VBA support
I am looking for a .Net spreadsheet component that could also execute the VBA contained in Excel files.
I found Spreadsheet Gears to be very nice for manipulating and allowing the user to edit Excel files, but on spreadsheets that use VBA for calculations, well, these don't work.
So, apart from Excel itself, are there any other c开发者_如何学运维omponents that can execute VBA?
You can directly execute office macros from .NET
Eg: vb.net
objExcel = New Excel.Application
objExcel.Workbooks.Open(FileName:="c:\test.xls", ReadOnly:=True)
objExcel.Run("test.xls!test.test")
精彩评论