def get_data_in_excel(path_image): # 生成CSS文件
CSS_Text = "@charset \"UTF-8\";\n/* CSS Document */\n"
get_data(path_image)
print("result.xls生成")
path_excel = "../excel/result.xls"
line_count = 2 # 行数
result_rows = excel.get_excel_rows(path_excel) # 获取result.xls最大行数
while line_count <= result_rows:
CSS_Text += '.'
CSS_Text += excel.read_excel_xls(path_excel, line_count - 1, 0) + '{\n'
CSS_Text += excel.read_excel_xls(path_excel, line_count - 1, 1)
CSS_Text += excel.read_excel_xls(path_excel, line_count - 1, 2)
CSS_Text += excel.read_excel_xls(path_excel, line_count - 1, 3)
CSS_Text += excel.read_excel_xls(path_excel, line_count - 1,
4) + "\n}\n"
line_count += 1
return CSS_Text
def create_html():
path_excel = "../excel/result.xls"
line_count = 2 # 行数
result_rows = excel.get_excel_rows(path_excel) # 获取result.xls最大行数
source_code = HTML.HTML.meta + HTML.HTML.next_line # 声明
source_code += HTML.HTML.html + HTML.HTML.next_line + HTML.HTML.find_your_another_one(
HTML.HTML.html)
title = HTML.HTML.next_line + HTML.HTML.title + HTML.HTML.next_line + \
excel.read_excel_xls(path_excel, 1, 5) + HTML.HTML.next_line +\
HTML.HTML.find_your_another_one(HTML.HTML.title) +\
HTML.HTML.next_line # 写入title
head = HTML.HTML.next_line + HTML.HTML.head + \
HTML.HTML.next_line + HTML.HTML.find_your_another_one(HTML.HTML.head) # 生成head
css_state = HTML.HTML.split_detail(
"<link", HTML.HTML.link, "rel=\"stylesheet\" "
"type=\"text/css\" href=\"../css/test.css\"") # 生成CSS声明
head = HTML.HTML.split_detail(HTML.HTML.head, head, title + css_state)
body = HTML.HTML.body + HTML.HTML.find_your_another_one(HTML.HTML.body)
div_block = ""
while line_count <= result_rows:
class_name = excel.read_excel_xls(path_excel, line_count - 1, 0)
text = excel.read_excel_xls(path_excel, line_count - 1, 5)
temp = HTML.HTML.split_detail(
"<div", HTML.HTML.div,
HTML.HTML.class_name + "=\"" + class_name + "\"")
div_block += (temp + HTML.HTML.next_line + text + HTML.HTML.next_line +
HTML.HTML.find_your_another_one(HTML.HTML.div) +
HTML.HTML.next_line)
line_count += 1
body = HTML.HTML.next_line + HTML.HTML.split_detail(
HTML.HTML.body, body, div_block)
head_body = head + body
source_code = HTML.HTML.split_detail(HTML.HTML.html, source_code,
head_body)
return source_code
# create_html()
def level(i):
return excel.read_excel_xls(path + book_name_xls, i - 1, 0)
def text(i):
return excel.read_excel_xls(path + book_name_xls, i - 1, 11)
def conf(i):
return excel.read_excel_xls(path + book_name_xls, i - 1, 10)
def height(i):
return excel.read_excel_xls(path + book_name_xls, i - 1, 9)
def width(i):
return excel.read_excel_xls(path + book_name_xls, i - 1, 8)
def top(i):
return excel.read_excel_xls(path + book_name_xls, i - 1, 7)
def left(i):
return excel.read_excel_xls(path + book_name_xls, i - 1, 6)
def word_num(i):
return excel.read_excel_xls(path + book_name_xls, i - 1, 5)
def line_num(i):
return excel.read_excel_xls(path + book_name_xls, i - 1, 4)
def par_num(i):
return excel.read_excel_xls(path + book_name_xls, i - 1, 3)
def block_num(i):
return excel.read_excel_xls(path + book_name_xls, i - 1, 2)
