DbVisualizer 导出大数据

DbVisualizer 导出大数据

工具: 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:Userswits"
BinaryFormat="Don't Export"
BooleanFalseFormat="false"
BooleanTrueFormat="true"
CLOBFileDir="C:Userswits"
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:TEMPtemp22.xlsx"
Format="XLS"
HtmlColumnHeaderIsColumnAlias="true"
HtmlConvertChars="true"
HtmlFooter="[ Generated by: DbVisualizer Pro 10.0.20 ]"
HtmlIncludeSQLCommand="false"
HtmlIntroText=""
HtmlPerTableHeader="
  Date:
  DbV:dbvis-timestamp:VbD


  Columns:
  DbV:dbvis-column-count:VbD


  Table:
  DbV:dbvis-object:VbD

"
HtmlPerTableHeaderGridExport="
  Date:
  DbV:dbvis-timestamp:VbD


  Rows:
  DbV:dbvis-row-count:VbD


  Columns:
  DbV:dbvis-column-count:VbD

"
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脚本  --  START
  SELECt 1 FROM dual;

--    执行的SQL脚本  --  END
@export off;

 

---

参考：

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

https://laijava.com/archives/dbvisualizerexportdata