xlsxwriter去掉网格线_如何使用xlsxwriter为一系列单元格添加边框？(how to add border to a range of cells using xlsxwriter?)...

如何使用xlsxwriter为一系列单元格添加边框？(how to add border to a range of cells using xlsxwriter?)

我想在像image1这样的单元格范围内添加边框，但是当我应用“set_column”函数image2时，我的输出文件看起来像这样。 而不是“set_column”，是否还有其他功能可供使用？

writer=pd.ExcelWriter('merge_'+name+'.xlsx',

engine='xlsxwriter')

workbook = writer.book

data.to_excel(writer, sheet_name=SheetName,index=False,na_rep=0)

worksheet = writer.sheets[SheetName]

border_format=workbook.add_format({

'border':1,

'align':'left',

'font_size':10

})

worksheet.set_column('A:D',12,border_format)

先谢谢你，

I want to add border around a range of cells like this image1, but my output file looks like this when I applied "set_column" function image2. instead of "set_column", is there any other functions to use?

writer=pd.ExcelWriter('merge_'+name+'.xlsx',

engine='xlsxwriter')

workbook = writer.book

data.to_excel(writer, sheet_name=SheetName,index=False,na_rep=0)

worksheet = writer.sheets[SheetName]

border_format=workbook.add_format({

'border':1,

'align':'left',

'font_size':10

})

worksheet.set_column('A:D',12,border_format)

Thank you in advance,

原文：https://stackoverflow.com/questions/40905842

2019-12-03 12:48

满意答案

我不知道xlsxwriter如何使用set_column或set_row方法在范围内添加格式，但您可以尝试使用条件