国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

import xlwings as xw wb = xw.Book()#新建一個工作表sht = wb.sheets[0]#shee1sheet_name = 'NEWSHEET'sht.name = sheet_name#更改第一個sheet名字col_a = [1,2,3,4,5,6,7]sht.range('A1:A7').options(transpose=True).value = col_a#整列賦值sht.api.Columns(1).Insert()#在第一列前插入一列sht.api.Rows(1).Insert()#在第一行前插入一行sht.range('A3:A4').api.EntireRow.Delete()#刪除3,4行sht.api.Columns(2).Copy(sht.api.Columns(1))#復(fù)制第二列到第一列，可以帶格式復(fù)制sht.range('B1').api.EntireColumn.Delete()#刪除第二列B列wb.save(r'F:\PythonData\xlwings\NewData.xlsx')xw.App().quit()#退出整個excel，不寫的話打開excel會顯示被其他人使用

used_rangeUsed Range of Sheet.
Returns:  Return type:  xw.Range

last_cellReturns the bottom right cell of the specified range. Read-only.
Returns:  Return type:  Range

import xlwings as xw
wb = xw.Book(r'F:\xlwings\OriginalData.xlsx')
sht = wb.sheets[0]
info = sht.used_range
nrows = info.last_cell.rowprint(nrows)
ncolumns = info.last_cell.columnprint(ncolumns)

import xlwings as xwimport pandas as pdfrom pandas import Series,DataFrame
wb = app.books.add()sht_All = wb.sheets[0]
info = sht_All.used_rangenrows = info.last_cell.row
def GetDataFrame(Sheets,N,M):    index1 = Sheets.range((1,1),(1,15)).value    index2 = Series(index1)    Data = Sheets.range((2,1),(N,M)).value    Data = pd.DataFrame(Data,columns=index2)    return Datam = GetDataFrame(sht_All,nrows,15)

import xlwings as xw wb = xw.Book(r'F:\xlwings\OriginalData.xlsx')#orwb1 = xw.books.open(r'F:\xlwings\OriginalData01.xlsx')#打開文件
wb.save()#保存原文件wb1.save(r'F:\xlwings\PresentData01.xlsx')#另存為PresentData01.xlsx

import xlwings as xw
wb = xw.Book(r'F:\PythonData\xlwings\Style.xlsx')
sht = wb.sheets[0]
sht_color = sht.range((1,1)).colorprint(sht_color)#(255, 153, 255)sht.range((3,1)).color = (255, 153, 255)#A3背景顏色為粉色sht_BoldA = sht.range((1,1)).api.Font.Boldprint(sht_BoldA)#Truesht_BoldB = sht.range((1,2)).api.Font.Boldprint(sht_BoldB)#Falsesht.range((3,1)).value = 'A3'sht.range((3,1)).api.Font.Bold = True#加粗sht_Fontstyle = sht.range((1,2)).api.Font.FontStyleprint(sht_Fontstyle)#傾斜sht.range((3,2)).value = 'B3'sht.range((3,2)).api.Font.FontStyle = "傾斜"#設(shè)置為斜體sht_Underline = sht.range((1,3)).api.Font.Underlineprint(sht_Underline)#2,為下劃線sht.range((3,3)).value = 'C3'sht.range((3,3)).api.Font.Underline = 2#設(shè)置下劃線sht_style = sht.range((1,1),(1,5)).api.Borders.LineStyleprint(sht_style)#1#全框線sht.range((3,1),(3,3)).api.Borders.LineStyle = 1#設(shè)置全框線sht_HA_A1 = sht.range((1,1)).api.HorizontalAlignmentprint(sht_HA_A1)#水平左對齊#1sht_HA_A2 = sht.range((1,2)).api.HorizontalAlignmentprint(sht_HA_A2)#水平居中#-4108sht_HA_A5 = sht.range((1,5)).api.HorizontalAlignmentprint(sht_HA_A5)#水平右對齊#-4152sht_VA_A3 = sht.range((1,3)).api.VerticalAlignmentprint(sht_VA_A3)#垂直靠上#-4160sht_VA_A4 = sht.range((1,4)).api.VerticalAlignmentprint(sht_VA_A4)#垂直居中#-4108sht_VA_A5 = sht.range((1,5)).api.VerticalAlignmentprint(sht_VA_A5)#垂直靠下#-4107
wb.save()xw.App().quit()