Dim b As New XLS.Book
Dim t As Table = Tables("收入统计图表窗体_tjTable")
Dim s As XLS.Sheet = b.Sheets(0)
Dim Chart As WinForm.Chart = Forms("收入统计图表窗体").Controls("Chart1")
For c As Integer = 0 To t.Cols.Count -1 '添加列标题
s(0, c).Value = t.Cols(c).Name
Next
For r As Integer = 0 To t.Rows.Count - 1 '填入数据
For c As Integer = 0 To t.Cols.Count -1
s(r +1, c).Value = t.rows(r)(c)
Next
Next
'插入图表
's(t.rows.Count + 2,1).Value = New XLS.Picture(Chart.Image,0,0,422,258)
'b.Save("c:\reports\test.xls")
'Dim Proc As New Process
'Proc.File = "c:\reports\test.xls"
'Proc.Start()
Dim dlg As New SaveFileDialog '定义一个新的SaveFileDialog
dlg.Filter= "文本文件|*.xls" '设置筛选器
dlg.FileName="收入总汇"
If dlg.ShowDialog = DialogResult.Ok Then '如果用户单击了确定按钮
s(t.rows.Count + 2,1).Value = New XLS.Picture(Chart.Image,0,0,422,258)
t.SaveExcel(dlg.FileName, "收入总汇")
End If