MySQL for Excel Guide  /  Import MySQL Data into Excel  /  Importing a Procedure

5.1 Importing a Procedure

To import a stored routine (procedure), first select the appropriate routine parameters, if needed, and then click Call. Next, use the following options to configure the import operation:

  • Include Column Names as Headers: Selected by default, this will insert the column names at the top of the Excel worksheet as a "headers" row.

  • Import: Because a procedure might return multiple result sets, the import options include:

    • Selected Result Set: Imports the selected tab sheet. This is the default behavior.

    • All Result Sets - Arranged Horizontally: Imports all result sets into the Excel Worksheet horizontally, and inserts one empty column between each result set.

    • All Result Sets - Arranged Vertically: Imports all result sets into the Excel Worksheet vertically, and inserts one empty row between each result set.

For example, a preview area within the Import Data window, similar to the one shown in the following figure, will display after you select routine parameters and then click Call to execute the routine.

Figure 5.2 Importing called stored procedure data with MySQL for Excel

Content is described in the surrounding text.