How to write data from table variable to xls

rpa
xls

#1

Hi,
I want to write data from table variable into xls.
But I am not able to achieve it.
I tried printing data in notepad using same ForEach loop ,It is printing data fine.
But I am not able to set cell value using same for each loop.
I have checked save xls after last option checkbox too.

Please find the screen shot.

table1script

I am using RPA 1.1.7

Thanks


#2

It should work. Post your script here too

And it is better to use the Set Range and do it in one action.


#3

Hi,
Where to find set range option.
I have RPA 1.1.7 .
But I have only following options.
range

Thanks


#4

Then you have 1.1.6


#5

hi,

I have updated and reinstalled the RPA just a week before from the provided 1.1.7 link…

This is what it shows on startup.
version

Please help me out in solving this issue.
Thanks


#6

it is showing 1.1.5 in
About RPA recorder.
How do it update it to 1.1.7.

5

Thanks


#7

Maybe you haven’t deleted the RPA Recorder.

Try to click Help > About RPAx Recorder and see which version it shows

You can also try to right click the Open Spreadsheet action:

And please send us your recording which does not execute properly


#8

hi,
Please find attachment of my recording.

rpae_project.zip (12.3 KB)

In about RPA recorder it is showing version 1.1.5.
I tried right clicking on open spreeshet action.

Thanks


#9

So you haven’t completely uninstalled the prev version. Do the following:

https://kb.workfusion.com/display/RPAe/How+to+update+RPA+Express


#10

BTW, your script works perfectly on the 1.1.7 version


#11

hi,
I have reinstalled the workfusion 1.1.7 .
Now it is working.

I am very thankful for your quick response and help.

Thanks.