25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具,支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库,提供桌面端、Docker、CLI、内置 AI 助手和 MCP。
TypeScript aicliclickhousedatabasedatabase-clientdatabase-managementdockerguimcpmongodbmysqlpostgresqlredisrustsql-serversqlitetaurivue
use dbx_core::xlsx_export::{
build_xlsx_workbook_multi_with_auto_filter, build_xlsx_workbook_with_auto_filter, XlsxWorksheetData,
};
use serde::Deserialize;
use serde_json::Value;
#[derive(Debug, Clone, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct QueryResultXlsxExportRequest {
pub file_path: String,
pub sheet_name: Option<String>,
pub columns: Vec<String>,
#[serde(default)]
pub column_types: Vec<String>,
#[serde(default)]
pub column_comments: Vec<Option<String>>,
/// Render comments as a second header row (names row 1, comments row 2,
/// data from row 3) instead of overriding the header text.
#[serde(default)]
pub header_comment_rows: bool,
pub rows: Vec<Vec<Value>>,
#[serde(default)]
pub numeric_column_right_align: bool,
#[serde(default)]
pub auto_filter: Option<bool>,
/// Global export date/time pattern (Day.js syntax). Drives the workbook's
/// `numFmt`, so a pattern carrying `SSS` keeps milliseconds visible instead
/// of falling back to the `yyyy-mm-dd hh:mm:ss` default.
#[serde(default)]
pub date_time_format: Option<String>,
}
#[derive(Debug, Clone, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct QueryResultsXlsxExportRequest {
pub file_path: String,
pub worksheets: Vec<XlsxWorksheetData>,
#[serde(default)]
pub auto_filter: Option<bool>,
#[serde(default)]
pub date_time_format: Option<String>,
}
#[tauri::command]
pub async fn export_query_result_xlsx(request: QueryResultXlsxExportRequest) -> Result<(), String> {
tauri::async_runtime::spawn_blocking(move || {
let mut data = XlsxWorksheetData {
sheet_name: request.sheet_name,
columns: request.columns,
column_types: request.column_types,
column_comments: request.column_comments,
rows: request.rows,
numeric_column_right_align: request.numeric_column_right_align,
auto_filter: request.auto_filter,
header_comment_rows: request.header_comment_rows,
};
// Ensure consistency: if the feature is disabled, clear the flag.
if !data.numeric_column_right_align {
data.numeric_column_right_align = false;
}
let workbook = build_xlsx_workbook_with_auto_filter(
&data,
request.auto_filter.unwrap_or(true),
request.date_time_format.as_deref(),
)?;
std::fs::write(&request.file_path, workbook).map_err(|err| err.to_string())
})
.await
.map_err(|err| err.to_string())?
}
#[tauri::command]
pub async fn export_query_results_xlsx(request: QueryResultsXlsxExportRequest) -> Result<(), String> {
tauri::async_runtime::spawn_blocking(move || {
let workbook = build_xlsx_workbook_multi_with_auto_filter(
&request.worksheets,
request.auto_filter.unwrap_or(true),
request.date_time_format.as_deref(),
)?;
std::fs::write(&request.file_path, workbook).map_err(|err| err.to_string())
})
.await
.map_err(|err| err.to_string())?
}