Free Support Forum - aspose.com

How to add more than one sheet in excel using aspose.cells?

how to add more than one sheet in workbook excel using aspose.cells?

for example:

sheet1

sheet2

sheet3

Hi,

Please download the latest version: Aspose.Cells for .NET (Latest Version)

See the code below, it adds new workbook with 1 default worksheet and then it adds 3 extra worksheets.

I have attached the output file.

C#


string path = @“F:\Shak-Data-RW\Downloads\output.xlsx”;


Workbook workbook = new Workbook();


//Add more sheets

workbook.Worksheets.Add();

workbook.Worksheets.Add();

workbook.Worksheets.Add();


workbook.Save(path);

Hi,

Moreover, we also recommend you to see the topic for your reference:
Manage Worksheets

Thank you.