Writing Java script output into excel

RPA Automation
,
1

Hi,

I extracted Two Names from Scanned PDF document by converting into image,output which came in{“Grantor”:“Harry D. George, Jr. and Linda F. George”,“Grantee”:". Ebemart and Margaret N. Eberhart, husband"}

Variable
Variable947×204 8.53 KB

while writing into excel it shows" invalid row format" but that excel has already created with those column names.

Please help us anyone…

2

Hi ,

Please find below picture of script of above mentioned error.

image
image1367×580 50.4 KB

4

Hi Tim,

Can i mention like this {“SheetName”:[{customer_info}]}

I tried like this {“SheetName”:[{“Grantor”:“Harry D. George, Jr. and Linda F. George”,“Grantee”:". Ebemart and Margaret N. Eberhart, husband"}]} it worked.but we need use variable which has Grantor and Grantee details

5

Hi Tim,

It worked.Thanks

Please check below pic

image
image1366×634 47.1 KB

I’m getting Config is not defined.Please check right side calculate value in the pic.suggest me any changes i need to make.

7

Hi Tim,

In above mentioned picture,on right side for Variable(excel_filepath) in calcuate a value.

Please check .