Skip to main content

Python create excel

Project description

pip install easy_excel, xlwt


###Example easy

import os
from easy_excel import Column, Sheet, Excel


class A:
def __init__(self, a='Nothing', b='Hello my friend', c=43):
self.a, self.b, self.c = a, b, c


excel_example = Excel()
columns = [
Column('a', lambda x: x.b, width=5000),
Column('b', lambda x: x.b, width=6000),
Column('Thi is C', lambda x: x.c)
]
sheet = Sheet('New sheet', columns=columns, objects=[A(), A(b='54'), A('Hi', 'example')])
excel_example.add_sheet(sheet)

base_dir = os.path.dirname(os.path.abspath(__file__))
excel_example.save(file_name='example1', dir=base_dir + '/excel/')

###Example inheritance
import os
from easy_excel import Column, Sheet, Excel


class CustomTemplateSheet(Sheet):
title = 'Example title sheet'
name = 'Example name sheet'
columns = [
Column('first', lambda x: x['first']),
Column('this is second', lambda x: x['second'], width=15000),
]

excel = Excel()
objects = [
{'first': "I'm first", 'second': 'Hi'},
{'first': '1', 'second': 2},
{'first': 'and me', 'second': 'and you'},
{'first': 'and me', 'second': 'and you'},
{'first': 'and me', 'second': 'and you'},
{'first': 'and me', 'second': 'and you'},
{'first': 'and me', 'second': 'and you'},
{'first': 'and me', 'second': 'and you'},
]
sheet1 = CustomTemplateSheet(objects=objects)
sheet2 = CustomTemplateSheet(
name='Im second sheet', title='Im for first object', object=objects[0]
)

excel.add_sheet(sheet1)
excel.add_sheet(sheet2)

base_dir = os.path.dirname(os.path.abspath(__file__))
excel.save(file_name='example2', dir=base_dir + '/excel/')

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for easy_excel, version 0.0.7
Filename, size File type Python version Upload date Hashes
Filename, size easy_excel-0.0.7.tar.gz (3.3 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page