Q:

Add new Worksheet c# (doubts)

I'm working with C# and Excel for the first time ... And I would like to know how can I add a new worksheet in a Workbook. I have been reading some posts but none works for me so I'm going to post my code.
Microsoft.Office.Interop.Excel.Application Excel = new Microsoft.Office.Interop.Excel.Application();
Excel.Workbooks.Add();
Microsoft.Office.Interop.Excel._Worksheet Worksheet = Excel.ActiveSheet;

And with this code I am working with my only Sheet, but now I want to add another one with MMPP name but I can't ...
After this I would like to make a dynamic table in the Worksheet MMPP.
Can you help me a little?
Thank you for read and try to help!

A:

You'll want to understand the object model. At a high level, it goes like this:

Application

Workbooks

Workbook

Sheets

Worksheet

Range

A Workbook object has two properties that expose a Sheets object: Sheets and Worksheets - the Sheets collection holds many types of sheets (Chart sheets, for example); if you want to be sure to get a Worksheet object, use the Worksheets collection.
To create a new worksheet, invoke the Add method of the Worksheets collection:
using Microsoft.Office.Interop.Excel;

var app = new Application;
var books = app.Workbooks; // grab a reference to the collection object; you'll want to clean it up later
var wb = books.Add();
var sheets = wb.Worksheets; // grab a reference to the collection object: you'll want to clean it up later
var sheet = sheets.Add();

Adding a worksheet will make that sheet the ActiveSheet, but you don't need to care for that - use your sheet object/variable to manipulate the new sheet.
The ListObjects property of your sheet is a collection of all named tables on the sheet, so similarly, you'd invoke sheet.ListObjects.Add to create a new ListObject on that sheet. Refer to the documentation, it's full of examples.

