Hello, I’ve developed a workflow that processes PDF invoices by mapping each invoice to a separate Excel file. Each invoice row contains multiple columns, and some invoices include many rows, which can extend the processing time. Sometimes, it takes more than 3-4 minutes to complete a single invoice, likely because it maps each cell individually in Excel. For every piece of data, such as unit price and quantity, it performs a separate write operation. My question is whether there’s a method to write an entire row at once, or even better, the entire table. Is it possible to store the information in memory (as a table) and paste it all at once?

Report
All responses (
Answers (