Em Andamento

generate ms excel file from python

write a python function that takes as its input a list of dictionairies and outputs a nice excel file, user a library like [url removed, login to view] (or something else, but not COM). The resulting excel should be nicely formatted, and the operation should work fast, even on large datasets.

## Deliverables

- attached is an example of how the resulting excel file should look like

- there should be correct formatting for :

- text

- bools

- dates

- integers

- floats -> with a specified number of digits after the decimal point

- the header should have a grey background

- the header font should be bold

- the title font should 12pt

- all other fonts should be 10pt

- a border around the table

- the width of the columns should be adapted to their content

- then function signature should be something like :

createExcel(title, headers, data)

where title = 'Title'

headers = [('header 1':string), ('header 2':float), ... ]

data = [{'header1':'some text', ...

but this is to be discussed upon the needs

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Python, Arquitetura de software, Teste de Software

Ver mais: python look file, work integers, python work, python excel, python data, python 3, php python, MS excel, generate content, excel python, excel function, excel formatting, excel file, string float, php file library, python library, point excel, text function excel, large file, excel file columns, write function python, write file excel, php file operation, php excel file generate, signature file

Acerca do Empregador:
( 9 comentários ) Belgium

ID do Projeto: #3050143

Premiar a:

zahoorahmadgorsi

See private message.

$80.75 USD em 14 dias
(5 Avaliações)
2.7