pythone (1) 썸네일형 리스트형 Python_EX-005. 10 way data read from excel file No.MethodCode ExampleProsCons1pandas # to read an Excel file pimport pandas as pd df = pd.read_excel('filename.xlsx') print(df)- Simple & efficient- Requires pandas library2openpyxl# to read an Excel file from openpyxl import load_workbook wb = load_workbook('filename.xlsx') sheet = wb.active for row in sheet.iter_rows(values_only=True): print(row) - Handles .xlsx files well- Slightly more c.. 이전 1 다음