Skip to main content

CSharp: Add Graphical Content inside Excel spreadsheet

In this blog post, I will show you how to add an image (certificate) inside an Excel sheet using OpenXML package in C# DotNet Framework. This is a useful technique when you need to insert some graphical elements into your spreadsheet, such as logos, charts, or certificates.

CSharp: Add Graphical Content inside Excel spreadsheet

The basic steps are:
  1. Create a spreadsheet document or open an existing one.
  2. Add a worksheet part to the document or get an existing one by name.
  3. Add a drawings part to the worksheet part and create a worksheet drawing object.
  4. Add an image part to the drawings part and load the image (certificate) from a file or a stream.
  5. Add a non-visual drawing properties object to the worksheet drawing object and set its attributes, such as id, name, and description.
  6. Add a picture object to the worksheet drawing object and set its attributes, such as id, name, and description.
  7. Add a shape properties object to the picture object and set its transform properties, such as offset and extent.
  8. Add a picture fill object to the shape properties object and set its image reference.
  9. Add a two-cell anchor object to the worksheet drawing object and set its attributes, such as editAs, from, and to.
  10. Append the picture object to the two-cell anchor object and append the two-cell anchor object to the worksheet drawing object.
The following code snippet illustrates how to implement these steps using OpenXML:


Labels:
Location: Indore, Madhya Pradesh, India

Comments

Post a Comment

Popular posts from this blog

GitHub Copilot: An AI programming partner

GitLab Copilot: What You Need to Know GitLab Copilot is a new feature that aims to help developers write better code faster and easier. It is powered by OpenAI Codex, a deep learning system that can generate natural language and code from a few words or a comment. GitLab Copilot can suggest code snippets, refactor existing code, write tests, and even generate documentation. But how does GitLab Copilot work, and what are its pros and cons? In this blog post, I will give you a brief overview of GitLab Copilot, its benefits and drawbacks, and some tips on how to use it effectively. How GitLab Copilot Works GitLab Copilot is integrated with GitLab's web IDE, which means you can access it from any browser without installing anything. To use GitLab Copilot, you simply type a comment or a few words describing what you want to do, and press Ctrl+Enter. GitLab Copilot will then generate one or more code suggestions that you can accept, reject, or edit. GitLab Copilot uses OpenAI Codex as it...
Post a Comment
Read more

C#: Create Connection to SharePoint and Dynamic 365

How to Create Connection to SharePoint and Dynamic CRM using C#. Connection establish in SharePoint using C# Reference DLL you need for this code is -  Microsoft.SharePoint.Client.Latest by Trujillo Microsoft.SharePoint.Client.Runtime by Trujillo Below mention is c# code - public static string SharePointUrl = "https://CompanyName.sharepoint.com/"; public static string UserName = "UserName@CompanyName.onmicrosoft.com", PassWord = "o365_Password"; static void Main(string[] args) { //----------Establish a connection with Microsoft SharePoint. SecureString passWord = new SecureString(); foreach (char c in PassWord.ToCharArray()) passWord.AppendChar(c); using (ClientContext clientContext = new ClientContext(SharePointUrl)) { try { clientContext.Credentials = new SharePointOnlineCredentials(UserName, passWord); } catch (Exception ex) { Console.WriteLine("erro...
Post a Comment
Read more