October 1, 2022 at 4:59 PM
#! python3
import zipfile
import pandas as pd
from pathlib import Path
from openpyxl import load_workbook, utils
separator = '\t'
index = False
ext_res = 'csv'
if __name__ == '__main__':
files = Path.cwd().rglob('*.xl*')
for file in files:
try:
sheet_names = load_workbook(file.name, read_only=True, keep_links=False).sheetnames
print('List name', sheet_names)
for sheet_name in sheet_names:
dataframe = pd.read_excel(file.name)
dataframe.to_csv(f'{file.stem}_{sheet_name}.{ext_res}', sep=separator, index=index)
except utils.exceptions.InvalidFileException as e:
dataframe = pd.read_excel(file.name, engine='xlrd')
dataframe.to_csv(f'{file.stem}.{ext_res}', sep=separator, index=index)
except zipfile.BadZipFile as e:
print(e)
pass
'''
pip install pandas
pip install openpyxl
engine=
xlrd supports old-style Excel files (.xls).
openpyxl supports newer Excel file formats.
odf supports OpenDocument file formats (.odf, .ods, .odt).
pyxlsb supports Binary Excel files.
'''
