ByteScout Data Extraction Suite – C# – Add images advanced with spreadsheet sdk

Home
/
Articles
/
ByteScout Data Extraction Suite – C# – Add images advanced with spreadsheet sdk

printable version:
ByteScout-Data-Extraction-Suite-C-sharp-Add-images-advanced-with-spreadsheet-sdk.pdf

How to add images advanced with spreadsheet sdk in C# with ByteScout Data Extraction Suite

Learn to code in C# to add images advanced with spreadsheet sdk with this step-by-step tutorial

ByteScout simple and easy to understand tutorials are planned to describe the code for both C# beginners and advanced programmers. ByteScout Data Extraction Suite is the bundle that includes three SDK tools for data extraction from PDF, scans, images and from spreadsheets: PDF Extractor SDK, Data Extraction SDK, Barcode Reader SDK and you can use it to add images advanced with spreadsheet sdk with C#.

Want to save time? You will save a lot of time on writing and testing code as you may just take the C# code from ByteScout Data Extraction Suite for add images advanced with spreadsheet sdk below and use it in your application. IF you want to implement the functionality, just copy and paste this code for C# below into your code editor with your app, compile and run your application. Enjoy writing a code with ready-to-use sample codes in C#.

ByteScout Data Extraction Suite free trial version is available on our website. C# and other programming languages are supported.

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

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

Program.cs

      using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.IO;
using System.Text;
using Bytescout.Spreadsheet;
using Bytescout.Spreadsheet.MSODrawing;

namespace AddImages
{
	class Program
	{
		static void Main(string[] args)
		{
			// Create spreadsheet
			Spreadsheet doc = new Spreadsheet();
			// Add worksheet
			Worksheet worksheet = doc.Worksheets.Add();

			// Put an image to "C3" cell
			PictureShape shape = worksheet.Pictures.Add(2, 2, "image1.jpg");

            // Make the picture "floating". It will be not moved if you move or resize the "C3" cell
			shape.PlacementType = Placement.FreeFloating;

			// Make the picture brighter
			shape.Brightness = 0.8f;

			// Put second image to "K11" cell
			shape = worksheet.Pictures.Add(10, 10, "image2.jpg");

			// Make the picture bound to the cell. It will be moved alonf with the "K11" cell
			shape.PlacementType = Placement.Move;

			// Crop 10% from left and right side of the image
			shape.CropFromLeft = 0.1f;
			shape.CropFromRight = 0.1f;

			// Delete output file if exists
			if (File.Exists("output.xls"))
			{
				File.Delete("output.xls");
			}

			// Save document
			doc.SaveAs("output.xls");

			// Close spreadsheet
			doc.Close();

			// Open generated XLS document in default application
			Process.Start("output.xls");

			doc.Dispose();
		}
	}
}