用python怎么print出一张完整的表格内容?

Python045

用python怎么print出一张完整的表格内容?,第1张

显示一张完整的表格(即包含表格线、表头以及表体内容),有多种方法,根据显示的应用场合不同,采取的方法也不同,以下试举例供参考:

1、调用表格类软件显示。如,可以直接调用 excel 软件,来打开/生成表格并显示。

2、调用 word 类字处理软件。

3、使用 html 之类的代码生成超文本格式表格,用浏览器软件显示。

4、直接用字符表格的形式显示出来。如,可以使用制表符制作并显示一个字符式的表格:

# 画日历表格

import turtle

turtle.pensize(1) # 设置画笔粗细

turtle.speed(9) # 设置画笔速度

turtle.penup()

turtle.goto(-140,140)

turtle.pendown()

for i in range(4):

turtle.fd(280)

turtle.right(90)

for i in range(6):

turtle.penup()

turtle.goto(-140,140-40*(i+1))

turtle.pendown()

turtle.fd(280)

turtle.right(90)

for i in range(6):

turtle.penup()

turtle.goto(-140+40*(i+1),100)

turtle.pendown()

turtle.fd(240)

turtle.hideturtle() # 隐藏小海龟

turtle.done() # 结束

运行结果如图所示

程序缩进如图所示

现要实现python制作html格式的表格,利用Python对字符串str.format()格式化操作进行处理,在日常对CVS格式文件处理过程当中,经常会将CVS格式文件进行转换,在正式场合是程序读取CVS文件进行转换并输出到html格式的文件当中,但现在只是实现一下转换的过程,需要输入以逗号分隔的数据。

在设计程式的时候,需要先定义一下整个代码的框架,首先我们要定义一个主函数main(),虽然Python没有规定入口函数,一般在正式的开发中都设计了一个main()函数作为程序的入口函数,或许这是一种规范吧。然后我们在定义一个打印表头的方法print_head(),并在主函数里进行调用。再定义一个打印表尾的方法print_end(),也在主函数中进行调用。定义print_line()为打印表格行,定义extract_field()处理cvs行数据转换为list集合数据。最后再定义一个处理特殊符号的方法escape_html(),因为在html代码中为了避免与它的标签冲突,特要进行特殊符号的转换,如&-->&

还有就是对长度过长的数据要进行处理并用...代替

源代码:

#Author Tandaly

#Date 2013-04-09

#File Csv2html.py

#主函数

def main():

print_head()

maxWidth = 100

count = 0

while True:

try:

line = str(input())

if count == 0:

color = "lightgreen"

elif count%2 == 0:

color = "white"

else:

color = "lightyellow"

print_line(line, color, maxWidth)

count += 1

except EOFError:

break

print_end()

#打印表格头

def print_head():

print("")

#打印表行

def print_line(line, color, maxWidth):

tr = "".format(color)

tds = ""

if line is not None and len(line) >0:

fields = axtract_fields(line)

for filed in fields:

td = "{0}".format(filed if (len(str(filed)) <= maxWidth) else

(str(filed)[:100] + "..."))

tds += td

tr += "{0}

".format(tds)

print(tr)

#打印表格尾

def print_end():

print("")

#抽取行值

def axtract_fields(line):

line = escape_html(line)

fields = []

field = ""

quote = None

for c in line:

if c in "\"":

if quote is None:

quote = c

elif quote == c:

quote = None

continue

if quote is not None:

field += c

continue

if c in ",":

fields.append(field)

field = ""

else:

field += c

if len(field) >0:

fields.append(field)

return fields

#处理特殊符号

def escape_html(text):

text = text.replace("&", "&")

text = text.replace(">", ">")

text = text.replace("<", "<")

return text

#程序入口

if __name__ == "__main__":

main()

运行结果:

>>>

"nihao","wo"

nihaowo

"lsddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddsfdddddddddddddddddddddddssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssseeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeoooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooosdjfsldkfjsladjfsladjflasjdfljslkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkksssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss","tandaly"

lsdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd...tandaly

"ddddddddddddddddsllsflsdjflsdjfljasfjslfjleiwiwooooooooooosdlsdfkckslslllllwllllllllllllllllllllllllllllllllllllllllllllllllllllllgfdjslfjsdlkkkkkkkkkkksdfssssssssssssss",

34

ddddddddddddddddsllsflsdjflsdjfljasfjslfjleiwiwooooooooooosdlsdfkckslslllllwllllllllllllllllllllllll...34