excel-1drive-noPassword 1.2.4

Package to download and manipulate Excel files from OneDrive URLs that are set to *accessible by anyone with the URL*

excel_1drive_noPassword

_____________________________________________

The package is immensely useful for data analysts and scientsits who work with files placed in Excel Onedrive files.

This package can be used to directly import all the sheets and their data in an excel file placed in the Onedrive without the need for username or password in a hssle free manner.

The excel file in the Onedrive should be configured to be accessible by anyone with a valid url.

---

Instructions.

To install the package, perform:

pip install excel_1drive_noPassword

How to use the methods:

1. To extract the entire excel sheet as a Dictionary where the keys are the sheet names and the values are the dataframes:

#Importing Library.
import excel_1drive_noPassword as odrxl

#The url of the excel file in the onedrive.
url = "https://1drv.ms/x/s!ApzxvrDY1mm1gTt1N0uvVwITl91i?e=z7YP4T"

data_dict = odrxl.excel_1drive_toDict(url)

2. To extract the sheetnames of the excel file.

#Importing Library.
import excel_1drive_noPassword as odrxl

#The url of the excel file in the onedrive.
url = "https://1drv.ms/x/s!ApzxvrDY1mm1gTt1N0uvVwITl91i?e=z7YP4T"

sheetnames = odrxl.excel_1drive_sheetnames(url)

print(sheetnames)

3. To extract a single sheet from the excel file as a dataframe.

#Importing Library.
import excel_1drive_noPassword as odrxl

#The url of the excel file in the onedrive.
url = "https://1drv.ms/x/s!ApzxvrDY1mm1gTt1N0uvVwITl91i?e=z7YP4T"

sheetname = "sheet_1"

df_sheet = odrxl.excel_1dr_SingleSheet_toDF(url, sheetname)

---

Have fun. :-)