Important Update
These sample source codes given below will show you how to handle a complex task, for example, calculations and spreadsheet as database with spreadsheet sdk in C#. Calculations and spreadsheet as database with spreadsheet sdk in C# can be applied with ByteScout Data Extraction Suite. ByteScout Data Extraction Suite is the set that includes 3 SDK products for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK.
C# code snippet like this for ByteScout Data Extraction Suite works best when you need to quickly implement calculations and spreadsheet as database with spreadsheet sdk in your C# application. If you want to know how it works, then this C# sample code should be copied and pasted into your application’s code editor. Then just compile and run it. Check these C# sample code examples to see if they acknowledge to your needs and requirements for the project.
If you want to try other samples for C# then free trial version of ByteScout Data Extraction Suite is available on our website.
On-demand (REST Web API) version:
Web API (on-demand version)
On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)
namespace SimpleDatabase
{
partial class Form1
{
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// Clean up any resources being used.
/// </summary>
/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));
this.Label3 = new System.Windows.Forms.Label();
this.TextBox3 = new System.Windows.Forms.TextBox();
this.Label4 = new System.Windows.Forms.Label();
this.Button2 = new System.Windows.Forms.Button();
this.Button4 = new System.Windows.Forms.Button();
this.Button1 = new System.Windows.Forms.Button();
this.Button3 = new System.Windows.Forms.Button();
this.TextBox4 = new System.Windows.Forms.TextBox();
this.Label5 = new System.Windows.Forms.Label();
this.TextBox2 = new System.Windows.Forms.TextBox();
this.Label2 = new System.Windows.Forms.Label();
this.GroupBox1 = new System.Windows.Forms.GroupBox();
this.TextBox1 = new System.Windows.Forms.TextBox();
this.Label1 = new System.Windows.Forms.Label();
this.GroupBox1.SuspendLayout();
this.SuspendLayout();
//
// Label3
//
this.Label3.AutoSize = true;
this.Label3.Location = new System.Drawing.Point(6, 94);
this.Label3.Name = "Label3";
this.Label3.Size = new System.Drawing.Size(39, 13);
this.Label3.TabIndex = 12;
this.Label3.Text = "Label3";
//
// TextBox3
//
this.TextBox3.Location = new System.Drawing.Point(9, 110);
this.TextBox3.Name = "TextBox3";
this.TextBox3.Size = new System.Drawing.Size(135, 20);
this.TextBox3.TabIndex = 11;
//
// Label4
//
this.Label4.AutoSize = true;
this.Label4.Location = new System.Drawing.Point(6, 133);
this.Label4.Name = "Label4";
this.Label4.Size = new System.Drawing.Size(39, 13);
this.Label4.TabIndex = 10;
this.Label4.Text = "Label4";
//
// Button2
//
this.Button2.Location = new System.Drawing.Point(184, 45);
this.Button2.Name = "Button2";
this.Button2.Size = new System.Drawing.Size(100, 23);
this.Button2.TabIndex = 7;
this.Button2.Text = "Save to XLS";
this.Button2.UseVisualStyleBackColor = true;
this.Button2.Click += new System.EventHandler(this.Button2_Click);
//
// Button4
//
this.Button4.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(204)));
this.Button4.Location = new System.Drawing.Point(9, 175);
this.Button4.Name = "Button4";
this.Button4.Size = new System.Drawing.Size(135, 23);
this.Button4.TabIndex = 14;
this.Button4.Text = "Recalculate";
this.Button4.UseVisualStyleBackColor = true;
this.Button4.Click += new System.EventHandler(this.Button4_Click);
//
// Button1
//
this.Button1.Location = new System.Drawing.Point(184, 16);
this.Button1.Name = "Button1";
this.Button1.Size = new System.Drawing.Size(100, 23);
this.Button1.TabIndex = 6;
this.Button1.Text = "Load from XLS";
this.Button1.UseVisualStyleBackColor = true;
this.Button1.Click += new System.EventHandler(this.Button1_Click);
//
// Button3
//
this.Button3.Location = new System.Drawing.Point(184, 74);
this.Button3.Name = "Button3";
this.Button3.Size = new System.Drawing.Size(100, 23);
this.Button3.TabIndex = 8;
this.Button3.Text = "View in Excel";
this.Button3.UseVisualStyleBackColor = true;
this.Button3.Click += new System.EventHandler(this.Button3_Click);
//
// TextBox4
//
this.TextBox4.Location = new System.Drawing.Point(9, 149);
this.TextBox4.Name = "TextBox4";
this.TextBox4.Size = new System.Drawing.Size(135, 20);
this.TextBox4.TabIndex = 13;
//
// Label5
//
this.Label5.Location = new System.Drawing.Point(9, 240);
this.Label5.Name = "Label5";
this.Label5.Size = new System.Drawing.Size(275, 113);
this.Label5.TabIndex = 9;
this.Label5.Text = resources.GetString("Label5.Text");
//
// TextBox2
//
this.TextBox2.Location = new System.Drawing.Point(9, 71);
this.TextBox2.Name = "TextBox2";
this.TextBox2.Size = new System.Drawing.Size(135, 20);
this.TextBox2.TabIndex = 9;
//
// Label2
//
this.Label2.AutoSize = true;
this.Label2.Location = new System.Drawing.Point(6, 55);
this.Label2.Name = "Label2";
this.Label2.Size = new System.Drawing.Size(39, 13);
this.Label2.TabIndex = 8;
this.Label2.Text = "Label2";
//
// GroupBox1
//
this.GroupBox1.Controls.Add(this.Button4);
this.GroupBox1.Controls.Add(this.TextBox4);
this.GroupBox1.Controls.Add(this.Label3);
this.GroupBox1.Controls.Add(this.TextBox3);
this.GroupBox1.Controls.Add(this.Label4);
this.GroupBox1.Controls.Add(this.TextBox2);
this.GroupBox1.Controls.Add(this.Label2);
this.GroupBox1.Controls.Add(this.TextBox1);
this.GroupBox1.Controls.Add(this.Label1);
this.GroupBox1.Location = new System.Drawing.Point(12, 10);
this.GroupBox1.Name = "GroupBox1";
this.GroupBox1.Size = new System.Drawing.Size(166, 212);
this.GroupBox1.TabIndex = 5;
this.GroupBox1.TabStop = false;
//
// TextBox1
//
this.TextBox1.Location = new System.Drawing.Point(9, 32);
this.TextBox1.Name = "TextBox1";
this.TextBox1.Size = new System.Drawing.Size(135, 20);
this.TextBox1.TabIndex = 7;
//
// Label1
//
this.Label1.AutoSize = true;
this.Label1.Location = new System.Drawing.Point(6, 16);
this.Label1.Name = "Label1";
this.Label1.Size = new System.Drawing.Size(39, 13);
this.Label1.TabIndex = 6;
this.Label1.Text = "Label1";
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(292, 362);
this.Controls.Add(this.Button2);
this.Controls.Add(this.Button1);
this.Controls.Add(this.Button3);
this.Controls.Add(this.Label5);
this.Controls.Add(this.GroupBox1);
this.Name = "Form1";
this.Text = "Form1";
this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.Form1_FormClosing);
this.Load += new System.EventHandler(this.Form1_Load);
this.GroupBox1.ResumeLayout(false);
this.GroupBox1.PerformLayout();
this.ResumeLayout(false);
}
#endregion
internal System.Windows.Forms.Label Label3;
internal System.Windows.Forms.TextBox TextBox3;
internal System.Windows.Forms.Label Label4;
internal System.Windows.Forms.Button Button2;
internal System.Windows.Forms.Button Button4;
internal System.Windows.Forms.Button Button1;
internal System.Windows.Forms.Button Button3;
internal System.Windows.Forms.TextBox TextBox4;
internal System.Windows.Forms.Label Label5;
internal System.Windows.Forms.TextBox TextBox2;
internal System.Windows.Forms.Label Label2;
internal System.Windows.Forms.GroupBox GroupBox1;
internal System.Windows.Forms.TextBox TextBox1;
internal System.Windows.Forms.Label Label1;
}
}
60 Day Free Trial or Visit ByteScout Data Extraction Suite Home Page
Explore ByteScout Data Extraction Suite Documentation
Explore Samples
Sign Up for ByteScout Data Extraction Suite Online Training
Get Your API Key
Explore Web API Docs
Explore Web API Samples
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Bytescout.Spreadsheet;
namespace SimpleDatabase
{
public partial class Form1 : Form
{
Spreadsheet _spreadsheet;
private void LoadXLS()
{
Worksheet worksheet;
_spreadsheet = new Spreadsheet();
_spreadsheet.LoadFromFile("Database.xls");
worksheet = _spreadsheet.Workbook.Worksheets[0];
Label1.Text = (string)worksheet.Cell("A1").Value;
TextBox1.Text = worksheet.Cell("A2").Value.ToString();
Label2.Text = (string)worksheet.Cell("B1").Value;
TextBox2.Text = worksheet.Cell("B2").Value.ToString();
Label3.Text = (string)worksheet.Cell("C1").Value;
TextBox3.Text = worksheet.Cell("C2").Formula;
Label4.Text = "Calculated value of C2";
worksheet.Cell("C2").Calculate();
TextBox4.Text = worksheet.Cell("C2").Value.ToString();
}
private void SaveXLS()
{
Worksheet worksheet;
worksheet = _spreadsheet.Workbook.Worksheets[0];
worksheet.Cell("A2").Value = System.Convert.ToInt32(TextBox1.Text);
worksheet.Cell("B2").Value = System.Convert.ToInt32(TextBox2.Text);
worksheet.Cell("C2").Formula = TextBox3.Text;
try
{
System.IO.File.Delete("Database.xls");
}
catch (Exception ex)
{
}
_spreadsheet.SaveAs("Database.xls");
}
public Form1()
{
InitializeComponent();
}
private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
SaveXLS();
_spreadsheet.Close();
}
private void ReCalculate()
{
Worksheet worksheet;
worksheet = _spreadsheet.Workbook.Worksheets[0];
worksheet.Cell("A2").Value = System.Convert.ToInt32(TextBox1.Text);
worksheet.Cell("B2").Value = System.Convert.ToInt32(TextBox2.Text);
worksheet.Cell("C2").Formula = TextBox3.Text;
worksheet.Cell("C2").Calculate();
TextBox4.Text = worksheet.Cell("C2").Value.ToString();
}
private void Button4_Click(object sender, EventArgs e)
{
ReCalculate();
}
private void Form1_Load(object sender, EventArgs e)
{
LoadXLS();
}
private void Button3_Click(object sender, EventArgs e)
{
// open in default spreadsheets viewer/editor
SaveXLS();
try
{
Process.Start("Database.xls");
}
catch
{
}
}
private void Button1_Click(object sender, EventArgs e)
{
LoadXLS();
MessageBox.Show("Loaded from Database.xls");
}
private void Button2_Click(object sender, EventArgs e)
{
SaveXLS();
MessageBox.Show("Saved into Database.xls");
}
}
}
60 Day Free Trial or Visit ByteScout Data Extraction Suite Home Page
Explore ByteScout Data Extraction Suite Documentation
Explore Samples
Sign Up for ByteScout Data Extraction Suite Online Training
Get Your API Key
Explore Web API Docs
Explore Web API Samples
using System;
using System.Collections.Generic;
using System.Windows.Forms;
namespace SimpleDatabase
{
static class Program
{
/// <summary>
/// The main entry point for the application.
/// </summary>
[STAThread]
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Form1());
}
}
}
60 Day Free Trial or Visit ByteScout Data Extraction Suite Home Page
Explore ByteScout Data Extraction Suite Documentation
Explore Samples
Sign Up for ByteScout Data Extraction Suite Online Training
Get Your API Key
Explore Web API Docs
Explore Web API Samples
60 Day Free Trial or Visit ByteScout Data Extraction Suite Home Page
Explore ByteScout Data Extraction Suite Documentation
Explore Samples
Sign Up for ByteScout Data Extraction Suite Online Training
Get Your API Key
Explore Web API Docs
Explore Web API Samples
also available as: