How to save attachment email and read file excel

Help
, , ,
1

Now I save attachments and I want to read file excel.

Please guide me how to read file excel.

2

The saved file?
Then use Excel Application Scope
In that use read range

3

What fill path in Excel Application Scope?

if i don’t know file name.

4

You should save the attachment in a new folder and then read file from that folder using
Directory.GetFiles(FolderPath)(0) for first file

1 Like
5

I use activity assign but error.

image

What wrong?

6

That means that folder doesnt have that file
First Print it in message box to check is it coming or not

7

I try write range in excel.
data to coming.

8

What are u doing in that assign?

9

exceldatatable = read range in excel

image

10

Is output datatable having data if yes
Then check whether the variable of read range having scope global or not

1 Like
11

thank you

12

Welcome!

Happy Automation!

1 Like
13

Hi ImPratham45,

I want to read sheet excel but i don’t know name sheet.

Please guide me.

14

How many sheets are there in a file
and u know the name of the file?

15

1 sheet in file and I don’t know file name.

16

U can use get workbook sheets activity
or Use Application scope variable for workbook
Say Wb is variable then
Wb.Getsheets

17

I don’t understand about Say Wb is variable.

Now I user excel application scope as below.

image

18

image
image880×238 10.8 KB

19

Why I use read range, It error.

image

20

Its an list of sheets
If u have only one then use Wb.sheets(0)