PL/SQL Developer methods for exporting data to Excel

http://yedward.net/?id=92

problem description : using pl/SQL Developer to export data to Excel table is very necessary, the general may be directly in Select CSV format when exporting, because the format can be opened directly in Excel . However, at the time of export , there is a problem, when exported to CSV format, the data garbled, and exported to XML or HTML when there is no problem.

Figure 1:PL/SQL Developer Export to CSV garbled

Problem Resolution : The above problem may be a set problem with the character set. I have found some other data export methods, which are listed below:

Figure 2:PL/SQL Developer Export data

(1) export as HTML before importing Excel

Figure 3: Open HTML file with IE and select export to Excel

First, export the data as HTML, then open the HTML file with IE and copy the URL of the HTML file in the browser. In the HTML page, right-click to select Export to Microsoft Excel(X).

Figure 4: Entering a new Web query

After selecting " Export to Excel" in the previous step, it will automatically open an Excel and go to the interface of Figure 4, if the address bar in Figure 4 is not automatically filled in the address, then copy the next address, then click "Import", The following operation is a good default confirmation.

Figure 5: Data import feature column table inExcel

It is worth pointing out that there is actually no need to use IE to open, and in IE, this operation, in fact, as long as the browser open, and then copy the HTML file address, and then in Excel "data" imported "from the site" to enter the address is good, The above action is just for the convenience of friends who do not know the operation.

(2) export to XML first, then import Excel

Figure 6: Selecting a data source

export The data to an XML file in pl/SQL Developer, then follow the instructions in Figure 5, select "From XML data import" and then go to the "Select data source" interface in Figure 6, Then select the XML file, followed by default OK.

Figure 7: Example of importing Excel results

When I'm using it, I prefer to export it to an XML file, because it allows you to select the data source directly, without having to know the URL address as HTML, and when you use XML to import Excel , It automatically adds some styling and field filtering to the results of the import, as shown in 7.

PL/SQL Developer methods for exporting data to Excel