Free Support Forum -

How many worksheets can be add in evaluation?

Hi,I want to ask a question:

How many worksheets can be add throung the two methods: int index=excel.Worksheets.Add();

excel.Worksheets[index].Copy(sheet) .

If the version of evaluation have limits for this?

Because when the worksheets i add throught these two methods more than a amount the new worksheet can not be produced.

There are at most 65536 worksheets in an Excel file if you have enough memory.

What's the problem when you create worksheets more than an amount?

I use the two methods to add worksheets in my code with a template,but a worksheet can not be produced normal,although the code can run without error.

Please post your template file and whole sample code here.

Sorry,the question has been resolved,it’s my mistake.thank’s for your reply.