Datafication.ExcelConnector 1.0.9

.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher. 
dotnet add package Datafication.ExcelConnector --version 1.0.9
                    


                    

                
NuGet\Install-Package Datafication.ExcelConnector -Version 1.0.9
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="Datafication.ExcelConnector" Version="1.0.9" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="Datafication.ExcelConnector" Version="1.0.9" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="Datafication.ExcelConnector" />
                    


                            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 Datafication.ExcelConnector --version 1.0.9
                    


                    

                
#r "nuget: Datafication.ExcelConnector, 1.0.9"
#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 Datafication.ExcelConnector@1.0.9
#: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=Datafication.ExcelConnector&version=1.0.9
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=Datafication.ExcelConnector&version=1.0.9
                    


                            Install as a Cake Tool

Datafication.ExcelConnector

Excel file connector supporting .xlsx and .xls formats for Datafication DataBlocks.

Key Features

  • Multiple Formats: Read and write both XLSX and XLS files
  • Sheet Selection: Choose sheets by name or index
  • Column Filtering: Load only specific columns with UseColumns
  • Row Limiting: Control data volume with NRows parameter
  • Remote URLs: Load Excel files directly from web URLs
  • Streaming Support: Batch loading for large Excel files
  • Type Preservation: Maintains numbers, dates, and booleans

Installation

dotnet add package Datafication.ExcelConnector

Quick Start

using Datafication.Connectors.ExcelConnector;

// Load Excel with shorthand method
var data = await DataBlock.Connector.LoadExcelAsync("data/report.xlsx");

// Load specific sheet with configuration
var config = new ExcelConnectorConfiguration
{
    Source = new Uri("file:///data/financials.xlsx"),
    SheetName = "Q4 Sales",
    HeaderRowOffset = 0,
    UseColumns = new[] { "Date", "Revenue", "Profit" }
};
var connector = new ExcelDataConnector(config);
var salesData = await connector.GetDataAsync();

// Export DataBlock to Excel
await data.ExcelSinkAsync("output/report.xlsx");

Documentation

For samples, usage examples, and source code, visit our GitHub repository: github.com/DataficationSDK/Datafication.ExcelConnector

If you find this library useful, consider giving it a star!

For full API documentation and guides: datafication.co

License

Licensed under the Datafication SDK License Agreement.

  • Free: <5 developers AND <$500K annual revenue
  • Commercial license required: 5+ developers OR >$500K annual revenue

For licensing inquiries: support@datafication.co

Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on Datafication.ExcelConnector:

Package Downloads
Datafication.S3Connector

AWS S3 and S3-compatible storage connector for Datafication DataBlocks

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
1.0.9 91 1/24/2026