We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Tab Color lost?

I have a simple test XLSM file that I am populating and saving as a new filename. It appears that the tab color is lost on the save. Am I doing something wrong?

Dim _book As Workbook = New Workbook

_book.Open("book1.xlsm", FileFormatType.Excel2007Xlsm)


Const _fileName As String = "book1_populated.xlsm"
If My.Computer.FileSystem.FileExists(_fileName) Then
My.Computer.FileSystem.DeleteFile(_fileName)
End If

_book.Save(_fileName, FileFormatType.Excel2007Xlsm)

Thanks,

Rob

Hi Rob,

Well, the feature is not supported for .xlsm MS Excel 2007 files, we will support it soon for your need.

Thank you.

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for Considering Aspose.

Please try the attached latest fix. We have supported to get and assign the tab color in Excel 2007 file.

Thank you & Best Regards

Nice!