Shobin Joyakin

1. Community
2. Platform and Developer Forum (Deprecated)
3. Unable to read excel file content from box folder

Yes.. Thats what I did. The below code should help you read the excel file.     items = client.folder(folder_id=inputfolder).get_items()   for item in items:     df= pd.read_excel(io.BytesIO...

• View comment
• Shobin Joyakin
• November 28, 2023 14:23
• 0 votes

1. Community
2. Platform and Developer Forum (Deprecated)
3. Unable to read excel file content from box folder

I found a way out to read Excel files. This worked for me.. pd.read_excel(io.BytesIO(item.content()))

• View comment
• Shobin Joyakin
• October 27, 2023 16:20
• 0 votes

1. Community
2. Platform and Developer Forum (Deprecated)
3. Read box files in python

Hi George.. Did you find a way to read Excel file in Box using python script? The solution Guy Huinen shared works only with CSV files.

• View comment
• Shobin Joyakin
• October 27, 2023 15:45
• 0 votes

1. Community
2. Platform and Developer Forum (Deprecated)
3. Unable to read excel file content from box folder

Hi Neha. Have you found a way to read Excel file in Box? I am also running into the same issue.  Hi Alex, Is Box encoding Excel files in a different format? I am able to read text and csv files aft...

• View comment
• Shobin Joyakin
• October 27, 2023 15:35
• 0 votes