Forums

Overview » C# » Add Worksheet in Workbook with C#

Add Worksheet in Workbook with C#
Lemon Brown Member Since: 15 Sep 2011 Posts: 89	Posted 09 Dec 2011 05:52:53 Generally speaking, one Excel workbook present three worksheets by default. Sometimes, we need more sheets in one workbook. Then, the following code shows how to add a new worksheet in Excel by using C#. Note: it bases on Spire.XLS. Therefore, I have added Spire.XLS DLL as reference. Coding: using System.Drawing; using Spire.Xls; namespace AddSheet { class Program { static void Main(string[] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile(@"..\..\parts.xlsx"); //add one worksheet to workbook workbook.CreateEmptySheet("NewSheet"); //set the new sheet context and style Worksheet sheet = workbook.Worksheets[1]; sheet.Range["A1"].Text="This is a new sheet"; sheet.Range["A1:C2"].Merge(); sheet.Range["A1"].Style.Font.Size = 12; sheet.Range["A1"].Style.Font.IsBold = true; sheet.Range["A1"].Style.Font.Color = Color.Red; sheet.Range["A1"].HorizontalAlignment = HorizontalAlignType.Center; sheet.Range["A1"].VerticalAlignment = VerticalAlignType.Center; workbook.SaveToFile("sample.xlsx", ExcelVersion.Version2007); System.Diagnostics.Process.Start(workbook.FileName); } } } Generally speaking, one Excel workbook present three worksheets by default. Sometimes, we need more sheets in one workbook. Then, the following code shows how to add a new worksheet in Excel by using C#. Note: it bases on Spire.XLS. Therefore, I have added Spire.XLS DLL as reference. Coding: using System.Drawing; using Spire.Xls; namespace AddSheet { class Program { static void Main(string[] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile(@"..\..\parts.xlsx"); //add one worksheet to workbook workbook.CreateEmptySheet("NewSheet"); //set the new sheet context and style Worksheet sheet = workbook.Worksheets[1]; sheet.Range["A1"].Text="This is a new sheet"; sheet.Range["A1:C2"].Merge(); sheet.Range["A1"].Style.Font.Size = 12; sheet.Range["A1"].Style.Font.IsBold = true; sheet.Range["A1"].Style.Font.Color = Color.Red; sheet.Range["A1"].HorizontalAlignment = HorizontalAlignType.Center; sheet.Range["A1"].VerticalAlignment = VerticalAlignType.Center; workbook.SaveToFile("sample.xlsx", ExcelVersion.Version2007); System.Diagnostics.Process.Start(workbook.FileName); } } }

Add Worksheet in Workbook with C#

Since: 15 Sep 2011
Posts: 89

Posted 09 Dec 2011 05:52:53

Generally speaking, one Excel workbook present three worksheets by default. Sometimes, we need more sheets in one workbook. Then, the following code shows how to add a new worksheet in Excel by using C#.

Note: it bases on Spire.XLS. Therefore, I have added Spire.XLS DLL as reference.

Coding:

using System.Drawing;
using Spire.Xls;

namespace AddSheet
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\parts.xlsx");

            //add one worksheet to workbook
            workbook.CreateEmptySheet("NewSheet");
            
           //set the new sheet context and style
            Worksheet sheet = workbook.Worksheets[1];
            sheet.Range["A1"].Text="This is a new sheet";
            sheet.Range["A1:C2"].Merge();
            sheet.Range["A1"].Style.Font.Size = 12;
            sheet.Range["A1"].Style.Font.IsBold = true;
            sheet.Range["A1"].Style.Font.Color = Color.Red;
            sheet.Range["A1"].HorizontalAlignment = HorizontalAlignType.Center;
            sheet.Range["A1"].VerticalAlignment = VerticalAlignType.Center;
           
                 
            workbook.SaveToFile("sample.xlsx", ExcelVersion.Version2007);
            System.Diagnostics.Process.Start(workbook.FileName);

        }
    }
}

using System.Drawing;
using Spire.Xls;

namespace AddSheet
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"..\..\parts.xlsx");

            //add one worksheet to workbook
            workbook.CreateEmptySheet("NewSheet");
            
           //set the new sheet context and style
            Worksheet sheet = workbook.Worksheets[1];
            sheet.Range["A1"].Text="This is a new sheet";
            sheet.Range["A1:C2"].Merge();
            sheet.Range["A1"].Style.Font.Size = 12;
            sheet.Range["A1"].Style.Font.IsBold = true;
            sheet.Range["A1"].Style.Font.Color = Color.Red;
            sheet.Range["A1"].HorizontalAlignment = HorizontalAlignType.Center;
            sheet.Range["A1"].VerticalAlignment = VerticalAlignType.Center;
           
                 
            workbook.SaveToFile("sample.xlsx", ExcelVersion.Version2007);
            System.Diagnostics.Process.Start(workbook.FileName);

        }
    }
}

Reply to this topic

Message
Reply

Live Support

Main Sponsor

Visit All Zones

Latest Components

Our Sponsors

Featured E-Book

Design & Accessibility

Have you, as a web developer or designer ever been on sites where the site seems more of a puzzle then a tool to find the information you where looking for? Or are you looking to improve your web design skills? Then read on!

Design & Accessibility

This e-Book will teach you how to become a truly professional developer or designer. By taking usability and accessibility issues in account when designing your websites or applications you can make the difference and avoid a lot of (user) frustration.

Featured Article

Beyond Graphing

When a graph is drawn, the focus is kept on the actual underlying competing figures that constitute the graph. Sometimes it is difficult to make assumptions just by looking at these graphs. When looking at a geographical map of data you immediately see exactly where things are happening. This article presents a .NET geographical mapping solution that will illustrate a fairly simple way of implementing these maps.

Featured Book

Inside ASP.NET

Inside ASP.NET is a comprehensive guide to ASP.NET development using Microsoft's .NET development framework. This book presents information on the .NET framework that is of specific interest to Internet and intranet developers, and is split into the following sections: Introducing ASP.NET, Core ASP.NET, ASP.NET and Data Access, Advanced Technologies, Advanced Web Forms, and Putting It All Together

Each chapter tackles a specific area of ASP.NET development, first by giving a detailed overview, then presenting a series of code examples and walk-throughs that illustrate various applications of ASP.NET

Featured Component

3D Gal Slideshow Bndl

Get our best gallery and slideshow components in one bundle and save money! Our most popular components combined to form an amazing presentation team.