HOW CAN I CREATE A WORKSHEET WITH THE SAME CONTENT WHEN CREATING A NEW WORKSHEET?

My bot extract field from pdf and wrıte to excel wıth creating worksheet for each pdf.

I want it to create the worksheet like this. ( with header, borders, font, background color, row heıght, merge cell etc.)

Please help me..

ROW HEIGHT

sss

Navigator | Tier 3

Could you give more details :(

Navigator | Tier 3

If you are working with A360, then there might be something we can do here.

First, create a Copy of the excel file, and then open the Original.

Then, use an Excel Advanced: Append Action and see if the Sheet gets appended to the other with the same format.

Kind Regards,

Ashwin A.K

Blogs at TheCodingTheory - https://www.thecodingtheory.com

Navigator | Tier 3

Hi Ashwin, It is work but does not write data to these append worksheets. Could you help me Capture

Sign up