Currently our code is successfully converting a whole Excel workbook to aspose. However this is not what our clients want. They only want the sheets that they have set as Active in the workbook converting to the new aspose version, creating a new smaller aspose cells workbook.
The total number of sheets in the Excel sheet will be unknown as will the number and location of the Active sheets. Please can you help me with the code for this as I cant currently work out a way to loop through and find the active sheets to copy to a new workbook to save.
The working code we currently have to convert and save the entire workbook is as follows:
Dim oExcel As Aspose.Cells.Workbook
oExcel = New Workbook(sSrcFilePath)