【VB.net】MYSQL导出至Excel

最新推荐文章于 2022-03-01 09:32:29 发布

qq_21277361

最新推荐文章于 2022-03-01 09:32:29 发布

阅读量563

点赞数

文章标签： VB.net MySql Excel

本文链接：https://blog.csdn.net/qq_21277361/article/details/81234923

版权

本文介绍如何利用VB.net编程实现从MySQL数据库高效地导出数据到Excel文件，适合需要进行数据迁移或分析的开发者参考。

摘要由CSDN通过智能技术生成

Imports System.Data
Imports Microsoft.SqlServer.Server
Imports MySql.Data.MySqlClient
Imports System.Data.OleDb
Imports Excel = Microsoft.Office.Interop.Excel

Public Class Form1

    'MYSQL数据导出至EXCEL

    Private Sub 导出ToolStripMenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles 导出ToolStripMenuItem1.Click
        Try
            '创建连接
            '  Dim cnn As dataaccess = New dataaccess(connection_string)
            Dim cnn As String = "Server=localhost;User ID=root;Password=;Database=emp;"
            Dim i, j As Integer
            '创建Excel对象
            Dim xlApp As Microsoft.Office.Interop.Excel.Application
            Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook
            Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet
            Dim misValue As Object = System.Reflection.Missing.Value
            xlApp = New Micro