Export To Excel Option

[Stacy Martin]

I suspect a common operation is to export your query results to Excel. Currently, this is a cumbersome process:

– Copy all rows. If Data can not fit on clipboard, you must first export the data to an Excel XML file.

– Open Excel.

– Paste the clipboard to new blank spreadsheet. If results were exported to XML file, open XML file.

Shouldn't this be a 1-stop operation from SQLyog: View results in Excel. SQLyog should take care of exporting the results to a temp file and then opening that temp file in Excel. This would be a tremendous timesaver.

[peterlaursen]

Do you know if Excel can be started with the file to be loaded as a parameter? That would be a requirement. 

Besides it is not possible for us to know if user wants to:

1) open a new Excel program instance

2) Open a new sheet in an open Excel instance 

3) or paste after cursor position in current open tab in an open Excel instance.

Additionally we have to consider Linux/Wine and use of the file with other programs than Excel (most important Open Office Calc).

[Stacy Martin]

'peterlaursen' wrote on '10:

Do you know if Excel can be started with the file to be loaded as a parameter? That would be a requirement. 

Besides it is not possible for us to know if user wants to:

1) open a new Excel program instance

2) Open a new sheet in an open Excel instance 

3) or paste after cursor position in current open tab in an open Excel instance.

Additionally we have to consider Linux/Wine and use of the file with other programs than Excel (most important Open Office Calc).

Yes – Excel can be loaded with a file loaded as a parameter.

If specific to exporting to Excel, option 2 followed by 1 is the proper behavior. At least on Windows, this would be similar behavior to double-clicking on Excel file. If an existing instance of Excel is already running, the same instance of Excel is used and the selected file is opened. If Excel is not running, it launches excel and opens the selected file. In this case, the excel file is essentially a temporary file of the SQLyog results.

But approaching this more generically to consider Line/Wine and other programs, perhaps the proper solution is a configuration setting for an external viewer. User selects export to external viewer, which launches the configured program and loads the temp file of the result set.

[Author]

Posts