Dim App As New MSExcel.Application
try
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(ProjectPath & "reports\工单.xls")
Dim tempWs = wb.WorkSheets.Add
'' For k As Integer = 1 To Wb.WorkSheets.Count - 1
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
Dim rg As MSExcel.Range
For Each rg In ws.UsedRange
If rg.MergeCells Then
Dim tempCell As MSExcel.Range
Dim width As Double = 0
Dim tempCol
For Each tempcol In rg.MergeArea.Columns
width = width + tempcol.ColumnWidth
Next
tempWs.Columns(1).WrapText = True
tempWs.Columns(1).ColumnWidth = width
tempWs.Columns(1).Font.Size = rg.Font.Size
tempWs.Cells(1, 1).Value = rg.Value
tempWs.Cells(1, 1).RowHeight = 0
tempWs.Cells(1, 1).EntireRow.Activate
tempWs.Cells(1, 1).EntireRow.AutoFit
If (rg.RowHeight < tempWs.Cells(1, 1).RowHeight) Then
Dim tempHeight As Double
Dim tempCount As Integer
tempHeight = tempWs.Cells(1, 1).RowHeight
tempCount = rg.MergeArea.Rows.Count
For Each addHeightRow As object In rg.MergeArea.Rows
If (addHeightRow.RowHeight < tempHeight / tempCount) Then
addHeightRow.RowHeight = tempHeight / tempCount
End If
tempHeight = tempHeight - addHeightRow.RowHeight
tempCount = tempCount - 1
Next
rg.WrapText = True
End If
End If
Next
'' Next
app.DisplayAlerts = False
tempWs.Delete
Wb.Save
'Dim txt1 As WinForm.TextBox = Forms("翻译器").Controls("TextBox3")
'txt1.text = file & vbcrlf & txt1.text & vbcrlf
Application.DoEvents()
'' FileCount=FileCount+1
catch ex As exception
msgbox(ex.message)
finally
App.Quit()
加好友 
发短信
Post By：2017/8/17 11:16:00 [显示全部帖子]
此主题相关图片如下：1.png
