使用Excel工作表绘制图表 [英] drawing charts using excel sheets

问题描述

我想在Visual Basic中使用excel表格绘制图表，为此我导入了所有必需的文件，但仍显示为找不到已安装的ISAM.
我的代码是

i want to draw charts using excel sheet in visual basic and i imported all necessary files for it but still it is showing as could not find installed ISAM.
my code is

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
       Dim myConnection As System.Data.OleDb.OleDbConnection
       Dim cmd As System.Data.OleDb.OleDbDataAdapter
       Dim ds As New System.Data.DataSet()


       myConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\SoftwareDeveloper\Downloads\Rmm values files\data04062012064100.csv;Extended properties=8.0;")
       myConnection.Open()

       cmd = New OleDbDataAdapter("select * from [Sheet1$]", myConnection)
       myConnection.Open()
       cmd.Fill(ds)
       myConnection.Close()


   End Sub

请帮我完成我的工作
请提供一些链接，以便我可以完成工作.plz

plz help me out what should i do to complete my work
plz provide me some links so that i can do my work.plz

推荐答案

"，myConnection) myConnection.Open() cmd.Fill(ds) myConnection.Close() 结束 子

", myConnection) myConnection.Open() cmd.Fill(ds) myConnection.Close() End Sub

请帮我完成我的工作
请给我一些链接，以便我做我的工作.plz

plz help me out what should i do to complete my work
plz provide me some links so that i can do my work.plz

这篇关于使用Excel工作表绘制图表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！