ExcelWorkbookDb 1.1.0

.NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher. 
dotnet add package ExcelWorkbookDb --version 1.1.0
                    


                    

                
NuGet\Install-Package ExcelWorkbookDb -Version 1.1.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="ExcelWorkbookDb" Version="1.1.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="ExcelWorkbookDb" Version="1.1.0" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="ExcelWorkbookDb" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add ExcelWorkbookDb --version 1.1.0
                    


                    

                
#r "nuget: ExcelWorkbookDb, 1.1.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#:package ExcelWorkbookDb@1.1.0
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=ExcelWorkbookDb&version=1.1.0
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=ExcelWorkbookDb&version=1.1.0
                    


                            Install as a Cake Tool

ExcelWorkbookDb

Excel 工作簿 SQLite 数据库访问包装库（netstandard2.0）。

本库只封装数据库访问，不依赖 Excel 互操作，可被任意 netstandard2.0 应用引用。建表 SQL 以程序集资源 ExcelWorkbookDb.create_excel_db.sql 内嵌在包中，是数据库结构的唯一事实来源。

数据库结构

共三张表：

表 字段 说明
Workbook name 工作簿名称（契约：恒有一行且名称非空）
Worksheet position（主键）、name 工作表的顺序与名称
Cell worksheet、row、col（复合主键）、formula、NumberFormat 单元格内容与数字格式
  • Cell.worksheet 外键引用 Worksheet.name，打开连接时默认开启外键强制（PRAGMA foreign_keys = ON）。
  • Workbook 表恒有一行且名称非空：save 与 createDatabase 保证写入，setWorkbookName 拒绝空名称，读取到空表时 getWorkbookName 报错（旧版本建的库需先补写名称）。
  • 工作簿名称字段目前仅随 save/load 往返保留：从数据库重建 Excel 工作簿（ExcelNumericalMethods.SqliteWorkbook.createWorkbookFrom）是新建工作簿，暂未应用存储的名称。
  • formula 不允许为 NULL（公式为空则该单元格不写入）。
  • NumberFormat 不允许为 NULL，默认 'General'（对应 Excel API Range.NumberFormat）。

用法

open ExcelWorkbookDb

// 新建数据库文件（覆盖已有文件），执行建表 SQL 并立即写入工作簿名称
WorkbookDb.createDatabase path "工作簿1"

// 整体保存：名称 + 工作表 + 单元格（覆盖写入，不合并原有数据）
let data =
    { Name = "工作簿1"
      Worksheets = [| { Position = 1; Name = "Sheet1" } |]
      Cells =
        [| { Worksheet = "Sheet1"
             Row = 1
             Col = 1
             Formula = "=1+2"
             NumberFormat = WorkbookDb.DefaultNumberFormat } |] }
WorkbookDb.save path data

// 读取完整内容
let loaded = WorkbookDb.load path

// 事务写入：成功提交，异常回滚
WorkbookDb.withTransaction path (fun tran ->
    WorkbookDb.insertWorksheet tran { Position = 2; Name = "Sheet2" }
    WorkbookDb.insertCell tran { Worksheet = "Sheet2"; Row = 1; Col = 1; Formula = "=A1"; NumberFormat = WorkbookDb.DefaultNumberFormat })

// 读取指定工作表的单元格
WorkbookDb.withConnection path (fun conn -> WorkbookDb.getCellsOf conn "Sheet1")

API

记录类型

  • WorksheetRow { Position: int; Name: string } —— 对应 Worksheet 表
  • CellRow { Worksheet: string; Row: int; Col: int; Formula: string; NumberFormat: string } —— 对应 Cell 表
  • WorkbookData { Name: string; Worksheets: WorksheetRow[]; Cells: CellRow[] } —— 数据库完整内容
  • CellRow 成员：getLocalAdress() 计算单元格地址（如 A1、AA10）；FullAdress() 计算完整地址（如 Sheet1!A1，工作表名按公式引用规则自动加引号，如 'My Sheet'!A1）

模块 WorkbookDb

函数 说明
createDatabase path name 新建数据库文件（覆盖）、执行建表 SQL 并立即写入工作簿名称
save path data 将完整工作簿数据整体写入文件（覆盖，不合并原有数据）
load path 读取数据库完整内容
withConnection path f 打开连接执行读取操作，结束后释放（开启外键强制）
withTransaction path f 在单个事务中执行写入操作，成功提交、异常回滚
getWorkbookName conn 读取工作簿名称（契约保证恒有一行；空表报错）
getWorksheets conn 读取全部工作表（按 position 升序）
getCells conn 读取全部单元格（按 worksheet, row, col 升序）
getCellsOf conn worksheet 读取指定工作表的单元格
setWorkbookName tran name 写入工作簿名称（先清空 Workbook 表；拒绝空名称）
insertWorksheet tran ws 插入一条工作表记录
insertCell tran cell 插入一条单元格记录
clear tran 清空三张表（保留表结构）
DefaultNumberFormat 数字格式默认值常量 "General"

构建与打包

dotnet build ExcelWorkbookDb\ExcelWorkbookDb.fsproj -c Release
dotnet pack ExcelWorkbookDb\ExcelWorkbookDb.fsproj -c Release
# 产物：ExcelWorkbookDb\bin\Release\ExcelWorkbookDb.1.0.0.nupkg
Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
1.1.0 99 9/14/2026
1.0.0 87 9/14/2026

1.1.0：CellRow 增加 getLocalAdress/FullAdress 地址计算，FullAdress 按 Excel 规则为工作表名自动加引号；契约收紧：Workbook 表恒有一行且名称非空，WorkbookData.Name 由 string option 改为 string，createDatabase 增加 name 参数，setWorkbookName 拒绝空名称，读取空表报错。