Tab Color lost?

Aspose.Cells Product Family
1

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

2

Hi Rob,

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

Thank you.

3

Hi,

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

4

Nice!