Unable to read excel file content from box folder

フォローする

新規投稿

Neha Sh

• 2023年06月02日 18:01

Hello,

I am using Python box sdk to read content of an excel file from box folder, but it's not working. Conversion from bytes to string is also not working in this scenario. Although, I am able to read the content of a .txt or .csv file from box. Are there any restriction on excel file? What is the suggested approach to read excel file content?

Thank you

0

• 

  Alex Novotny

  • 2023年06月09日 21:35

  To my knowledge, you would have to use a third party library to actually see the contents of a file. The public Box API doesn't programmatically have access to the underlying data within any content. There shouldn't be any restrictions on the Box side from downloading the file and using a third party library to parse through it.

  0

  コメントアクション パーマリンク
• 

  Shobin Joyakin

  • 2023年10月27日 15:35

  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 after decoding them to utf-8 format, but that doesnt work with excel file. These excel files would read just fine in local but I wont be able to download them to my local.

  0

  コメントアクション パーマリンク
• 

  Shobin Joyakin

  • 2023年10月27日 16:20

  I found a way out to read Excel files. This worked for me..

  pd.read_excel(io.BytesIO(item.content()))

  0

  コメントアクション パーマリンク
• 

  Shobhit Bhatt

  • 2023年11月28日 12:43

  Hi Shobin Joyakin: I am trying to reed the excel file from box and then parse the data. Is it something you also did?

  0

  コメントアクション パーマリンク
• 

  Shobin Joyakin

  • 2023年11月28日 14:23

  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(item.content()))

  0

  コメントアクション パーマリンク

サインインしてコメントを残してください。