MySQL Forums :: Stored Procedures :: Stored Procedure to process a Excel Spreadsheet


Advanced Search

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.

Jerry

Options: ReplyQuote


Subject Views Written By Posted
Stored Procedure to process a Excel Spreadsheet 2108 Jerry Ball 10/31/2016 05:24AM
Re: Stored Procedure to process a Excel Spreadsheet 207 Peter Brawley 11/01/2016 09:29AM
Stored Procedure to process a Excel Spreadsheet 325 Jerry Ball 11/01/2016 02:03AM


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.