Skip to content
A .NET Client for SQLizer's API
Branch: master
Clone or download
Latest commit 92247ed Mar 15, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
SQLizerClient
Tests Added support for ApiKey and Excel files Mar 10, 2019
.gitignore Got CSV files working Mar 8, 2019
LICENSE
README.md
SQLizerClient.sln

README.md

AppVeyor

sqlizer-client-dotnet

A .NET Client for SQLizer's API

SQLizer lets you easily and securely convert Excel, JSON, CSV and other files into SQL databases with table definitions and multiple INSERT statements. We're free for non-commercial use on files with under 5000 rows of data and our paid plans enable you to use our powerful API to build data pipelines that handle billions of rows a day.

SQlizer's API Help Documentation

Getting Started

To convert a file, use to the SQLizerFile object, like this:

SQLizerClient.Settings.ApiKey = "{your api key}"; // This can be found on https://sqlizer.io/account/

var file = new SQLizerClient.SQLizerFile("source.xlsx");

file.DatabaseType = SQLizerClient.DatabaseType.MySQL;
file.TableName = "my_table";
file.HasHeaders = true;
file.SheetName = "Sheet1";
file.CellRange = "A1:C99";
file.CheckTableExists = true;
file.InsertSpacing = 250;

await file.SaveResultAsync("destination.sql");
You can’t perform that action at this time.