Anyone help me.
I’m studying about latest Lumen version, and the following trouble was found.
I have an Excel file as following.
A B C
------------------
X
Y
Z
Now, I want a robot to read A1 cell (=X), and paste this data to B1 cell.
I wrote a scenario manually as followings.
1 define a variable as string type and set “0” as default
2 open excel file
3 set active cell to A1
4 get current cell data to variable
5 set active cell to B1
6 set data from variable to current cell
And I’ve got following result.
A B C
------------------
0 0
Y
Z
Now, default data “0” of valuable was pasted to A1 and B1 cell.
I think this was very strange result, so I tried same robot scenario on the other PC.
This time I’ve got right result as followings.
A B C
------------------
X X
Y
Z
As I atached exported groovy code, please advise me what was happen.
Thank you.
Junji
-----------------Groovy code---------------------------
import com.workfusion.studio.rpa.recorder.api.*
import com.workfusion.studio.rpa.recorder.api.types.*
import com.workfusion.studio.rpa.recorder.api.custom.*
import com.workfusion.studio.rpa.recorder.api.internal.representation.*
import com.workfusion.bot.exception.*
def form_list = RNumber.fromCanonical('0')
def count = RString.of('')
def mojiretsu = RString.of('NULL')
com.workfusion.rpa.helpers.RPA.metaClass.static.$ = { Closure c -> c.call() } // Support for Expression action. Should be implemented in RPA class in next release.
openExcel("C:\\Users\\HS004\\Desktop\\test.xlsx")
try {
setActiveCell("C:\\Users\\HS004\\Desktop\\test.xlsx", "A1")
setCell("C:\\Users\\HS004\\Desktop\\test.xlsx", ExcelCellPosition.CURRENT, mojiretsu as String)
setActiveCell("C:\\Users\\HS004\\Desktop\\test.xlsx", "B1")
setCell("C:\\Users\\HS004\\Desktop\\test.xlsx", ExcelCellPosition.CURRENT, mojiretsu as String)
saveExcel("C:\\Users\\HS004\\Desktop\\test.xlsx")
} finally {
closeExcel("C:\\Users\\HS004\\Desktop\\test.xlsx")
}
