Update existing/Append new rows to a spreadsheet-based table

I have a project that contains an embedded spreadsheet data table (my master dataset). What I'm hoping to do with Ironpython, is update the table once a month with any status changes (from an Oracle database), then search the same Oracle database on the status to see if any new items exist with that status, and append those new rows to the dataset. Those new rows would become part of the permanent master data table, the idea being that the table would continue to grow in size every month with the addition of the new rows. Apologies if this has already been answered, I wasn't sure how to search it and get the answer I was looking for. I've attached a sample of what I'm trying to accomplish.


File sample_file.xlsx9.04 KB

1 Comment

You are basically updating the data from the database everytime by verifying the status for the items in excel. Then why do you need excel based table, you can directly link data table to database and always have updated results?

Khushboo R - Aug 25, 2018 - 7:10pm
+ Add a Comment

(1) Answer