Business Report Automation
Project description
Introduction
PyautoPDF is a Python library to read/write Excel files which includes the format of xlsx/xlsm/xltx/xltm.
Mailing List
Mail at - shaileshsuthar676@gmail.com
Sample Code::
# import the library
from PyautoPDF.PdfAutomationModule import PdfAutomation
import PyautoPDF
# create excel workbook
wb = PyautoPDF.create_wb()
# create a sheet at index zero in the existing workbook
sheet1 = PyautoPDF.create_sheet(wb=wb, sheet_name='Sheet1', index=0)
# variable declaration for sheet
sheet1 = PdfAutomation(target_sheet=sheet1)
# applying a methods to do the color filling task
sheet1.color_filling(1, 1, 6, 8, 2, 1)
# applying a methods to adjust the column width
col_width = {'A': 10, 'B': 15, 'C': 8, 'D': 30}
sheet1.adjust_columns(col_width=col_width)
# saving the workbook
wb.save('test.xlsx')
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
PyautoPDF-0.1.1.tar.gz
(5.1 kB
view hashes)
Built Distribution
Close
Hashes for PyautoPDF-0.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c345aa3b763cd1ec57a35c42f0cf87ad5dc6357ce4861370d5bf01371480312d |
|
MD5 | 3eef6d9df74eaccb30f8975690060e89 |
|
BLAKE2b-256 | b140e0f79efe42aa0b8b9057671170e54177506607932bed849da0d58017a2b6 |