DbVisualizer 导出大数据

最新推荐文章于 2024-09-11 14:45:28 发布

qq_40652655

最新推荐文章于 2024-09-11 14:45:28 发布

阅读量7k

点赞数 1

本文链接：https://blog.csdn.net/qq_40652655/article/details/122340388

版权

DbVisualizer SQL查询 Excel导出数据处理数据库工具

关键词由CSDN通过智能技术生成

该博客介绍了如何利用DbVisualizer Pro工具将SQL查询结果导出为Excel文件，详细步骤包括设置导出格式、复制配置、修改文件名和SQL脚本，以及注意Excel的最大行数限制。适用于需要大量数据处理和分析的场景。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

工具: 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脚本  --  START
  SELECT 1 FROM dual;

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