How to create excel value and add a variable


#1

Hi,

I had parsed a PDF, and extracted a variable, then i need to save this value into an excel file (just 2 columns and 2 row )


#2

straight forward ---- Write Cell Activity (if you know which cell)


#3

it must be inside an excel scope i had tryed this :


#4

didn’t work?


#5

yes it did not work


#6

Hi,
As the output of PDF reader is in the string format not in the rows and columns .you should extract each value and then you need to pass the value into cell.
make use of indexing and substring to get expected result and then pass each value inside WriteCell activity.