We have demonstrated how to insert textbox to Excel worksheet in C#. Starts from Spire.XLS v7.11.1, we have add a new method of chart.Shapes.AddOval(left,top,right,bottom); to enable developers to add oval shape to excel chart directly. Developers can also add the text contents to the oval shape and format the style for the oval. This article will describe clearly how to insert oval shape to Excel chart in C#.

Step 1: Create a workbook and get the first worksheet from the workbook.

Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];

Step 2: Add a chart to the worksheet.

Chart chart = sheet.Charts.Add();

Step 3: Add oval shape to Excel chart.

var shape = chart.Shapes.AddOval(20, 60, 500,400);

Step 4: Add the text to the oval shape and set the text alignment on the shape.

shape.Text = "Oval Shape added by Spire.XLS";
shape.HAlignment = CommentHAlignType.Center;
shape.VAlignment = CommentVAlignType.Center;

Step 5: Format the color for the oval shape.

((XlsOvalShape)shape).Line.ForeColor = Color.Blue;
((XlsOvalShape)shape).Fill.ForeColor = Color.Green;

Step 6: Save the document to file.

workbook.SaveToFile("Result.xlsx",ExcelVersion.Version2010);

Effective screenshot of Oval shape added to the Excel chart:

Full codes:

using Spire.Xls;
using Spire.Xls.Core.Spreadsheet.Shapes;
using System.Drawing;
namespace AddOvalShape
{

    class Program
    {

        static void Main(string[] args)
        {
            {
                Workbook workbook = new Workbook();

                Worksheet sheet = workbook.Worksheets[0];

                Chart chart = sheet.Charts.Add();

                var shape = chart.Shapes.AddOval(20, 60, 500, 400);

                shape.Text = "Oval Shape added by Spire.XLS";

                shape.HAlignment = CommentHAlignType.Center;
                shape.VAlignment = CommentVAlignType.Center;

                ((XlsOvalShape)shape).Line.ForeColor = Color.Blue;
                ((XlsOvalShape)shape).Fill.ForeColor = Color.Green;

                workbook.SaveToFile("Result.xlsx", ExcelVersion.Version2010);

            }
        }
    }
}

SVG, short for scalable vector graphics, is a XML-based file format used to depict two-dimensional vector graphics. As SVG images are defined in XML text lines, they can be easily searched, indexed, scripted, and supported by most of the up to date web browsers. Therefore, office documents are often converted to SGV images for high fidelity viewing. Following sections will introduce how to convert PowerPoint documents to SVG images using Spire.Presentation in C# and VB.NET.

Code Snippet:

Step 1: Initialize an instance of Presentation class and load a sample PowerPoint document to it.

Presentation ppt = new Presentation();
ppt.LoadFromFile(@"C:\Users\Administrator\Desktop\sample.pptx");

Step 2: Convert PowerPoint document to byte array and store in a Queue object.

 Queue<Byte[]> svgBytes = ppt.SaveToSVG();

Step 3: Initialize an instance of the FileStream class with the specified file path and creation mode. Dequeue the data in the Queue object and write to the stream.

int len = svgBytes.Count;
for (int i = 0; i < len; i++)
{
    FileStream fs = new FileStream(string.Format("result" + "{0}.svg", i), FileMode.Create);
    byte[] bytes = svgBytes.Dequeue();
    fs.Write(bytes, 0, bytes.Length);
}

Output:

Full Code:

using Spire.Presentation;
using System;
using System.Collections.Generic;
using System.IO;
namespace PPTtoSVG
{
    class Program
    {
        static void Main(string[] args)
        {
            Presentation ppt = new Presentation();
            ppt.LoadFromFile(@"C:\Users\Administrator\Desktop\sample.pptx");
            Queue<byte[]> svgBytes = ppt.SaveToSVG();
            int len = svgBytes.Count;
            for (int i = 0; i < len; i++)
            {
                FileStream fs = new FileStream(string.Format("result" + "{0}.svg", i), FileMode.Create);
                byte[] bytes = svgBytes.Dequeue();
                fs.Write(bytes, 0, bytes.Length);
                ppt.Dispose();
            }
        }
    }
}

Imports Spire.Presentation
Imports System.Collections.Generic
Imports System.IO
Namespace PPTtoSVG
	Class Program
		Private Shared Sub Main(args As String())
			Dim ppt As New Presentation()
			ppt.LoadFromFile("C:\Users\Administrator\Desktop\sample.pptx")
			Dim svgBytes As Queue(Of [Byte]()) = ppt.SaveToSVG()
			Dim len As Integer = svgBytes.Count
			For i As Integer = 0 To len - 1
				Dim fs As New FileStream(String.Format("result" + "{0}.svg", i), FileMode.Create)
				Dim bytes As Byte() = svgBytes.Dequeue()
				fs.Write(bytes, 0, bytes.Length)
				ppt.Dispose()
			Next
		End Sub
	End Class
End Namespace

SVG, short for Scalable Vector Graphics, is a web-friendly vector image format. SVG has many advantages over other image formats. One of the most significant advantages is resolution independence, which means you can resize SVG images as needed without losing image quality. Sometimes, you may need to convert Excel files to SVG for web viewing. This article will demonstrate how to programmatically convert Excel to SVG in C# and VB.NET using Spire.XLS for .NET.

• Convert an Excel Worksheet to SVG
• Convert an Excel Chart Sheet to SVG

Install Spire.XLS for .NET

To begin with, you need to add the DLL files included in the Spire.XLS for .NET package as references in your .NET project. The DLL files can be either downloaded from this link or installed via NuGet.

PM> Install-Package Spire.XLS

Convert an Excel Worksheet to SVG using C# and VB.NET

Spire.XLS provides the Worksheet.SaveToSVGStream() method to convert an Excel worksheet to SVG. The detailed steps are as follows:

• Initialize an instance of the Workbook class.
• Load an Excel file using Workbook.LoadFromFile() method.
• Get a specific worksheet by its index through Workbook.Worksheets[int] property.
• Initialize an instance of the FileStream class.
• Save the worksheet to SVG using Worksheet.ToSVGStream(Stream, int, int, int, int) method.

using Spire.Xls;
using System.IO;

namespace ConvertWorksheetToSVG
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create an instance of Workbook class
            Workbook workbook = new Workbook();
            //Load an Excel file
            workbook.LoadFromFile("Sample1.xlsx");

            //Get the first worksheet
            Worksheet sheet = workbook.Worksheets[0];

            //Create an instance of FileStream class
            FileStream fs = new FileStream("E:\\Program Files\\WorksheetToSVG.svg", FileMode.Create);
            //Save the worksheet to SVG
            sheet.ToSVGStream(fs, 0, 0, 0, 0);
            fs.Flush();
            fs.Close();            
        }
    }
}

Imports Spire.Xls
Imports System.IO

Namespace ConvertWorksheetToSVG
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Create an instance of Workbook class
            Dim workbook As Workbook = New Workbook()
            'Load an Excel file
            workbook.LoadFromFile("Sample1.xlsx")

            'Get the first worksheet
            Dim sheet As Worksheet = workbook.Worksheets(0)

            'Create an instance of FileStream class
            Dim fs As FileStream = New FileStream("E:\Program Files\WorksheetToSVG.svg", FileMode.Create)
            'Save the worksheet to SVG
            sheet.ToSVGStream(fs, 0, 0, 0, 0)
            fs.Flush()
            fs.Close()
        End Sub
    End Class
End Namespace

Convert an Excel Chart Sheet to SVG using C# and VB.NET

A chart sheet is a worksheet that only contains a chart. Spire.XLS allows you to convert a chart sheet to SVG by using the ChartSheet.ToSVGStream() method. The detailed steps are as follows:

• Initialize an instance of the Workbook class.
• Load an Excel file using Workbook.LoadFromFile() method.
• Get a specific chart sheet by its index through Workbook.Chartsheets[int] property.
• Initialize an instance of the FileStream class.
• Save the chart sheet to SVG using ChartSheet.ToSVGStream(Stream) method.

using Spire.Xls;
using System.IO;

namespace ConvertChartSheetToSVG
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create an instance of Workbook class
            Workbook workbook = new Workbook();
            //Load an Excel file
            workbook.LoadFromFile("Sample2.xlsx");

            //Get the first chart sheet
            ChartSheet chartSheet = workbook.Chartsheets[0];

            //Create an instance of FileStream class
            FileStream fs = new FileStream("E:\\ProgramFiles\\ChartSheetToSVG.svg", FileMode.Create);
            //Save the chart sheet to SVG
            chartSheet.ToSVGStream(fs);
            fs.Flush();
            fs.Close();
        }
    }
}

Imports Spire.Xls
Imports System.IO

Namespace ConvertChartSheetToSVG
    Friend Class Program
        Private Shared Sub Main(ByVal args As String())
            'Create an instance of Workbook class
            Dim workbook As Workbook = New Workbook()
            'Load an Excel file
            workbook.LoadFromFile("Sample2.xlsx")

            'Get the first chart sheet
            Dim chartSheet As ChartSheet = workbook.Chartsheets(0)

            'Create an instance of FileStream class
            Dim fs As FileStream = New FileStream("E:\ProgramFiles\ChartSheetToSVG.svg", FileMode.Create)
            'Save the chart sheet to SVG
            chartSheet.ToSVGStream(fs)
            fs.Flush()
            fs.Close()
        End Sub
    End Class
End Namespace

Apply for a Temporary License

If you'd like to remove the evaluation message from the generated documents, or to get rid of the function limitations, please request a 30-day trial license for yourself.