Upload excel workbook with all sheets in DSS project

Nainish09
Level 2
Upload excel workbook with all sheets in DSS project

Hi,

I want to upload an excel workbook in my DSS project, but while i am trying to upload it, it is showing me only first sheet, else if i am selecting all the required sheet, its just appending all the sheets side by side.

My basic requirement is that, I should be able to upload excel workbook and then i can use that workbook in python script to process different sheets.

Help me out please in this scenerio.

0 Kudos
2 Replies
AshleyW
Dataiker

Hi @Nainish09 ,

 

You might try putting that Excel file into a managed folder.

 

Cheers,

Ashley

0 Kudos
Nainish09
Level 2
Author

Thank @AshleyW  for your reply, but i forgot to mention that i have to this work in S3 bucket, If i am uploading my excel workbook in a folder stored in s3 bucket, then i am not able to import that particular workbook, because i dont have access to the s3 bucket keys. So, is there any way to import my workbook stored in folder in s3 bucket without giving credentials of s3 bucket?

 

0 Kudos