You’re offline. This is a read only version of the page.
Announcements
78
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?
Hi @Ronyn77
Writing cell by cell approach will consume more time and will be slow. Another approach would be to store the details of invoice in a datatable variable and write to excel file at once instead of writing each cell everytime.
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Share
Report
All responses (
Answers (
