Free Support Forum -

How to generate excel with multiple sheets


I have a list of html files, I want to generate the excel with multiple sheets for each html file.

Can you let me know, how I can do this?



Well, there is no automatic or sophisticated way to accomplish the task. Also, there is no automatic way options to do this in MS Excel (manually) either. So, you have to devise your own approach using your own code to do this. For example, you may try to open each HTML file via Aspose.Cells’ Workbook object. Instantiate a new (blank) target Workbook. Now copy worksheet from each source Workbook to your target Workbook. Finally save the target Excel file.

Hope, this helps a bit.