How to create a new worksheet in Excel file c#?

Total Post:110

Points:774

C# 
C#
 1711  View(s)
Ratings:
Rate this:
I am developing a demo application and i need to create a new worksheet in Excel using C#.
Please help.
  1. Re: How to create a new worksheet in Excel file c#?

    Hi Jayden,


    var xlSheets = xlWorkBook.Sheets as Excel.Sheets;

    var xlNewSheet = (Excel.Worksheet)xlSheets.Add(xlSheets[1], Type.Missing, Type.Missing, Type.Missing);

    xlNewSheet.Name = "newsheet";

      Modified On Apr-03-2018 05:56:53 AM

Answer

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.