专家坐堂-[求助]导入EXCEL，提示从字符串“”到类型“Double”的转换无效Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.net/bbs/index.asp)
--  专家坐堂  (http://foxtable.net/bbs/list.asp?boardid=2)
----  [求助]导入EXCEL，提示从字符串“”到类型“Double”的转换无效  (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=173796)

--  作者：冷泉
--  发布时间：2021/12/16 16:10:00
--  [求助]导入EXCEL，提示从字符串“”到类型“Double”的转换无效

老师，麻烦指导下，数量和采购价这2列在狐表里面是双精度，导入会提示错误代码   从字符串“”到类型“Double”的转换无效。要如何修正了，麻烦老师指导下，谢谢
Dim dlg As New OpenFileDialog \'定义一个新的OpenFileDialog
dlg.Filter= "EXCEL文件|*.xls" \'设置筛选器
If dlg.ShowDialog = DialogResult.Ok Then \'如果用户单击了确定按钮
Dim Book As New XLS.Book(dlg.FileName)
Dim Sheet As XLS.Sheet = Book.Sheets(0)

Tables("采购表").StopRedraw()
Dim Cols1() As String = {"编号","类别","名称","规格","单位","数量","采购价"}
Dim Cols2() As String = {"编号","类别","名称","规格","单位","数量","采购价"}
For dr1 As Integer = 1 To Sheet.Rows.Count -1
Dim dr2 As DataRow =DataTables("采购表").AddNew()
For i As Integer = 0 To Cols1.Length - 1
dr2(Cols2(i)) = sheet(dr1,i).text
Next
Next
Tables("采购表").ResumeRedraw()
End If

--  作者：狐狸爸爸
--  发布时间：2021/12/16 16:18:00
--

Dim dlg As New OpenFileDialog \'定义一个新的OpenFileDialog
dlg.Filter= "EXCEL文件|*.xls" \'设置筛选器
If dlg.ShowDialog = DialogResult.Ok Then \'如果用户单击了确定按钮
Dim Book As New XLS.Book(dlg.FileName)
Dim Sheet As XLS.Sheet = Book.Sheets(0)
Tables("采购表").StopRedraw()
Dim Cols1() As String = {"编号","类别","名称","规格","单位","数量","采购价"}
Dim Cols2() As String = {"编号","类别","名称","规格","单位","数量","采购价"}
For dr1 As Integer = 1 To Sheet.Rows.Count -1
Dim dr2 As DataRow =DataTables("采购表").AddNew()
For i As Integer = 0 To Cols1.Length - 1
Select Case Cols2(i)
Case "数量","采购价"
dr2(Cols2(i)) = val(sheet(dr1,i).text)
Case Else
dr2(Cols2(i)) = sheet(dr1,i).text
End Select
Next
Next
Tables("采购表").ResumeRedraw()
End If