1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
#!/usr/bin/python
# coding: utf-8
import glob
import os
from os.path import basename, splitext
import xlrd
import openpyxl
from openpyxl import load_workbook
import PyPDF2
from PyPDF2 import PdfFileWriter
import sys
import codecs
sys.stdout = codecs.getwriter("utf-8")(sys.stdout.detach())
path = "."
os.chdir(path)
dir = os.getcwd()
ext = "*.xlsm"
print("dir",dir)
pattern = '/'.join([dir,ext])
print("pattern",pattern)
fics_list = glob.glob(pattern)
for path_file in fics_list:
#ouverture du fichier Excel
workbook = load_workbook(filename=path_file)
filename = basename(path_file)
print("filename",filename)
filename_prefix_CRA,filename_ext = filename.split(".")
pdf_ext = "pdf"
pdf_CRA_filename = '.'.join([filename_prefix_CRA,pdf_ext])
filename_prefix_HSupp = filename_prefix_CRA.replace('CRA','HSupp')
pdf_HSupp_filename = '.'.join([filename_prefix_HSupp,pdf_ext])
sheet_names = workbook.sheetnames
# CRA
workbook.active = 3
worksheet = workbook.active
pdftowrite = PdfFileWriter() |
Partager