论坛 › K08：编程语言 › 如何用vb导入excel

冯亚杰 发表于 2011-12-1 21:05:38

如何用vb导入excel

请问各位大虾如何用vb导入excel

xiaoaiwhc 发表于 2011-12-9 11:48:43

没看明白，是把Excel中的数据导入VB中？如果是，代码类似这样：
    Dim objExcel As New Excel.Application
    Dim xlBookNew As Excel.Workbook
    Dim xlSheetNew As Excel.Worksheet
    Dim xlHeadRange As Excel.Range
    Dim xlContentRange As Excel.Range
    Dim xlItemRange As Excel.Range
    Dim xlVoltageRange As Excel.Range

记得要添加Excel的引用：Microsoft Excel 12.0 Object Library

HELLOPLEASE 发表于 2012-8-23 16:58:10

:)試試，THANKS TWO FRIENDS.

查看完整版本: 如何用vb导入excel