如何在第一次创建工作簿时使用xlswriter永久设置字体大小?
我尝试过:
book = xlsxwriter.Workbook(os.getcwd() + '\\test.xlsx')
sheet1 = book.add_worksheet()
format = book.add_format()
format.set_font_size(10)
但是输出结果仍然是默认的字体大小11,问题出在哪里?
如何在第一次创建工作簿时使用xlswriter永久设置字体大小?
我尝试过:
book = xlsxwriter.Workbook(os.getcwd() + '\\test.xlsx')
sheet1 = book.add_worksheet()
format = book.add_format()
format.set_font_size(10)
但是输出结果仍然是默认的字体大小11,问题出在哪里?
1、对于单个单元格字体大小,您需要像这样将format
传递给write
:
workbook = xlsxwriter.Workbook('demo.xlsx')
worksheet = workbook.add_worksheet()
# Add a bold format to use to highlight cells.
bold = workbook.add_format({'bold': True})
# Add a font size 10 format.
format = workbook.add_format()
format.set_font_size(10)
# Write some simple text.
worksheet.write('A1', 'Hello', format)
# Text with formatting.
worksheet.write('A2', 'World', bold)
# Write some numbers, with row/column notation.
worksheet.write(2, 0, 123)
worksheet.write(3, 0, 123.456)
workbook.close()
Hello
将被设置为字体大小10
。
更新: 2、对于所有单元格的字体大小,您可以设置工作簿的默认格式:
import xlsxwriter
workbook = xlsxwriter.Workbook('demo.xlsx')
# default cell format to size 10
workbook.formats[0].set_font_size(10)
worksheet = workbook.add_worksheet()
# Write some simple text.
worksheet.write('A1', 'Hello')
worksheet.write('A2', 'World')
# Write some numbers, with row/column notation.
worksheet.write(2, 0, 123)
worksheet.write(3, 0, 123.456)
workbook.close()