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')
-
installation Code::
pip install PyautoPDF
-
Dependency installation Code::
pip install openpyxl pip install Pywin32
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.0.tar.gz
(5.2 kB
view hashes)
Built Distribution
Close
Hashes for PyautoPDF-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9f026010a1175665f0ef9fa11b38a8f784b9c326f464f78b80a98aa495e255ee |
|
MD5 | 54cd7fe101d4b8a82629a62ea98a2134 |
|
BLAKE2b-256 | 16b046bb9adf1069173cc62b8988a6dea6870638a3b46ad7b3f6719393490a52 |