import
os
import
time
from
xlwt
import
*
from
Mymodule
import
cur_file_dir
filename
=
'TestData2.xls'
if
os.path.exists(filename):
os.remove(filename)
print
time.strftime(
"%Y-%m-%d"
,time.localtime(time.time()))
wbk
=
Workbook(encoding
=
'utf-8'
)
sheet
=
wbk.add_sheet(
'new sheet 1'
, cell_overwrite_ok
=
True
)
style
=
XFStyle()
for
i
in
range
(
0x00
,
0xff
):
pattern
=
Pattern()
pattern.pattern
=
Pattern.SOLID_PATTERN
pattern.pattern_fore_colour
=
i
style.pattern
=
pattern
Line_data
=
(u
'测试表'
)
sheet.write_merge(i, i,
0
,
2
, Line_data, style)
for
i
in
range
(
0x00
,
0xff
):
fnt
=
Font()
fnt.name
=
u
'微软雅黑'
fnt.colour_index
=
i
fnt.bold
=
True
style.font
=
fnt
sheet.write_merge(i,i,
3
,
5
,Line_data,style)
for
i
in
range
(
0
,
0x53
):
borders
=
Borders()
borders.left
=
i
borders.right
=
i
borders.top
=
i
borders.bottom
=
i
style.borders
=
borders
sheet.write_merge(i,i,
6
,
8
,Line_data,style)
for
i
in
range
(
6
,
80
):
sheet.write(
0
,i,Line_data,style)
sheet.col(i).width
=
0x0d00
+
i
*
50
path_py
=
"\\images\python.bmp"
path_exe
=
"\\images\python.bmp"
path
=
cur_file_dir(path_py,path_exe)
filename
=
path
if
os.path.exists(filename):
print
u
'python.bmp图片存在'
else
:
print
u
'python.bmp图片不存在'
sheet.insert_bitmap(path,
2
,
9
)
wbk.save(
'TestData2.xls'
)
raw_input
(
"Enter enter key to exit..."
)