Free Support Forum - aspose.com

Missing worksheets when saving workbook to html

Hi;

I use workbook.Save(stream, FileFormatType.Html); to save the content to html format file. However, the file only contains one worksheet. Saving to PDF and Excel (Default) are fine. They contain all the 4 worksheets in the workbook. Please advise what I miss. Does saving to html need extra processing?

Thanks.

Regards,

Teh

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please save your workbook to html file. If you will save it to stream, only the active worksheet will be saved. It is the limitation of html format.

Or you can save your file to MHTML format too.

Hi;

In that case, how could I iterate through all the worksheets in the workbook and append them to the stream?

I don't find MHTML in FileFormatType enum defined in Aspose.Cells

Thanks.

Regards,

Teh

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

I am afraid, there is no good solution to it. You will have to save your workbook into file. Streams will not work as shared earlier.