Ask Ben: Updating An Excel Document More Than Once With The POI Utility

Does this utility [POI] include a way to continue to add data to the spread sheet after the first addition? Thanks again for all of your help.

Yes it does. Well, sort of. The POI utility ColdFusion custom tags allows you to dictate a "template" to be used. This template is an existing Excel file whose contents are read in without alteration. Then, you can make changes to the existing Excel data as you see fit. So, if you treat each file as a template, you can continue to make as many updates as you want.

What the POI ColdFusion custom tags do NOT do is pick up where they left off. So for example, if you wrote 100 rows then closed the file. Then opened it again and wrote 100 rows - you'd end up with a file that has 100 rows in it, not 200. If your intent is to have 200 rows, then perhaps we can update the functionality of the tags. Because the "Index" attribute of the rows and cells allows you to manually output data in position you like, I want to avoid the idea of an "append" action:

Besides, if you really are using the POI custom tags to populate a formatted template, you aren't really appending.

What about something like a CALLER-scoped variable that has information about the read-in Excel file? Something like this:

Here, in the context of the current Sheet, POI.InitialRowCount stores the number of rows that were already in the Excel file at the time of instantiation. This way, you could tell the "Index" tracking to pick up after the last row of the read-in Excel file.

Do you think something like that might be useful?