Writing Java script output into excel

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"}

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

Please help us anyone…

Hi ,

Please find below picture of script of above mentioned error.

Hi @Nikilesh,

When you use Write Excel File activity you need to use specific data format:
{"sheet_name": [row1, row2, etc]} where each row has a format of: {"Column1": "Value1", "Column2":"Value2", etc}.
So in your case your customer_info variable should look like this:
{"SheetName":[{"Grantor":"Harry D. George, Jr. and Linda F. George","Grantee":". Ebemart and Margaret N. Eberhart, husband"}]}

I’ve also noticed that your Write Excel File activity is using previous step result as a value, but previous step is Append to file, it has no output result. You should use calculate a value and enter your variable there.

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

Hi Tim,

It worked.Thanks

Please check below pic

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

@Nikilesh, please show where you define config variable

Hi Tim,

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

Please check .

Hi @Nikilesh

I meant where do you create this variable?