16,555
社区成员
发帖
与我相关
我的任务
分享
Dim xlsSheet As Excel.Worksheet
Dim intRowStart As Integer = 3
xlsApp.DisplayAlerts = False
xlsSheet = xlsApp.Workbooks.Open(Application.StartupPath & "\Report\rptCustomerInfo.xls").Worksheets(1)
For intTemp = 0 To dgvCustomer.Rows.Count - 1
xlsSheet.Cells(intRowStart, 1) = dgvCustomer.Rows(intTemp).Cells("clnCustomer_Abbrev").Value.ToString
xlsSheet.Cells(intRowStart, 2) = dgvCustomer.Rows(intTemp).Cells("clnC_Name").Value.ToString
xlsSheet.Cells(intRowStart, 3) = dgvCustomer.Rows(intTemp).Cells("clnE_Name").Value.ToString
xlsSheet.Cells(intRowStart, 4) = dgvCustomer.Rows(intTemp).Cells("clnCity").Value.ToString
xlsSheet.Cells(intRowStart, 5) = dgvCustomer.Rows(intTemp).Cells("clnContract").Value.ToString
xlsSheet.Cells(intRowStart, 6) = dgvCustomer.Rows(intTemp).Cells("clnTel").Value.ToString
xlsSheet.Cells(intRowStart, 7) = dgvCustomer.Rows(intTemp).Cells("clnFax").Value.ToString
xlsSheet.Cells(intRowStart, 8) = dgvCustomer.Rows(intTemp).Cells("clnMail").Value.ToString
xlsSheet.Cells(intRowStart, 9) = dgvCustomer.Rows(intTemp).Cells("clnAddress").Value.ToString
xlsSheet.Cells(intRowStart, 10) = dgvCustomer.Rows(intTemp).Cells("clnDescription").Value.ToString
intRowStart += 1
Next
xlsApp.Visible = True
xlsSheet = Nothing
lblStatus.Text = "导出成功!"