3 Respostas
+ 1
You can use pandas library :
import pandas as pd
data = pd.read_excel("yourfile.xlsx")
+ 1
Although Excel is proprietary software from Microsoft, where you find free alternatives that run on Windows, OS X, and Linux. Both LibreOffice Calc and Open Office Calc works with Excel's .xlsx file format for spreadsheets, which means the open module can work on spreadsheets from these applications as well.
Steps to Import an Excel File into Python using pandas
Step 1: Capture the file path
Step 2: Apply the Python code
Step 3: Run the Python code
Optional Step: Selecting subset of column/s
Simple Interface to Import an Excel file
If you want to learn advance excel then join the top best advance excel training course in Noida and get placement in a recognized company.
Source: https://www.cetpainfotech.com/technology/advance-excel-training