Dim Book As New XLS.Book(ProjectPath & "集团汇总.xls")
Dim Sheet1 As XLS.Sheet = Book.Sheets("资产负债表")
Dim tt As Table = Tables("单位")
Dim drs As List(Of DataRow)
For i As Integer = 0 To tt.Rows.Count - 1
DataTables("资产负债表").DataRows.Clear
Dim xj As String = tt.Rows(i)("单位")
drs = DataTables("资产负债表汇总").Select("[单位] = '" & xj & "'")
For Each drr As DataRow In drs
Dim dr As DataRow = DataTables("资产负债表").addnew
dr("项目")=drr("项目")
dr("年初数")=drr("年初数")
dr("行次")=drr("行次")
dr("年未数")=drr("年未数")
dr("单位")=drr("单位")
Next
Dim dt As Table = Tables("资产负债表")
For r As Integer = 0 To dt.Rows.Count - 1 '填入数据
If Sheet1(5+i, r+2).Formula = "" Then
Sheet1(5+i,r+2).Value = dt.rows(r)("年未数")
Dim s1 As String = dt.Rows(r)("单位")
Dim nn As Integer
nn=s1.Length
If nn=9 Then
Sheet1(5+i,1).Value= s1.Substring(3,2)
ElseIf nn=11 Then
Sheet1(5+i,1).Value= s1.Substring(7,2)
Else
Sheet1(5+i,1).Value= s1.Substring(9,2)
End If
End If
Next
Next
Book.Save( "d:\集团汇总.xls" )
Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.open( "d:\集团汇总.xls" )
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets("资产负债表")
ws.UsedRange.Formula = ws.UsedRange.Formula
wb.save
wb.close
App.Quit
Dim Proc As New Process
Proc.File = ( "d:\集团汇总.xls" )
Proc.Start()
如何做到不用打开( "d:\集团汇总.xls" )，只是提示 MessageBox.show("导出成功！")
加好友 
发短信
Post By：2014/7/2 11:06:00 [显示全部帖子]
