Dim App As New Application Dim Wb As Workbook = App.Workbooks.Open("E:\美奥口腔办公系统1\hggh.xls") Dim Ws As Worksheet = Wb.Worksheets(1)
Dim writer As New Xml.XmlTextWriter(xml, System.Text.Encoding.GetEncoding("utf-8")) '书写根元素() writer.WriteStartElement("ceshi") For i As Integer = 1 To Ws.Rows.Count - 1 '添加次级元素 writer.WriteStartElement("authors") For j As Integer = 0 To Ws.Columns.Count - 1 '添加子元素() MessageBox.Show(Ws.Cells(i, j).Value) '这一句通不过是什么原因 ' writer.WriteElementString(Ws.Cells(0, j).Value, Ws.Cells(i, j).Value) ' writer.WriteElementString(Ws.Cells(0, j).value, Ws.Cells(i, j).value) Next '关闭次级元素DatabaseSetting writer.WriteEndElement() Next
|