Write Excel issue

Help
, , , ,
1

Hi. I have a data table and I want to write excel this data table in for each row but I get error like that. How can I fix that ?

Ekran Alıntısı
Ekran Alıntısı722Ɨ292 17.1 KB

2 Likes
2

Hi @sufyant,
You may already opened the file.

  • Close the excel file and try it again
  • Or End the Excel Process from the task manager and try it again
  • Or Give the Kill Process Activity with the Process Name: excel before you do the excel manipulation
3 Likes
3

We can use WRITE RANGE activity and pass the datatable as input and themat will write that datatable to excel
Write cell will write to a particular cell only

And moreover use a KILL PROCESS activity before writing using excel application scope and write range activity
Where mention as ā€œEXCELā€ in the ProcessName property and then Use excel activities

Cheers @sufyant

1 Like
4

I am using Close Workbook activities but dont working.

5

like that ?
Ekran Alıntısı

1 Like
6

@sufyant

Also in the excel application scope please ensure Read only is unchecked and set other properties create new file etc are set accordingly .

3 Likes
7

Yes, right. But add the kill process before Excel Application Scope.

2 Likes
8

still I get same error

9

I creat excel like that

1
11391Ɨ389 23.2 KB

And write to excel like that

2
21450Ɨ460 26.4 KB

What am I doing wrong ? @kuppu_samy @Palaniyappan @SowmyaLeo

10

Can you show the screenshot of the workflow?

Also check the activities, if you used the Excel App Integration Activity, use those activity only.
If you used the System Workbook Activity, use those activity only.

image

use either of above. the difference is System.File.Workbook works even the MS Office is not installed

2 Likes
11

use the kill process of excel before Excel Application Scope of Second Screenshot.

1 Like
12

like that right ? ProcessName is true ?

1
11472Ɨ506 21.4 KB

1 Like
13

No, youā€™re killing the file I believe. Please give the Process Name as "excel".

1 Like
14

I get same error

1
11509Ɨ500 19.1 KB

15

Can you make the values as static one and check whether is working or not. Once itā€™s worked in static values, will change it as dynamic later.

1 Like
16

I am using in for each row. if I change the value as static I wil have 1 excel file

17

Yes, work it on a separate file and do this operation alone. Once itā€™s worked perfect, we will merge it into the main workflow.

1 Like
18

It is

1 Like
19

I get this error

Ekran Alıntısı
Ekran Alıntısı721Ɨ252 12 KB

20

Make ContinueOnError Property is True in the Kill Process Activity.

image

1 Like