ByteScout Barcode Suite - C# - Calculations and spreadsheet as database with spreadsheet sdk - ByteScout

ByteScout Barcode Suite – C# – Calculations and spreadsheet as database with spreadsheet sdk

  • Home
  • /
  • Articles
  • /
  • ByteScout Barcode Suite – C# – Calculations and spreadsheet as database with spreadsheet sdk

calculations and spreadsheet as database with spreadsheet sdk in C# with ByteScout Barcode Suite

calculations and spreadsheet as database with spreadsheet sdk in C#

These source code samples are assembled by their programming language and functions they use. ByteScout Barcode Suite helps with calculations and spreadsheet as database with spreadsheet sdk in C#. ByteScout Barcode Suite is the bundle that privides 3 SDK products to generate barcodes (Barcode SDK), read barcodes (Barcode Reaer SDK) and read and write spreadsheets (Spreadsheet SDK).

Want to speed up the application development? Then this C#, code samples for C#, developers help to speed up the application development and writing a code when using ByteScout Barcode Suite. 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.

ByteScout Barcode Suite is available as a free trial. You may get it from our website along with all other source code samples for C# applications.

On-demand (REST Web API) version:
 Web API (on-demand version)

On-premise offline SDK for Windows:
 60 Day Free Trial (on-premise)

Form1.Designer.cs
      
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; } }

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Barcode Suite Home Page

Explore ByteScout Barcode Suite Documentation

Explore Samples

Sign Up for ByteScout Barcode Suite Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

Form1.cs
      
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"); } } }

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Barcode Suite Home Page

Explore ByteScout Barcode Suite Documentation

Explore Samples

Sign Up for ByteScout Barcode Suite Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

Program.cs
      
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()); } } }

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Barcode Suite Home Page

Explore ByteScout Barcode Suite Documentation

Explore Samples

Sign Up for ByteScout Barcode Suite Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

VIDEO

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Barcode Suite Home Page

Explore ByteScout Barcode Suite Documentation

Explore Samples

Sign Up for ByteScout Barcode Suite Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

Tutorials:

prev
next