How to convert file info from " wait download activity"

Help Studio
, , , , ,
1

How to convert “Downloaded file” from " wait download activity" to datable format?

image

2

What’s the file type of the downloaded file?

3

it’s xlsx file

4

Output_PowerBI.FullName will give you the path and filename as a string, which you can use in your Excel activities to read the file.

The datatype of Output_PowerBI is FileInfo, which has many useful properties.

5

thanks! but how to put this in Write Range?

6

Hello @Nightowl_music
try this

Output_PoserBl.tostring

Best try to print it using a message box and pass it in the write range.
You can get the file name with the path location.

refer to this XAML file, you may get some idea
WaitDownload_Forum.xaml (10.4 KB)

7

is not working

8

Its Working for me, Kindly share the screenshot of your flow or error messages

image
image883×350 15.4 KB

9

yes I have this to, but when you use " read range" save output as data table. I cannot use the write range

10

Do you need to provide the same path to write data in the Write range?

11

yes exactly

12

Share the Screenshot of the error message.

13

You don’t put it in Write Range. You put it in Use Excel as the path and filename of the Excel file to open.

14

the case is , I need to write the excel file to another excel file.

15

So you put Output_PowerBI.FullName into your Use Excel as the path/filename of the Excel file, read the data into a datatable with Read Range, and then use that datatable to write to whatever you want.

16

image
image649×528 13.7 KB

don’t know how to do it.

17