MIF_E31231430/show_sheets.py

15 lines
484 B
Python

import openpyxl
def show_sheets(file_path):
print(f"\nSheets in: {file_path}")
try:
wb = openpyxl.load_workbook(file_path, read_only=True)
print(wb.sheetnames)
except Exception as e:
print(f"Error: {e}")
show_sheets("../Dataset_TOPSIS_Rekomendasi_Kamera Fix.xlsx")
show_sheets("../Dataset_TOPSIS_Website_Jember_Kamera_paling fix.xlsx")
show_sheets("perhitungan-topsis-outdoor-day.xlsx")
show_sheets("perhitungan-topsis-outdoor-day-formula.xlsx")