本文整理汇总了Python中xlwt.XFStyle类的典型用法代码示例。如果您正苦于以下问题:Python XFStyle类的具体用法?Python XFStyle怎么用?Python XFStyle使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了XFStyle类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的Python代码示例。
示例1: writeErrorRec
def writeErrorRec(record):
"""
Exception report spreadsheet output format same as input format and
assumes first column is of type Date - adds an extra, last column
for error message.
"""
dateFmt = XFStyle()
dateFmt.num_format_str='MM-DD-YYYY'
defaultFmt = XFStyle()
global erroutRow
for colnum in range(0, len(headers)):
erroutSheet.write(erroutRow, colnum, record[headers[colnum][0]],
tern(headers[colnum][0]==xlrd.XL_CELL_DATE, dateFmt, defaultFmt))
# add extra column for error message
erroutSheet.row(erroutRow).write(len(headers), record['Error'])
erroutRow += 1
# flush every 200 rows...
#if ((erroutRow % 200) + 1 == 200):
# since, xlwt uses aggressive caching, we must
# write each row manually, or the data may be lost upon exception
erroutSheet.flush_row_data()
errorsWorkbook.save('errors.xls')
开发者ID:jacob-carrier,项目名称:code,代码行数:26,代码来源:recipe-577550.py
示例2: exportToExcel
def exportToExcel(self,objectProject):
book = Workbook();
sheet1 = book.add_sheet('Sheet 1')
if( objectProject):
i=0;
row1 = sheet1.row(i) ;
row1.write(0, ('ประเภท').decode('UTF8') );
row1.write(1, ('ชื่อโครงการ').decode('UTF8'));
row1.write(2, ('รายละเอืยด').decode('UTF8') );
row1.write(3, ('งบประมาณรวม').decode('UTF8') );
row1.write(4, ('งบประมาณ').decode('UTF8') );
row1.write(5, ('เงินบำรุง').decode('UTF8') );
row1.write(6, ('งบประมาณอื่น').decode('UTF8') );
row1.write(7, ('งบประมาณอื่นจาก').decode('UTF8') );
row1.write(8, ('ผู้รับผิดชอบ').decode('UTF8') );
row1.write(9, ('กลุ่ม').decode('UTF8') );
row1.write(10, ('หน่วย/งาน').decode('UTF8') );
i=i+1;
style = XFStyle();
style.num_format_str = '#,##0.00';
for value in objectProject:
row1 = sheet1.row(i) ;
row1.write(0, value.get('project_type').decode('UTF8') );
row1.write(1, value.get('project_name').decode('UTF8') );
row1.write(2, value.get('detail').decode('UTF8') );
row1.write(3, value.get('allBudget') ,style );
row1.write(4, value.get('project_budget' ) ,style );
row1.write(5, value.get('maintenance_funds_budget'),style );
row1.write(6, value.get('budget_other') ,style );
if(value.get('budget_other_from')):
row1.write(7, value.get('budget_other_from').decode('UTF8') );
if(value.get('user_name')):
row1.write(8, value.get('user_name').decode('UTF8') );
row1.write(9, value.get('division').decode('UTF8') );
row1.write(10, value.get('section').decode('UTF8') );
i=i+1;
dirTempFile = gettempdir() + _os.sep + str('simple.xls');
book.save(dirTempFile);
#book.save(TemporaryFile());
return dirTempFile;
开发者ID:tongpa,项目名称:bantakCom,代码行数:56,代码来源:projecttoexcel.py
示例3: getDefualtStyle
def getDefualtStyle():
fnt = Font()
fnt.name = 'Arial'
borders = Borders()
borders.left = Borders.THIN
borders.right = Borders.THIN
borders.top = Borders.THIN
borders.bottom = Borders.THIN
#pattern = Pattern()
#pattern.pattern = Style.pattern_map['solid']
###pattern.pattern_back_colour = 0xBFBFBF
#pattern.pattern_fore_colour = 0x37
alignment = Alignment()
#alignment.horizontal = Alignment.HORZ_LEFT
alignment.horizontal = Alignment.HORZ_RIGHT
style = XFStyle()
#~ style.num_format_str='0.000%'
#~ style.num_format_str='0+'
#~ style.font = fnt
style.align = alignment
#style.borders = borders
#~ style.pattern = pattern
return style
开发者ID:Eddy-W,项目名称:scripts,代码行数:30,代码来源:savedata2xls_new.py
示例4: css2excel
def css2excel(css):
#custom_css = 'font: name "%s", %s on'%(current_value['font-family'].split(",")[0], current_value['font-weight'].split(",")[0])
#export_sheet.write(row_idx, col_idx, current_value['data'], xlwt.easyxf('font: italic on; pattern: pattern solid, fore-colour grey25'))
xf_list = []
fnt = Font()
borders = Borders()
pattern = Pattern()
align = Alignment()
process_css = {
'font-family' : [fnt, "name" , lambda x : x.split(",")[0]],
'color' : [fnt, "colour_index", lambda x : excel_color_map.get(x,0)+8],
'font-weight' : [fnt, "bold", lambda x : x.upper() == 'BOLD'],
#'font-weight' : [fnt, "bold", lambda x : x == '700'],
'text-align' : [align, "horz", lambda x : {'left':align.HORZ_LEFT, 'right':align.HORZ_RIGHT, 'center':align.HORZ_CENTER, 'justified': align.HORZ_JUSTIFIED}[x]],
'background-color' : [pattern,"pattern_fore_colour", lambda x: excel_color_map.get(x,16)+8],
}
#TODO process_css -> css
for i in process_css.keys():
#print process_css[i][0] ,".",process_css[i][1], " => " , css[i] ," | ", process_css[i][2](css[i])
setattr(process_css[i][0], process_css[i][1], process_css[i][2](css[i]))
style = XFStyle()
style.font = fnt
borders.left = Borders.THIN
borders.right = Borders.THIN
borders.top = Borders.THIN
borders.bottom = Borders.THIN
style.borders = borders
style.pattern = pattern
style.pattern.pattern = 1
style.alignment = align
return style
开发者ID:aniquez,项目名称:mod,代码行数:34,代码来源:excelib.py
示例5: defineFontStyle
def defineFontStyle(argFontName,argIsBold):
style = XFStyle()
font = Font()
font.name = argFontName
font.bold = argIsBold
style.font = font
return style
开发者ID:Alivebox,项目名称:aliveTracker_ws,代码行数:7,代码来源:logReports.py
示例6: get_style
def get_style( font_specs=dict(),
border_specs = dict(),
pattern = None,
num_format_str = None, ):
style_key = ( freeze(font_specs),
freeze(border_specs),
pattern,
num_format_str )
try:
return styles[style_key]
except KeyError:
style = XFStyle()
style.font = Font()
for key, value in font_specs.items():
setattr( style.font, key, value )
style.borders = Borders()
for key, value in border_specs.items():
setattr( style.borders, key, value )
if pattern:
style.pattern = pattern
if num_format_str:
style.num_format_str = num_format_str
styles[ style_key ] = style
return style
开发者ID:odmsolutions,项目名称:Camelot,代码行数:26,代码来源:list_action.py
示例7: data_amend_report
def data_amend_report(workbook, gl, ibm, nc_sp, pvs_sp, fm_sp):
# Sheet 1
sheet = workbook.get_sheet(0)
# Download hyperlink:
sheet.write(1, 0, Formula('HYPERLINK("{}")'.format(settings.IBM_DATA_AMEND_URI)))
# Padded zeroes number format
pad2, pad3, pad4 = XFStyle(), XFStyle(), XFStyle()
pad2.num_format_str = '00'
pad3.num_format_str = '000'
pad4.num_format_str = '0000'
current_row = 3
code_id = ''
for row, data in enumerate(gl, current_row):
# Only insert GLPivDownload objects with a matching IBMData object.
if ibm.filter(ibmIdentifier=data.codeID).exists():
# We have to aggregate all the GLPivotDownload objects with
# matching codeID values, and insert one row with total
# ytdActual and fyBudget values.
if code_id != data.codeID: # Reached the next codeID value.
current_row += 1 # Advance one row.
code_id = data.codeID
i = ibm.get(ibmIdentifier=data.codeID)
sheet.write(current_row, 0, data.codeID)
sheet.write(current_row, 1, int(data.costCentre), pad3)
sheet.write(current_row, 2, data.account, pad2)
sheet.write(current_row, 3, data.service, pad2)
sheet.write(current_row, 4, data.activity, pad3)
try:
sheet.write(current_row, 5, int(data.project), pad4)
except ValueError:
sheet.write(current_row, 5, data.project, pad4)
try:
sheet.write(current_row, 6, int(data.job), pad3)
except ValueError:
sheet.write(current_row, 6, data.job, pad3)
sheet.write(current_row, 7, data.jobName)
sheet.write(current_row, 8, data.activityName)
sheet.write(current_row, 9, data.projNameNo)
sheet.write(current_row, 10, i.budgetArea)
sheet.write(current_row, 11, i.projectSponsor)
sheet.write(current_row, 14, i.regionalSpecificInfo)
sheet.write(current_row, 15, i.servicePriorityID)
sheet.write(current_row, 18, i.annualWPInfo)
sheet.write(current_row, 19, data.mPRACategory)
ytd = gl.filter(codeID=code_id).aggregate(Sum('ytdActual'))
fy = gl.filter(codeID=code_id).aggregate(Sum('fybudget'))
sheet.write(current_row, 20, ytd['ytdActual__sum'])
sheet.write(current_row, 21, fy['fybudget__sum'])
# Insert the footer row formulae and '#END OF INPUT'
sheet.write(current_row+2, 0, '#END OF INPUT')
sheet.write(current_row+2, 20, Formula('SUM({}:{})'.format(cellname(4, 20), cellname(current_row, 20))))
sheet.write(current_row+2, 21, Formula('SUM({}:{})'.format(cellname(4, 21), cellname(current_row, 21))))
# Sheet 2 - Service priority checkboxes.
sheet = workbook.get_sheet(1)
write_service_priorities(sheet, nc_sp, pvs_sp, fm_sp)
开发者ID:parksandwildlife,项目名称:ibms,代码行数:60,代码来源:report.py
示例8: export_to_xls
def export_to_xls(self):
# TODO: take care of all the special cases
wb = Workbook()
ws = wb.add_sheet("Sheet 1")
objects = self.ordered_query(request)
form = self.edit_form_class()
DATE_STYLE = XFStyle()
DATE_STYLE.num_format_str = "DD/MM/YYYY"
col_names = ['id']
for field in form:
if isinstance(field, ModelFieldList):
continue
if hasattr(self.managed_class, field.name):
col_names.append(field.name)
for c, col_name in enumerate(col_names):
ws.write(0, c, col_name)
for r, obj in enumerate(objects):
for c, col_name in enumerate(col_names):
style = None
value = obj.display_value(col_name)
if isinstance(value, Entity):
value = value.name
elif isinstance(value, list):
if all(isinstance(x, basestring) for x in value):
value = "; ".join(value)
elif all(isinstance(x, Entity) for x in value):
value = "; ".join([x.name for x in value])
else:
raise Exception("I don't know how to export column {}".format(col_name))
elif isinstance(value, date):
style = DATE_STYLE
if style:
ws.write(r + 1, c, value, style)
else:
ws.write(r + 1, c, value)
fd = StringIO.StringIO()
wb.save(fd)
debug = request.args.get('debug_sql')
if debug:
# useful only in DEBUG mode, to get the debug toolbar in browser
return '<html><body>Exported</body></html>'
response = make_response(fd.getvalue())
response.headers['content-type'] = 'application/ms-excel'
filename = "%s-%s.xls" % (self.managed_class.__name__,
strftime("%d:%m:%Y-%H:%M:%S", gmtime()))
response.headers['content-disposition'] = 'attachment;filename="%s"' % filename
return response
开发者ID:mmariani,项目名称:abilian-core,代码行数:56,代码来源:frontend.py
示例9: output
def output(file_or_stream, sheetname, headers, values, encoding = 'utf8', footer_text = None, footer_link = None):
import xlwt
book = xlwt.Workbook(encoding)
sh = book.add_sheet(sheetname)
datestyle = XFStyle()
datestyle.num_format_str = 'DD/MM/YYYY'
timestyle = XFStyle()
timestyle.num_format_str = 'HH:MM:SS'
header_font = Font()
header_font.bold = True
al = Alignment()
al.horz = Alignment.HORZ_CENTER
header_style = XFStyle()
header_style.font = header_font
header_style.alignment = al
for i,header in enumerate(headers):
sh.write(0, i, header, header_style)
sh.set_panes_frozen(True) # frozen headings instead of split panes
sh.set_horz_split_pos(1) # in general, freeze after last heading row
sh.set_remove_splits(True) # if user does unfreeze, don't leave a split there
for j, row in enumerate(values):
for i, value in enumerate(row):
if value.__class__ == date:
sh.write(j+1, i, value, datestyle)
elif value.__class__ == time:
sh.write(j+1, i, value, timestyle)
else:
sh.write(j+1, i, value)
if footer_link and footer_text:
link_font = Font()
link_font.name = 'Verdana'
link_font.colour_index = 4
link_font.height = 20*8
al = Alignment()
al.horz = Alignment.HORZ_CENTER
al.vert = Alignment.VERT_BOTTOM
link_style = XFStyle()
link_style.font = link_font
link_style.alignment = al
row = len(values) + 1
sh.write_merge(row, row, 0, len(headers)-1, Formula('HYPERLINK("' + footer_link + '";"' + footer_text + '")'), link_style)
book.save(file_or_stream)
开发者ID:fopina,项目名称:pipwebrep,代码行数:55,代码来源:xlwt_helper.py
示例10: exportToExcel
def exportToExcel(self,objectBooks):
book = Workbook();
sheet1 = book.add_sheet('Sheet 1')
if( objectBooks):
i=0;
row1 = sheet1.row(i) ;
row1.write(0, ('เลขทะเบียน').decode('UTF8') );
row1.write(1, ('ที่').decode('UTF8'));
row1.write(2, ('ลงวันที่').decode('UTF8') );
row1.write(3, ('จาก').decode('UTF8') );
row1.write(4, ('ถึง').decode('UTF8') );
row1.write(5, ('เรื่อง').decode('UTF8') );
row1.write(6, ('การปฏิบัติ').decode('UTF8') );
row1.write(7, ('หมายเหตุ').decode('UTF8') );
i=i+1;
style = XFStyle();
style.num_format_str = 'D-MMM-YY';
for value in objectBooks:
row1 = sheet1.row(i) ;
row1.write(0, value.get('book_number').decode('UTF8') );
row1.write(1, value.get('book_at').decode('UTF8') );
row1.write(2, value.get('book_recive') ,style );
row1.write(3, value.get('book_from').decode('UTF8') );
row1.write(4, value.get('book_to' ).decode('UTF8') );
row1.write(5, value.get('book_detail').decode('UTF8') );
row1.write(6, value.get('book_operations').decode('UTF8') );
row1.write(7, value.get('book_remark').decode('UTF8') );
#row1.write(7, value.get('book_type_name').decode('UTF8') );
i=i+1;
dirTempFile = gettempdir() + _os.sep + str('books.xls');
book.save(dirTempFile);
#book.save(TemporaryFile());
return dirTempFile;
开发者ID:tongpa,项目名称:bantakCom,代码行数:49,代码来源:bookstoexcel.py
示例11: merge_styles
def merge_styles(row_style, col_style, default_style=easyxf('')):
"""Merges row and column style.
Method tries to get "strongest" style feauters from col (row) style
and replicate it to row (col) style.
Alas, it doesn't stable yet.
"""
if (row_style, col_style) in styles_cache:
new_style = styles_cache[row_style, col_style]
else:
new_style = XFStyle()
# Merge borders
new_style.borders.top = row_style.borders.top if row_style.borders.top > col_style.borders.top \
else col_style.borders.top
new_style.borders.left = row_style.borders.left if row_style.borders.left > col_style.borders.left \
else col_style.borders.left
new_style.borders.right = row_style.borders.right if row_style.borders.right > col_style.borders.right \
else col_style.borders.right
new_style.borders.bottom = row_style.borders.bottom \
if row_style.borders.bottom > col_style.borders.bottom else col_style.borders.bottom
# Merge pattern
if default_style.pattern.pattern == row_style.pattern.pattern:
new_style.pattern.pattern = col_style.pattern.pattern
else:
new_style.pattern.pattern = row_style.pattern.pattern
if default_style.pattern.pattern_fore_colour == row_style.pattern.pattern_fore_colour:
new_style.pattern.pattern_fore_colour = col_style.pattern.pattern_fore_colour
else:
new_style.pattern.pattern_fore_colour = row_style.pattern.pattern_fore_colour
if default_style.pattern.pattern_back_colour == row_style.pattern.pattern_back_colour:
new_style.pattern.pattern_back_colour = col_style.pattern.pattern_back_colour
else:
new_style.pattern.pattern_back_colour = row_style.pattern.pattern_back_colour
# Merge font
new_style.font = merge_fonts(row_style.font, col_style.font, default_style.font)
styles_cache[row_style, col_style] = new_style
return new_style
开发者ID:p0123n,项目名称:xlrep,代码行数:46,代码来源:reports.py
示例12: save_xls
def save_xls(path,data):
"""
Save formated data to xls file
"""
w = Workbook()
ws = w.add_sheet('Sheet 1')
for i in range(len(data)):
for j in range(len(data[i])):
if j==4 and i>0:
continue
ws.write(i, j, data[i][j])
#rewrite date with apropriate format
date_format = XFStyle()
date_format.num_format_str = 'mm/dd/yyyy'
for i in range(1,len(data)):
ws.write(i, 4, data[i][4], date_format)
w.save(path)
开发者ID:hardkun,项目名称:Quantulus_Toolbox,代码行数:17,代码来源:reg2xls.py
示例13: excel_style
def excel_style():
borders_amount = Borders()
borders_amount.right = Borders.THIN
borders_amount.top = Borders.THIN
borders_amount.bottom = Borders.THIN
borders_name = Borders()
borders_name.left = Borders.THIN
borders_name.right = Borders.THIN
borders_name.top = Borders.THIN
borders_name.bottom = Borders.THIN
style_amount = XFStyle()
style_amount.borders = borders_amount
style_name = XFStyle()
style_name.borders = borders_name
return style_amount, style_name
开发者ID:juacompe,项目名称:beryl,代码行数:18,代码来源:views.py
示例14: estiloCeldasSeparadas
def estiloCeldasSeparadas():
fnt = Font()
fnt.bold=True
#fnt.colour_index=2
borders = Borders()
borders.left = Borders.MEDIUM
borders.right = Borders.MEDIUM
borders.top = Borders.MEDIUM
borders.bottom = Borders.MEDIUM
pattern = Pattern()
pattern.pattern = Pattern.SOLID_PATTERN
pattern.pattern_fore_colour = 0x18#0x99
style = XFStyle()
style.num_format_str='YYYY-MM-DD'
style.font = fnt
style.borders = borders
style.pattern = pattern
return style
开发者ID:santicalvo,项目名称:traductorpy,代码行数:18,代码来源:init_extract.py
示例15: render_excel
def render_excel(filename, col_title_list, data_row_list):
import StringIO
output = StringIO.StringIO()
export_wb = Workbook()
export_sheet = export_wb.add_sheet('Export')
col_idx = 0
for col_title in col_title_list:
export_sheet.write(0, col_idx, col_title)
col_idx += 1
row_idx = 1
for row_item_list in data_row_list:
col_idx = 0
for current_value in row_item_list:
if current_value:
current_value_is_date = False
if isinstance(current_value, datetime.datetime):
current_value = xlrd.xldate.xldate_from_datetime_tuple((current_value.year, current_value.month, \
current_value.day, current_value.hour, current_value.minute, \
current_value.second), 0)
current_value_is_date = True
elif isinstance(current_value, datetime.date):
current_value = xlrd.xldate.xldate_from_date_tuple((current_value.year, current_value.month, \
current_value.day), 0)
current_value_is_date = True
elif isinstance(current_value, datetime.time):
current_value = xlrd.xldate.xldate_from_time_tuple((current_value.hour, current_value.minute, \
current_value.second))
current_value_is_date = True
elif isinstance(current_value, models.Model):
current_value = str(current_value)
if current_value_is_date:
s = XFStyle()
s.num_format_str = 'M/D/YY'
export_sheet.write(row_idx, col_idx, current_value, s)
else:
export_sheet.write(row_idx, col_idx, current_value)
col_idx += 1
row_idx += 1
export_wb.save(output)
output.seek(0)
response = HttpResponse(output.getvalue())
response['Content-Type'] = 'application/vnd.ms-excel'
response['Content-Disposition'] = 'attachment; filename='+filename
return response
开发者ID:prlakhani,项目名称:chemDB,代码行数:44,代码来源:util.py
示例16: toExcel
def toExcel(self, frames):
import StringIO
from xlwt import Workbook, XFStyle
# Need a file handle to save to
f = StringIO.StringIO()
frames = self.flattenFeature(frames)
if len(frames) > 0:
keys = frames[0].keys()
# Construct a workbook with one sheet
wb = Workbook()
s = wb.add_sheet("frames")
# Create the style for date/time
dateStyle = XFStyle()
dateStyle.num_format_str = "MM/DD/YYYY HH:MM:SS"
# Add the header/field labels
r = s.row(0)
for i, name in enumerate(keys):
r.write(i, name)
# Write the data
for i, frame in enumerate(frames):
print type(frame["capturetime"])
for j, name in enumerate(keys):
try:
if type(frame[name]) == datetime:
s.write(i + 1, j, frame[name], dateStyle)
else:
s.write(i + 1, j, str(frame[name]))
except KeyError:
pass
# Save the the string IO and grab the string data
wb.save(f)
output = f.getvalue()
f.close()
return output
开发者ID:rick446,项目名称:SimpleSeer,代码行数:43,代码来源:Filter.py
示例17: render_excel_to_file
def render_excel_to_file(filename, col_title_list, data_row_list):
output = StringIO.StringIO()
export_wb = Workbook()
export_sheet = export_wb.add_sheet('Export')
col_idx = 0
s = XFStyle()
s.num_format_str = 'M/D/YY'
for col_title in col_title_list:
export_sheet.write(0, col_idx, col_title)
col_idx += 1
row_idx = 1
for row_item_list in data_row_list:
col_idx = 0
for current_value in row_item_list:
if current_value:
current_value_is_date = False
if isinstance(current_value, datetime.datetime):
current_value = xlrd.xldate.xldate_from_datetime_tuple((current_value.year, current_value.month, \
current_value.day, current_value.hour, current_value.minute, \
current_value.second), 0)
current_value_is_date = True
elif isinstance(current_value, datetime.date):
current_value = xlrd.xldate.xldate_from_date_tuple((current_value.year, current_value.month, \
current_value.day), 0)
current_value_is_date = True
elif isinstance(current_value, datetime.time):
current_value = xlrd.xldate.xldate_from_time_tuple((current_value.hour, current_value.minute, \
current_value.second))
current_value_is_date = True
elif isinstance(current_value, models.Model):
current_value = str(current_value)
if current_value_is_date:
"""
s = XFStyle()
s.num_format_str = 'M/D/YY'
"""
export_sheet.write(row_idx, col_idx, current_value, s)
else:
export_sheet.write(row_idx, col_idx, current_value)
col_idx += 1
row_idx += 1
export_wb.save(filename)
开发者ID:aniquez,项目名称:mod,代码行数:42,代码来源:excelib.py
示例18: write_row
def write_row(self, array):
"""
write a row into the file
"""
for i in range(0, len(array)):
value = array[i]
style = None
tmp_array = []
if isinstance(value, datetime.datetime):
tmp_array = [
value.year, value.month, value.day,
value.hour, value.minute, value.second
]
value = xlrd.xldate.xldate_from_datetime_tuple(tmp_array, 0)
style = XFStyle()
style.num_format_str = DEFAULT_DATETIME_FORMAT
elif isinstance(value, datetime.date):
tmp_array = [value.year, value.month, value.day]
value = xlrd.xldate.xldate_from_date_tuple(tmp_array, 0)
style = XFStyle()
style.num_format_str = DEFAULT_DATE_FORMAT
elif isinstance(value, datetime.time):
tmp_array = [value.hour, value.minute, value.second]
value = xlrd.xldate.xldate_from_time_tuple(tmp_array)
style = XFStyle()
style.num_format_str = DEFAULT_TIME_FORMAT
if style:
self.native_sheet.write(self.current_row, i, value, style)
else:
self.native_sheet.write(self.current_row, i, value)
self.current_row += 1
开发者ID:62484m,项目名称:QQ-Groups-Spider,代码行数:31,代码来源:xls.py
示例19: creaHojaDeTraduccion
def creaHojaDeTraduccion(excel, nombreHoja="traduccion"):
hoja=excel.creaHoja(nombreHoja)
hoja.col(0).width=90*256
hoja.col(1).width=20*256
fnt = Font()
fnt.bold=True
#fnt.colour_index=2
borders = Borders()
borders.left = Borders.MEDIUM
borders.right = Borders.MEDIUM
borders.top = Borders.MEDIUM
borders.bottom = Borders.MEDIUM
pattern = Pattern()
pattern.pattern = Pattern.SOLID_PATTERN
pattern.pattern_fore_colour = 0x18#0x99
style = XFStyle()
style.num_format_str='YYYY-MM-DD'
style.font = fnt
style.borders = borders
style.pattern = pattern
hoja.write(0,0,"Original Text",style)
hoja.write(0,1,"Translation",style)
return hoja
开发者ID:santicalvo,项目名称:traductorpy,代码行数:23,代码来源:init_extract.py
示例20: write_resultset_to_xls_book
def write_resultset_to_xls_book(book,sheetname,results,**kwargs):
logging.debug('MAKE SHEET %s',sheetname)
sheet1 = book.add_sheet(sheetname)
names = None
if kwargs.has_key('names'):
names = kwargs['names']
if names is None:
names=[ "FIELD%03d" % (i+1) for i in range(len(results[0])) ]
for i,n in enumerate(names):
sheet1.write(0,i,n)
style = XFStyle()
style.num_format_str = "0.0"
for i,t in enumerate(results):
for j,v in enumerate(t):
if np.isnan(v):
sheet1.write(j+1,i,None)
else:
sheet1.write(j+1,i,v,style)
开发者ID:exedre,项目名称:e4t.new,代码行数:23,代码来源:xls.py
注:本文中的xlwt.XFStyle类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论