锐客网

  1. 首页 > 生活百科 > it技术 > >

vb.net数据导出 vb怎么导出

IT技术excel

vb.net datagridview显示的数据导出到其他数据库一行一行vb.net数据导出的insert into到另一个数据库就行vb.net数据导出了 。一般不使用批量写入vb.net数据导出，字符串太长
VB.NET怎么将DataGridview里的内容导出到EXCEL去不好意思 现在才看到；Private Sub 导出EXCEL_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim xlApp, xlBook, xlSheet As Object
xlapp = CreateObject("Excel.Application")
xlbook = xlapp.Workbooks.Add
xlsheet = xlbook.Worksheets(1)
'Dim xlapp As New Excel.Application
'Dim xlbook As Excel.Workbook
'Dim xlsheet As Excel.Worksheet
Dim rowindex, colindex As Integerrowindex = 1 '行
colindex = 0'列
'xlbook = xlapp.Workbooks.Open("c:\EXCEL.xls") '打开EXCEL文件
xlsheet = xlapp.Worksheets("sheet1")'打开sheet1那页Dim a As New DataSet
Dim table As New System.Data.DataTabletable = DataSet11.Tables("INVMATLISTA") '填充表Dim row As DataRow'定义row为表格的行
Dim col As DataColumn'定义col为表格的列'把表格的每一列写到EXCEL去
For Each col In table.Columns
colindex = colindex1
xlapp.Cells(1, colindex) = col.ColumnNameNext
'把表格的每一行写到EXCEL去
For Each row In table.Rows
rowindex = rowindex1
colindex = 0
For Each col In table.Columns
colindex = colindex1
xlapp.Cells(rowindex, colindex) = row(col.ColumnName)
Next
Next
xlapp.Visible = True
End Sub 前提要先引用一个Microsoft.Office.Interop.Excel.dll然后在最上面先输入Imports Microsoft.Office.Interop； 就可以了
vb中如何将数据导出到excel介绍
下面通过一步一步的介绍 ， 如何通过VB.NET来读取数据，并且将数据导入到Excel中 。
第一步：
打开VS开发工具 ， 并且添加引用 。
然后选择 。
Microsoft Excel 12.0 object library and 。
Microsoft Excel 14.0 object library 。
第二步：
创建一个Excle在你的电脑中 。
第三步：
在VS中写入如下代码：
Imports System.Data
Imports System.Data.SqlClient
Imports Excel = Microsoft.Office.Interop.Excel 。
Public Class excel
‘添加按钮
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles Button1.Click
Try
'创建连接
Dim cnn As DataAccess = New DataAccess(CONNECTION_STRING)
【vb.net数据导出 vb怎么导出】
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 Microsoft.Office.Interop.Excel.ApplicationClass
xlWorkBook = xlApp.Workbooks.Add(misValue)
' 打开某一个表单
xlWorkSheet = xlWorkBook.Sheets("sheet1")
' sql查询
'xlWorkBook.Sheets.Select("A1:A2")
Dim sql As String = "SELECT * FROM EMP"
' SqlAdapter
Dim dscmd As New SqlDataAdapter(sql, cnn.ConnectionString)
' 定义数据集
Dim ds As New DataSet
dscmd.Fill(ds)
‘添加字段信息到Excel表的第一行
xlWorkSheet.Cells(1, 1).Value = "https://www.04ip.com/post/First Name"
xlWorkSheet.Cells(1, 2).Value = "https://www.04ip.com/post/Last Name"
xlWorkSheet.Cells(1, 3).Value = "https://www.04ip.com/post/Full Name"
xlWorkSheet.Cells(1, 4).Value = "https://www.04ip.com/post/Salary"
' 将数据导入到excel
For i = 0 To ds.Tables(0).Rows.Count - 1
'Column
For j = 0 To ds.Tables(0).Columns.Count - 1
' this i change to header line cells
xlWorkSheet.Cells(i3, j1) = _
ds.Tables(0).Rows(i).Item(j)
Next
Next
'HardCode in Excel sheet
' this i change to footer line cells
xlWorkSheet.Cells(i3, 7) = "Total"
xlWorkSheet.Cells.Item(i3, 8) = "=SUM(H2:H18)"
' 保存到Excel
xlWorkSheet.SaveAs("D:\vbexcel.xlsx")
xlWorkBook.Close()
xlApp.Quit()
releaseObject(xlApp)
releaseObject(xlWorkBook)
releaseObject(xlWorkSheet)
'弹出对话框显示保存后的路径
MsgBox("You can find the file D:\vbexcel.xlsx")
Catch ex As Exception
End Try
End Sub
' Function of Realease Object in Excel Sheet
Private Sub releaseObject(ByVal obj As Object)
Try
System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
obj = Nothing
Catch ex As Exception
obj = Nothing
Finally
GC.Collect()
End Try
End Sub
End Class
复制代码 。
第四步：
看到如下导出结果 。
vb.net数据导出的介绍就聊到这里吧，感谢你花时间阅读本站内容 ， 更多关于vb怎么导出、vb.net数据导出的信息别忘了在本站进行查找喔 。

    推荐阅读


    上一篇：网络路由器怎么加密码锁，路由器密码怎样加密

    下一篇：oracle测试数据库，oracle 测试