5 examples of 'exporting dataframe to excel python' in Python

634
def export_matrix_to_excel(row_names, col_names, matrix, filepath='export.xlsx', sheetname='Export'):
635
    workbook = xlsxwriter.Workbook(filepath)
636
    ws = workbook.add_worksheet(sheetname)
637
    # formatting
638
    # border
639
    format_border = workbook.add_format()
640
    format_border.set_border(1)
641
    format_border.set_font_size(9)
642
    # border + text wrap
643
    format_border_text_wrap = workbook.add_format()
644
    format_border_text_wrap.set_text_wrap()
645
    format_border_text_wrap.set_border(1)
646
    format_border_text_wrap.set_font_size(9)
647
    # set column width
648
    ws.set_column(0, 1, width=15, cell_format=None)
649
    ws.set_column(1, 50, width=9, cell_format=None)
650
    # write data
651
    for i, p in enumerate(col_names):  # process names
652
        ws.write(0, i+1, p, format_border_text_wrap)
653
    for i, p in enumerate(row_names):  # product names
654
        ws.write(i+1, 0, p, format_border)
655
    for i, row in enumerate(range(matrix.shape[0])):  # matrix
656
        ws.write_row(i+1, 1, matrix[i, :], format_border)
657
    workbook.close()

49
def write(self, row_n, col_n, value):
50
    '''写入数据，如(2,3，"hello"),第二行第三列写入数据"hello"'''
51
    self.ws.cell(row_n, col_n).value = value
52
    self.wb.save(self.filename)

15
def export_set(dataset):
16
    """Returns a TSV representation of Dataset."""
17
18
    stream = StringIO()
19
20
    if is_py3:
21
        _tsv = csv.writer(stream, delimiter='\t')
22
    else:
23
        _tsv = csv.writer(stream, encoding=DEFAULT_ENCODING, delimiter='\t')
24
25
    for row in dataset._package(dicts=False):
26
        _tsv.writerow(row)
27
28
    return stream.getvalue()

84
def WriteToExcel():
85
    f = open('wordbank.csv','w')
86
    list = CountInstancesGlobal()
87
    for twoplet in list:
88
        f.write(str(twoplet[0]))
89
        f.write(',')
90
        f.write(str(twoplet[1]))
91
        f.write('\n')
92
    f.close()

325
def exportInExcelFormat(self):
326
    if not self.__fh.closed:
327
        self.close()
328
    self.excelfileName = Utilities.createExcelFileFromFileAndReturnName(
329
        self._fileName)