How to do download excel file from apps please help me out

Help Apps
,
1

how to do download excel file from apps please help me out

2

Hi @panguluri_saritha

Follow the below steps,

Step 1: Open the application where excel file is present.
Step 2: Click on the link/download button to open/download the file locally.
Step 3: Make use of Excel Process Scope read/manipulate the downloaded excel file data

Hope this will useful. Thank you.

3

hi,
i have a sql table through executequery, i want to pass this to apps button and when that button is clicked the excel file will download,
can you please tell me the steps

4

Hi @panguluri_saritha ,

Can you please elaborate your issue, which would be helpful to think for the solution.

Thanks,
@Murli_Manohar

5

You can use the below activity for running any sql queries.

Thank you.

6

i have a process in studio,
1.getting a table from sql through executequery
2.this output dt will passed to excel
3. in the apps, when button is clicked, the excel file will download

i am done with 2 steps
can you help me with 3 rd one

7

i have a process in studio and app in orchestrator
1.getting a table from sql through executequery
2.this output dt will passed to excel
3. in the apps, when button is clicked, the excel file will download

i am done with 2 steps
can you help me with 3 rd one

yes done with this but how to download excel when clicking a button in apps can you please help me out
@Jobin_Joy

8

@panguluri_saritha

You can make use of only available events for the control as in the below inline screenshot,

image
image729×530 37.3 KB

You can get the file only from storage bucket.

Hope this will helpful. Thank you.

1 Like
9

Hi @panguluri_saritha ,

First, you need to send the data to the storage bucket,
Then, secondly, you need to create an orchestration process and there is an activity called Download Storage File . There you need to provide the file name with extension
in the path field, Storage name in the Storage field, and file path in the destination field.

Create a button called download and button the function which invokes this orchestration process xaml.

Hope this works!

Thanks,
@Murli_Manohar

1 Like
10

thank you,
orchestrator process same done as you said, but when executing the below error coming can you please help me out
@Murli_Manohar
@Jobin_Joy

Download Storage File: Operation returned an invalid status code ‘BadRequest’

11

Hi @panguluri_saritha ,

Can you please share with me the screenshot of the error which you face? That would be easier for me to give a clear solution.

Thanks,
@Murli_Manohar