email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Post here if you experience problems or get unexpected errors.
Hello,

I would like to share with the forum an interesting question that an user has just sent me by email (I asked him for permission before posting this in the forum, of course):
I am observing that as the excel file is growing over 1mb, the write operation is getting slower. Is it expected ? should I write to new excel files and consolidate it in the end ? any other suggestions to make it run faster ?
And my reply was:
Yes, this is an expected behavior. As the Excel file grows, it takes longer to find the last row where the cells must be inserted. This does not happen with databases, they handle properly large amounts of data.
I guess this will be useful for anyone with the same problem. As a side note I must said that it is necessary to have an Excel file with hundreds (may be thousands) of rows to notice that it takes longer to insert a new row.