Python openpyxl 模块，Workbook() 实例源码

我们从Python开源项目中，提取了以下50个代码示例，用于说明如何使用openpyxl.Workbook()。

项目：guiabolso2csv 作者：hugombarreto | 项目源码 | 文件源码

def xlsx_transactions(self, year, month, file_name):
        transactions = self.transactions(year, month)

        if len(transactions) == 0:
            warnings.warn('No transactions for the period ({}-{})'.format(
                year, month))
            return

        wb = openpyxl.Workbook()
        ws = wb.active

        ws.append(self.fieldnames)

        for trans in transactions:
            if u'date' in trans:
                trans[u'date'] = datetime.datetime.fromtimestamp(
                    trans[u'date']/1000).date()
            row = [trans[k] for k in self.fieldnames]
            ws.append(row)

        wb.save(file_name)

项目：fieldsight-kobocat 作者：awemulya | 项目源码 | 文件源码

def xls_as_xlsx(xls_file):
    # first open using xlrd
    source_workbook = xlrd.open_workbook(file_contents=xls_file.read())

    # Create the destination workbook, deleting and auto-generated worksheets.
    destination_workbook = openpyxl.Workbook() # TODO: Would like to figure out how to make appends work with a "write_only" workbook.
    for wksht_nm in destination_workbook.get_sheet_names():
        worksheet= destination_workbook.get_sheet_by_name(wksht_nm)
        destination_workbook.remove_sheet(worksheet)

    worksheet_names= ['survey', 'choices']
    for wksht_nm in source_workbook.sheet_names():
        source_worksheet= source_workbook.sheet_by_name(wksht_nm)
        destination_worksheet= destination_workbook.create_sheet(title=wksht_nm)

        for row in xrange(source_worksheet.nrows):
            destination_worksheet.append( [source_worksheet.cell_value(row, col) for col in xrange(source_worksheet.ncols)] )

    return io.BytesIO(save_virtual_workbook(destination_workbook))

项目：table-compositor 作者：InvestmentSystems | 项目源码 | 文件源码

def to_xlsx(layout, output_fp, orientation='vertical', **kwargs):
        '''
        Take a layout which contains a list of presentation models builts using the build_presentation_model function.

        Args:
            layout: An nested list of presentation_models, examples: [presentation_model] or [presentation_model1, presentation_mode2] etc
            output_fp: the xlsx file name
            orientation: if vertical, the top level presentation model elements are rendered vertically, and for every nested level the orientation is flipped.
                         if horizontal, then the behavior is inverse
            kwargs:
                    column-width: default=20, the default column width of all columns in the worksheet. Individual column width cannot be set currently
        '''
        row_col_dict = GridLayoutManager.get_row_col_dict(
            layout, orientation=orientation)
        wb = Workbook()
        ws = wb.active
        XLSXWriter._to_xlsx_worksheet(row_col_dict, ws, **kwargs)
        wb.save(output_fp)

项目：python 作者：goodstuden | 项目源码 | 文件源码

def json2xlsx(xlsx_path,json_path):
    wb=Workbook()
    ws1=wb.active
    ws1.title=xlsx_path.split('.')[0].split('\\')[-1]
    with open(json_path) as f:
        fulljson=f.read()
    j=json.loads(fulljson,object_pairs_hook=OrderedDict)#object_pairs_hook ??json???

    for row,row_val in enumerate(j):
        _ = ws1.cell(row=row+1,column=1,value=row_val)
        if isinstance(j[row_val],Iterable) and not isinstance(j[row_val],str):#????????string??
            for col,col_val in enumerate(j[row_val]):
                _= ws1.cell(row=row+1,column=col+2,value=col_val)
        else:
            _ = ws1.cell(row=row+1,column=2,value=j[row_val])

    wb.save(xlsx_path)

项目：KiField 作者：xesscorp | 项目源码 | 文件源码

def test_groups(self):
        wb = pyxl.Workbook()
        ws = wb.active
        header = ('Ref', 'x', 'y', 'z')
        ws.append(header)
        ws.append(('C1', '1', '1', '1'))
        ws.append(('C2', '1', '1', '1'))
        ws.append(('C3', '1', '1', '1'))

        wb = kifield.group_wb(wb)
        ws = wb.active

        assert ws.max_row == 2
        assert ws.max_column == 4

        values = tuple(ws.values)
        assert values[0] == header
        assert values[1] == ('C1-C3', '1', '1', '1')

项目：KiField 作者：xesscorp | 项目源码 | 文件源码

def test_groups2(self):
        wb = pyxl.Workbook()
        ws = wb.active
        header = ('Ref', 'x', 'y', 'z')
        ws.append(header)
        ws.append(('C1', '1', '1', '1'))
        ws.append(('R3', '2', '1', '1'))
        ws.append(('R5', '2', '1', '1'))
        ws.append(('X1', '3', '1', '1'))
        ws.append(('X2', '1', '3', '1'))
        ws.append(('X3', '1', '1', '3'))

        wb = kifield.group_wb(wb)
        ws = wb.active

        assert ws.max_row == 6
        assert ws.max_column == 4

        values = tuple(ws.values)
        assert values[0] == header
        assert values[1] == ('C1', '1', '1', '1')
        assert values[2] == ('R3, R5', '2', '1', '1')
        assert values[3] == ('X1', '3', '1', '1')
        assert values[4] == ('X2', '1', '3', '1')
        assert values[5] == ('X3', '1', '1', '3')

项目：KiField 作者：xesscorp | 项目源码 | 文件源码

def csvfile_to_wb(csv_filename):
    '''Open a CSV file and return an openpyxl workbook.'''

    logger.log(
        DEBUG_DETAILED,
        'Converting CSV file {} into an XLSX workbook.'.format(csv_filename))

    with open(csv_filename) as csv_file:
        dialect = csv.Sniffer().sniff(csv_file.read())
        if USING_PYTHON2:
            for attr in dir(dialect):
                a = getattr(dialect, attr)
                if type(a) == unicode:
                    setattr(dialect, attr, bytes(a))
        csv_file.seek(0)
        reader = csv.reader(csv_file, dialect)
        wb = pyxl.Workbook()
        ws = wb.active
        for row_index, row in enumerate(reader, 1):
            for column_index, cell in enumerate(row, 1):
                if cell not in ('', None):
                    ws.cell(row=row_index, column=column_index).value = cell
    return (wb, dialect)

项目：spartacus 作者：wind39 | 项目源码 | 文件源码

def Open(self):
        try:
            if self.v_extension == 'csv':
                self.v_file = open(self.v_filename, 'w', encoding=self.v_encoding)
                self.v_object = csv.DictWriter(v_file, fieldnames=self.v_header)
                self.v_object.writeheader()
                self.v_open = True
            elif self.v_extension == 'xlsx':
                self.v_object = openpyxl.Workbook(write_only=True)
                self.v_open = True
            else:
                raise Spartacus.Utils.Exception('File extension "{0}" not supported.'.format(self.v_extension))
        except Spartacus.Utils.Exception as exc:
            raise exc
        except Exception as exc:
            raise Spartacus.Utils.Exception(str(exc))

项目：spider 作者：threescales | 项目源码 | 文件源码

def print_book_lists_excel(book_lists, book_tag_lists):
    wb = Workbook(optimized_write=True)
    ws = []
    for i in range(len(book_tag_lists)):
        # utf8->unicode
        ws.append(wb.create_sheet(title=book_tag_lists[i].decode()))
    for i in range(len(book_tag_lists)):
        ws[i].append(['??', '??', '??', '????', '??', '???'])
        count = 1
        for bl in book_lists[i]:
            ws[i].append([count, bl[u'a'], float(bl[u'b']),
                          int(bl[2]), bl[3], bl[4]])
            count += 1
    save_path = 'book_list'
    for i in range(len(book_tag_lists)):
        save_path += ('-' + book_tag_lists[i].decode())
    save_path += '.xlsx'
    wb.save(save_path)

项目：LicenseUsage 作者：Appdynamics | 项目源码 | 文件源码

def __init__(self, account, options, time_range=None):
        self.options = options
        self.skip_tiers = options.get('skip_tiers', False)
        self.granularity = options.get('granularity', 'hourly')
        self.tabs = options.get('tabs')
        self.sheet_per_app = options.get('sheet_per_app', False)
        self.include_non_apm_summary = options.get('include_non_npm_agent_summary', False)
        self.file_name = '%s_%s_%s.xlsx' % (options.get('report_file_prefix', 'license_report'),
            datetime.utcfromtimestamp(time_range.start_time / 1000).strftime("%m-%d-%Y"),
            datetime.utcfromtimestamp((time_range.end_time + 3600000) / 1000).strftime("%m-%d-%Y") )
        self.account = account
        self.applications = account.applications
        self.account_name = account.name
        self.time_range = time_range
        self.workbook = Workbook()
        self.skip_applications = options.get('skip_applications', False)