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')

 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;
      
     
     
      

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

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

def defineFontStyle(argFontName,argIsBold):
    style = XFStyle()
    font = Font()
    font.name = argFontName
    font.bold = argIsBold
    style.font = font
    return 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

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)

  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

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)

 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;

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

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)

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

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

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

    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

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)

 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

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

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)