| 网站首页 | VB.Net实例分析 | .Net技术文摘 | 下载中心 | VB.Net书籍笔记 | .Net源码 | VBS脚本与组件调用 | Windows2008技术文摘 | 给我们留言 | 
最新公告:

  没有公告

您现在的位置: 乐博网 >> VB.Net实例分析 >> 其他 >> 实例分析正文
最新推荐 更多内容
VB.Net把excel导入XML文件的实例
VB.Net把excel导入XML文件的实例
作者:Ilu    来源:乐博网整理     更新时间:2009-9-23

乐博网lob.cn提示:调试环境为 vs2008 +  windows2003 / windows2008 / xp / vista

VB.Net把excel导入XML文件的代码如下:
Imports Microsoft.VisualStudio.Tools.Applications.Runtime
Imports Excel = Microsoft.Office.Interop.Excel
Imports Office = Microsoft.Office.Core
Public Class Sheet1
    Private Sub Sheet1_Startup(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Startup
        AddMenuBar()
    End Sub
    Private Sub Sheet1_Shutdown(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Shutdown
    End Sub
    Dim MyXMLMenu As Office.CommandBarButton
    Dim MyTXTMenu As Office.CommandBarButton
    Dim MyMDBMenu As Office.CommandBarButton
    Private Sub AddMenuBar()
        Try
            Dim MyCommandBarPopup As Office.CommandBarPopup = Nothing
            Dim MyCommandBarMenu As Office.CommandBar = _
                CType(Application.CommandBars.ActiveMenuBar, Office.CommandBar)
            Dim MyControlsCount As Integer = MyCommandBarMenu.Controls.Count
            Dim missing = System.Reflection.Missing.Value
            MyCommandBarPopup = CType(MyCommandBarMenu.Controls.Add( _
                Office.MsoControlType.msoControlPopup, missing, missing, _
                MyControlsCount, True), Office.CommandBarPopup)
            If (MyCommandBarPopup IsNot Nothing) Then
                MyCommandBarPopup.Caption = "演示数据导入"
                MyXMLMenu = CType(MyCommandBarPopup.Controls.Add( _
                    Office.MsoControlType.msoControlButton, missing, missing, _
                    missing, True), Office.CommandBarButton)
                MyXMLMenu.Caption = "导入XML文件"
                MyXMLMenu.TooltipText = "导入指定的XML文件的内容"
                MyXMLMenu.FaceId = 65
                AddHandler MyXMLMenu.Click, AddressOf MyXMLMenuCommand_Click
                MyTXTMenu = CType(MyCommandBarPopup.Controls.Add( _
                    Office.MsoControlType.msoControlButton, missing, missing, _
                    missing, True), Office.CommandBarButton)
                MyTXTMenu.Caption = "导入文本文件"
                MyTXTMenu.TooltipText = "导入选择的文本文件的内容"
                MyTXTMenu.FaceId = 66
                AddHandler MyTXTMenu.Click, AddressOf MyTXTMenuCommand_Click
                MyMDBMenu = CType(MyCommandBarPopup.Controls.Add( _
                    Office.MsoControlType.msoControlButton, missing, missing, _
                    missing, True), Office.CommandBarButton)
                MyMDBMenu.Caption = "导入Access数据库"
                MyMDBMenu.TooltipText = "导入Northwind(Office 2000示例)数据库客户表中的数据库记录"
                MyMDBMenu.FaceId = 67
                AddHandler MyMDBMenu.Click, AddressOf MyMDBMenuCommand_Click
            End If
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
    End Sub  '更多.net源码和实例,来自乐博网 www.lob.cn
    '导入XML文件
    Private Sub MyXMLMenuCommand_Click(ByVal Ctrl As Microsoft.Office.Core.CommandBarButton, ByRef CancelDefault As Boolean)
        Dim missing = System.Reflection.Missing.Value
        Dim MyFileName As String = Me.Application.InputBox( _
                "请输入XML文件的全路径名称:", "输入XML文件", missing, _
                missing, missing, missing, missing, missing).ToString()
        Me.Application.Workbooks.OpenXML(MyFileName, missing, _
                                Excel.XlXmlLoadOption.xlXmlLoadImportToList)
    End Sub
   End Class

  • 上一篇:

  • 下一篇:
  • 【字体: 】【打印此文】【关闭窗口
      相关文章:(只显示最新16条)
    VB.Net数据自增的3个实例
    VB.Net在Excel工作簿中使用Chart宿主控件显示图表
    VB.Net为excel取消用户密码的实例
    VB.Net为excel设置用户密码的实例
    VB.Net把excel导出XPS文件
    VB.Net把excel导出PDF文件的实例
    VB.Net把excel导入Access数据库
    VB.Net把excel导入文本文件的实例
    VB.Net显示和隐藏Excel操作窗格的实例
    VB.Net Excel合并单元格的实例
    VB.Net输出Word和Excel报表的实例

    | 设为首页 | 加入收藏 | 联系站长 | | 友情链接 | 版权申明 |
    乐博网欢迎各种媒体转载我们的原创作品[转载请注明出处];我们鼓励更多VB.Net开发者一起加入研究与探讨;如发现文章访问错误、内容错误或版权疑问、内容有违相关法律(如涉及政治、色情、反动或散布虚假有害信息)等情况,请及时向我们举报,我们将及时纠正!
    联系邮箱:Shiny#vip.qq.com (#替换为@) QQ交流群: 40797788 [闽ICP备05014267号]