开发者

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")
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜