MySQL Forums
Forum List  »  Stored Procedures

Stored Procedure to process a Excel Spreadsheet
Posted by: Jerry Ball
Date: October 31, 2016 05:24AM

Can I create a stored procedure that when it is called, it will perform the following:

1. Get an excel spreadsheet on the system. and open it.
2. Read a row. in column B, perform a validation of field to a table, if
not found, put an asterisk in column b1,
3. perform the same steps of #2 in column D. When done the update the row
and get the next row until eof.
4. When done, close the spreadsheet and exit.
5. If I create this stored procedure, can I then export it and use to go
against another db on a different machine.
6. My objective is to develop the stored procedure and then use it to be
called and executed against the clients db.

Can someone, plz give me some direction on doing this. Than in advance.


Options: ReplyQuote

Written By
Stored Procedure to process a Excel Spreadsheet
October 31, 2016 05:24AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.