I am using Aspose.Cells for .NET
I want to run a routine which will create a new worksheet for each entry in a table - this is variable.
How can I dimension these in a loop eg I would want to create a sheet which would have a primary part of Sht and then add a numeric eg 2 or 3, to give the worksheet an ID of Sht1, Sht2 etc.
In effect Dimensioning the worksheet based on a variable -
dim sht[variable] as Aspose.Cells.Worksheet = wb.Worksheets(variable)
dim sht[variable+1] as Aspose.Cells.Worksheet = wb.Worksheets(variable+1)
Can you please advise