使用reportlab生成中文表格pdf代码,Python代码库,德仔网

代码语言

代码分类

【Python】使用reportlab生成中文表格pdf

作者:Eric_isbug / 发布于2013/4/16/ 1425

使用ubuntu12.10 python2.7 reportlab是ubuntu默认安装的库，可是对中文支持不好


	#coding:utf-8
	from reportlab.lib.styles import getSampleStyleSheet,ParagraphStyle
	from reportlab.platypus import *
	from reportlab.lib.units import inch
	from reportlab.lib.enums import TA_JUSTIFY

	import reportlab.rl_config
	reportlab.rl_config.warnOnMissingFontGlyphs = 0
	from reportlab.pdfbase import pdfmetrics
	from reportlab.pdfbase.ttfonts import TTFont
	from reportlab.pdfgen import canvas
	#pdfmetrics.registerFont(TTFont('song', '/usr/share/fonts/truetype/wqy/wqy-zenhei.ttc'))
	pdfmetrics.registerFont(TTFont('hei', '/usr/share/fonts/truetype/wqy/wqy-zenhei.ttc'))

	from reportlab.lib import fonts,colors
	#fonts.addMapping('song', 0, 0, 'song')
	#fonts.addMapping('song', 0, 1, 'song')
	fonts.addMapping('hei', 0, 0, 'hei')
	fonts.addMapping('hei', 0, 1, 'hei')

	stylesheet=getSampleStyleSheet()
	elements = []

	doc = SimpleDocTemplate('test.pdf')

	
	elements.append(Paragraph('<font name="hei">学 生 成 绩 单</font>',stylesheet['Title']))
	elements.append(Spacer(1,12))

	stylesheet.add(ParagraphStyle(name='Justify',alignment=TA_JUSTIFY))
	stylesheet['Justify'].fontName = 'hei'

	elements.append(flowables.Preformatted('课程名称：_____________________ 主讲教师签名：_____________________' ,stylesheet['Justify']))
	elements.append(Spacer(1,12))


	data = []
	data.append(['学号','姓名','成绩'])

	import MySQLdb

	conn = MySQLdb.connect(host="localhost",user="root",passwd="root",db="electsys",charset="utf8")
	cur = conn.cursor()
	sql = 'select s_no,s_name,s_score from student'
	cur.execute(sql)
	result = cur.fetchall()
	for l in result:
	 data.append(l)

	#ts = [('ALIGN',(0,0),(-1,-1),'CENTER'),('FONT', (0,0), (-1,-1), 'hei')]
	ts=[('INNERGRID', (0,0), (-1,-1), 0.25, colors.black),('BOX', (0,0), (-1,-1), 0.25, colors.black),('FONT', (0,0), (-1,-1), 'hei')]
	table = Table(data, 2.1*inch, 0.24*inch, ts)
	elements.append(table)

	doc.build(elements)

试试其它关键字

　生成中文表格pdf　

同语言下

可能有用的

Eric_isbug贡献的其它代码(1)

.使用reportlab生成中文表格pdf