导入代码,加入删除原有数据功能。
Dim str1 As WinForm.TextBox = e.Form.Controls("TextBox1")
Dim str2 As WinForm.ComboBox = e.Form.Controls("ComboBox1")
Dim check1 As WinForm.CheckBox = e.Form.Controls("CheckBox1")
If check1.Checked = True
DataTables("成绩表").DeleteFor("")
End If
Dim Book As New XLS.Book(str1.text)
Dim Sheet As XLS.Sheet = Book.Sheets(str2.text)
Tables("成绩表").StopRedraw()
Dim nms() As String = {"班级","学号","姓名","语文","数学","英语","物理","化学"}
'注意下面的循环变量从1开始,而不是从0开始,因为Excel表的第一行是标题
For n As Integer = 1 To Sheet.Rows.Count -1
Dim r As Row = Tables("成绩表").AddNew()
For m As Integer = 0 To nms.Length - 1
r(nms(m)) = Sheet(n,m).Value
Next
Next
Tables("成绩表").ResumeRedraw()
DataTables("成绩表").save
DataTables("成绩表").Load
MessageBox.Show("导入完成")
[此贴子已经被作者于2013-7-24 13:50:39编辑过]