I want to be able to search and process an MS Excel CSV spreadsheet file in this manner:
To search for a character string in a MS Excel spreadsheet and upon finding it to automatically delete all the records and update the Spreadsheet each time that exact string is found with the csv file size limitation only being the physical memory.
For Example.. If the Department Store Inventory Spreadsheet is composed of 123,000 Records and I want to eliminate every record where the **composition** field of the item is mercury and the spreadsheet file updated with the now new number of records showing.
Another Example: If there is a Nutritional Database Spreadsheet Composed of 247,000 foods gathered from all over the world, I would search for arsenic and when found every record that includes any field containing arsenic would be deleted and the spreadsheet file updated.
I would want to be able to do this for any character string either in a single or multiple fields.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
WindowXP & Vista in all versions of MS Excel From Excel 97 to Present