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:
Which is really bad looking and not useful for me. I want to look the excel like, at least, the second photo:
My ideal Excel is like the third photo:
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.
Thanks a lot!