Write range excel application scope

Help Studio
, ,
1

Hi All,

I have excel file with extension is .xlsm and was opened by using Excel application scope
image

for each transition in excel I should add value in Remark column

by using write cell i am trying
image

but getting this error like its workbook but file.xlsm

image
image986Ă—37 15.4 KB

Please let me know the solution.

Thank you.

2

Hi @vineelag

Use excel application scope and write cell from excel activities and try again
image

Regards
Sudharsan

3

Hello @vineelag
Try this

  1. Place the Kill activity for “Excel” with Continue on the Error property enabled before using the Excel application scope.
  2. use Delay 2 seconds after the Kill activity.
  3. Use some delays before writing the Remark in the cell.
1 Like
4

@Sudharsan_Ka

Thank you,

but did the same thing, but still getting error

5

TempSheetName is a value get from other spreedsheet? if so, make sure you don’t close this sheet before paste value to another one.

1 Like
6

Hi @rikulsilva

But as my code designed like it always close excel file . when ever its open excel for example
image

image

in our every process we are using in this format for config file

as per config code whenever we are open config file it automatically close the excel file.

7

Hi @rikulsilva ,

i was tried this ,but still getting the sam e error.

8

Hi

Try put delay activity before write the value with 1 second, just for debugging purpose

1 Like
9

@rikulsilva

i did that one also
image

10

Hi @Gokul_Jayakumar

will you please explain in step wise please
image
i am not able to see continue error

11

Hi

Try log the TempSheetName in Log Message Activity before Write Cell to see it value. Also try put hardcode value in Write Cell to isolate where problems occurs

1 Like
12

Hey

can you try with modern activities instead?

image
image630Ă—703 16.7 KB

Regards

1 Like
13

@fernando_zuluaga ,

i am not allowed to use

Thank you

14

did you try using the write woorkbook cell activity?

15

@vineelag

Can you tell what is the system package version and studio version…Did you try changing it?

And is the file your trying to read is proper…Can you print the filename and sheetname variables you are using and check…Please try with visible property unclecked

Also try removing save and use a save workbook activity instead

Hope this helps

cheers

16

Hi @Anil_G

STUDIO version 2020.10.6
package
image

Please let me know is there any other way to add row(count+1) Values.

without using Write cell

Thank you

17

Hi @fernando_zuluaga ,

No because it macro sheet .xlsm

it don’t work in workbook.

Please let me know is there any other way to add row(count+) Value.

Thank you.

18

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.