Hi,
I’m working on an automation. I’m extracting specific information from a wide range of PDFs and, I’m extracting them into an Excel. I put the information into the Excel with Build Data Table, Add Data Row and Write Range. I could pass all the information into the Excel. However, my problem is with the format inside.
When I extract the information, the excel looks like this:
Therefore, I want to know whether is a way to change the width of columns and rows to have my excel like the third photo. And, if there is a way, which I didn’t find, how to do it.
Hi @Pravin_Patil1 ,
I’ve tried the activities that you sent me. The thing is that I have +80 rows in the excel and in the photo below I want to put a range between the 1 and the 80 row. However, in what you sent me, to write Rows Range is {numberofrow1, numberofrow2,…}
Do you know how to write the Range between row 1 and 80 instead of writing 1-80 numbers?