工具: DbVisualizer Pro 10.0.20 、OS: Windows 10、导出目标：Excel2007(.xlsx)最大支持1048576行、更新时间：2021/1/6

1.执行一个sql查询，使用工具Export导出

2.在导出页面，选择xls，一直选next直到Export（不要点Export），点击Settings->Copy Settings to Clipboard复制向导配置到剪切板。

 

3.粘贴到新窗口。Filename改为真实的导出的附件，替换SQL脚本，然后在新窗口执行。

@export on;
@export set AppendFile="false"
BinaryFileDir="C:\Users\wits"
BinaryFormat="Don't Export"
BooleanFalseFormat="false"
BooleanTrueFormat="true"
CLOBFileDir="C:\Users\wits"
CLOBFormat="Don't Export"
ClipboardFlavor="Unicode String"
ClipboardName=""
CsvColumnDelimiter="\t"
CsvColumnHeaderIsColumnAlias="true"
CsvIncludeColumnHeader="true"
CsvIncludeColumnHeaderPerResult="false"
CsvIncludeSQLCommand="Don't Include"
CsvRemoveNewlines="false"
CsvRowCommentIdentifier=""
CsvRowDelimiter="\n"
CsvSplitFileSize="-1"
DateFormat="yyyy/MM/dd"
DecimalNumberFormat="Unformatted"
DecimalNumberSeparator="."
Destination="File"
Encoding="GBK"
ExcelColumnHeaderIsColumnAlias="true"
ExcelFileFormat="OOXML, Excel 2007 (xlsx)"
ExcelIncludeColumnHeader="true"
ExcelIncludeSQLCommand="false"
ExcelIntroText=""
ExcelSheetName=""
ExcelTextDateTime="true"
ExcelTextOnly="false"
ExcelTitle=""
Filename="D:\TEMP\temp22.xlsx"
Format="XLS"
HtmlColumnHeaderIsColumnAlias="true"
HtmlConvertChars="true"
HtmlFooter="[ Generated by: <a href=""http://www.dbvis.com"">DbVisualizer Pro 10.0.20</a> ]"
HtmlIncludeSQLCommand="false"
HtmlIntroText=""
HtmlPerTableHeader="<tr><td class=""label"">Date:</td><td class=""value""><b>DbV:dbvis-timestamp:VbD</b></td>
</tr>
<tr><td class=""label"">Columns:</td><td class=""value""><b>DbV:dbvis-column-count:VbD</b></td>
</tr>
<tr><td class=""label"">Table:</td><td class=""value""><b>DbV:dbvis-object:VbD</b></td>
</tr>
"
HtmlPerTableHeaderGridExport="<tr><td class=""label"">Date:</td><td class=""value""><b>DbV:dbvis-timestamp:VbD</b></td>
</tr>
<tr><td class=""label"">Rows:</td><td class=""value""><b>DbV:dbvis-row-count:VbD</b></td>
</tr>
<tr><td class=""label"">Columns:</td><td class=""value""><b>DbV:dbvis-column-count:VbD</b></td>
</tr>
"
HtmlTitle=""
ImageHeight=""
ImageWidth=""
JSONColumnHeaderIsColumnAlias="true"
JSONSplitFileSize="-1"
JSONStyle="Array"
MaxRows="-1"
NumberFormat="Unformatted"
NumberGroupingSeparator="Space"
Orientation="Portrait"
QuoteDuplicateEmbedded="true"
QuoteTextData="None"
ShowNullAs="(null)"
SqlAfterExportStmts=""
SqlBeforeExportStmts=""
SqlBeginIdentifier=""
SqlBlockBeginDelim="--/"
SqlBlockEndDelim="/"
SqlDelimitedIdentifiers="false"
SqlEditor="New Editor"
SqlEditorPosition="Last"
SqlEndIdentifier=""
SqlGroupBy="Object"
SqlIncludeAutoGeneratedValues="true"
SqlIncludeCreateDDL="false"
SqlIncludeSQLCommand="Don't Include"
SqlQualifier=""
SqlQualifyColumnName="true"
SqlQualifyObjectName="false"
SqlRowCommentIdentifier="--"
SqlSeparator=";"
SqlSplitFileSize="-1"
TableName="ETS_OU_CITY_MAP"
TimeFormat="HH:mm:ss"
TimeStampFormat="yyyy/MM/dd HH:mm:ss"
TxtColumnHeaderIsColumnAlias="true"
TxtIncludeColumnHeader="true"
TxtIncludeSQLCommand="Don't Include"
TxtRemoveNewLines="false"
TxtRowDelimiter="\n"
TxtSpacesBetweenColumns="1"
XmlColumnHeaderIsColumnAlias="true"
XmlIncludeSQLCommand="false"
XmlIntroText=""
XmlStyle="DbVisualizer";
--    执行的SQL脚本  --  STARTSELECT 1 FROM dual;--    执行的SQL脚本  --  END
@export off;

 

---

参考：

DbVisualizer直接导出SQL查询结果数据到指定文件_LuAndy-CSDN博客_dbvisualizer导出数据

https://laijava.com/archives/dbvisualizerexportdata