How to write excel file in storage bucket using studio-web?

Help Studio Web
, , , , ,
1

Can we create excel in storage bucket from DataTable?
Main task is :-

  1. Read excel file from storage bucket.
  2. Copy data from second excel file and merge into first excel file in same storage bucket.
  3. Either replace same excel file or create another.
  4. All operation should be done on studio web without download/upload any file (onedrive ect.) as per current requirement.

Currently I am only able to read csv from storage bucket and create data table but can’t write in excel inside same storage bucket. However, I tried different method like create/write and download/upload in other storage (Gdrive, OneDrive) but thats not the requrement.

I have tried write range activity but its only support google drive and one drive.
in other side ‘Write Storage Text’ dosn’t support datatable to write in excel.

Please help as this is very urgent requirement.

2

You can’t directly write Excel to a Storage Bucket. You just have to create your file in a folder then upload it to the Storage Bucket. Then when you want to read it, you have to download it from the Storage Bucket to a folder and read it from there.