python设置excel边框_python win32com excel边框格式

嗯，你在用什么excel？在

这应该是有效的：for shn in [("Beam-Beam", bb_row, bb_col), ("Beam-Col", bc_row, bc_col)]:

sheet = book.Worksheets(shn[0])

sheet.Range( "J3:DW3" ).Copy()

if shn[0] == "Beam-Col":

sheet.Range( "J3:AA3" ).Copy()

## Set a variable named rng to the range

rng = sheet.Range( sheet.Cells( 4, 10 ), sheet.Cells( shn[1]-1, 10 ) )

rng.PasteSpecial()

## Using this range, we can now set its borders linestyle and weight

## -> where 7 through 13 correspond to borders for xlEdgeTop,xlEdgeBottom,

## xlEdgeRight, xlEdgeLeft, xlInsideHorizontal, and xlInsideVertical

## -> LineStyle of 1 = xlContinous

## -> Weight of 2 = xlThin

for border_id in xrange(7,13):

rng.Borders(border_id).LineStyle=1

rng.Borders(border_id).Weight=2

## And to finish just call

book.Close(True) # To close book and save

excel_app.Quit() # or some variable name established for the com instance

告诉我这对你有什么用。在

如果将excel应用程序设置为“可见”或关闭屏幕更新，则速度可能更快：

^{pr2}$

这样，excel就不会为每次呼叫更新屏幕。在