How to Add Textbox to an Excel Chart in WPF

In some cases, we may need to add some textboxes to a chart in excel. While Spire.XLS provides us an easy solution to add textbox to an excel chart. This article will demonstrate how to add a textbox with borderline and a textbox without borderline to an excel chart in WPF using Spire.XLS in WPF.

Detail Steps and Code Snippets:

Use namespace:

using System.Windows;
using Spire.Xls;
using Spire.Xls.Core.Spreadsheet.Shapes;

Step 1: Create an excel workbook and get its first worksheet.

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

Step 2: Add a blank chart to the first worksheet.

Chart chart = sheet.Charts.Add();

Step 3: Add textboxes to the chart.

Invoking ITextBoxes.AddTextBox(int row, int column, int height, int width) method to add a textbox with borderline to the chart, then add some text to the textbox.

XlsTextBoxShape textbox = chart.TextBoxes.AddTextBox(50, 100, 100, 300) as XlsTextBoxShape;
textbox.Text = "Textbox with borderline";

However, Spire.XLS also enables us to add textbox without borderline to an excel chart by setting the line weight of the textbox to zero:

XlsTextBoxShape textbox1 = chart.TextBoxes.AddTextBox(300, 100, 100, 300) as XlsTextBoxShape;
textbox1.Text = "Textbox without borderline";
textbox1.Line.Weight = 0;

Step 4: Save and launch the file.

workbook.SaveToFile("AddTextbox.xlsx", ExcelVersion.Version2010);
System.Diagnostics.Process.Start("AddTextbox.xlsx");

Effective screenshot:

How to Add Textbox to an Excel Chart in WPF

Full codes:

using Spire.Xls;
using Spire.Xls.Core.Spreadsheet.Shapes;
using System.Windows;

namespace WpfApplication1
{
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }
        private void button2_Click(object sender, RoutedEventArgs e)
        {
            Workbook workbook = new Workbook();
            Worksheet sheet = workbook.Worksheets[0];

            //Add Chart
            Chart chart = sheet.Charts.Add();

            //Add Textbox with Borderline
            XlsTextBoxShape textbox = chart.TextBoxes.AddTextBox(50, 100, 100, 300) as XlsTextBoxShape;
            textbox.Text = "Textbox with borderline";

            //Add Textbox without Borderline
            XlsTextBoxShape textbox1 = chart.TextBoxes.AddTextBox(300, 100, 100, 300) as XlsTextBoxShape;
            textbox1.Text = "Textbox without borderline";
            textbox1.Line.Weight = 0;

            //Save and Launch the File
            workbook.SaveToFile("AddTextbox.xlsx", ExcelVersion.Version2010);
            System.Diagnostics.Process.Start("AddTextbox.xlsx");
        }
    }
}

How to Add Textbox to an Excel Chart in WPF

See Also