python方法记录
文件路径相关
import os
if ( os. path. exists( file_path) ) :
dosomething
currentFolder = os. path. split( os. path. realpath( __file__) ) [ 0 ]
逻辑处理
for index, value in enumerate ( [ a, b, c] ) :
print ( index, value)
for col in range ( len ( testArray) :
print ( testArray[ col] )
test = ( 'a' if ( test== '1' ) else 'b' )
sheetTarget. keys( )
python 读写excel
xlwt 库写入(仅支持xls格式, 不支持xlsx)
import xlwt
newExcelBook = xlwt. Workbook( )
newSheet = newExcelBook. add_sheet( sheetName)
sheet. write( row, col, 'text' )
row2= sheet. row( 1 )
row2. write( 0 , 'data' )
newExcelBook. save( './excelHandle/qw.xls' )
pandas写入excel
import pandas
pdSheetList = pandas. read_excel( sourceFile, sheet_name= None )
pdSheet = pandas. read_excel( sourceFile, sheetName)
colNames = pdSheet. columns. tolist( )
pdSheet. insert( colIndex, colName, colData, allow_duplicates= True )
df[ 'trans' ] = translated_array
pdWriter = pandas. ExcelWriter( fileName)
pdSheet. to_excel( pdWriter, sheet_name= sheetName, index= False )
pdWriter. save( )
xlrd库读取excel
import xlrd
excelBook = xlrd. open_workbook( sourceFile, encoding_override= "utf-8" )
excelBook. sheet_names( )
excelBook. sheet_by_name( sheetName)
sheetData = excelBook. sheets( ) [ sheetIndex]
sheetData. col( colIndex)
for col in range ( sheetData. ncols) :
colData = sheetData. col_values( col)
for row in range ( len ( colData) ) :
print ( 'value' , row, col , colData[ row] )
openpyxl读写
import openpyxl
work_book = openpyxl. load_workbook( file_path)
names = book. sheetnames
sheet = book. worksheets[ 0 ]
sheet = book[ '工作表名称' ]
title = sheet1. title
rows = sheet1. max_row
cols = sheet1. max_column
cell = sheet. cell( 1 , 2 ) . value
cell = sheet[ 'A1' ] . value
book = openpyxl. Workbook( encoding = 'utf-8' )
sheet = book. create_sheet( '工作表名称' , 0 )
sheet. cell( m, n, '内容1' )
book. save( 'excel文件名称' )