Create/copy worksheets in an Excel doc in a C# app

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Dan

    Create/copy worksheets in an Excel doc in a C# app

    I have a c# app that creates and Excel doc, I would like
    to know how to create new worksheets (tabs) in the excel
    doc using c#?
  • Nicholas Paldino [.NET/C# MVP]

    #2
    Re: Create/copy worksheets in an Excel doc in a C# app

    Dan,

    On the Worksheets object exposed by the Workbook object (through the
    Worksheets property), you can call the Add method to add a new Worksheet.

    Hope this helps.


    --
    - Nicholas Paldino [.NET/C# MVP]
    - mvp@spam.guard. caspershouse.co m

    "Dan" <dplocica@nabn. com> wrote in message
    news:09d701c394 a5$f9962ff0$a40 1280a@phx.gbl.. .[color=blue]
    > I have a c# app that creates and Excel doc, I would like
    > to know how to create new worksheets (tabs) in the excel
    > doc using c#?[/color]


    Comment

    Working...