How to modify "Comment" and other properties of an Excel file?

[Swetaketu Majumder]

Hi,

I would like to modify these properties of an excel file using XlsIO. I could not find a way to achieve that in the online documentation. Kindly help.

Thanks and regards,

Swetaketu

[Abirami Varadharajan]

Hi Swetaketu, 

 

Thank you for contacting Syncfusion support. 

 

We request you to modify the required properties by accessing BuiltInDocumentProperties. Kindly refer below code to achieve the same. 

 

Code Example:  

            IBuiltInDocumentProperties documentproperty = workbook.BuiltInDocumentProperties; 

            documentproperty.Title = "Title Modifed"; 

            documentproperty.Subject = "Subject Modified"; 

            documentproperty.Comments = "Comments Added"; 

            documentproperty.Keywords = "Tags Modified"; 

            documentproperty.Category = "Category Added"; 

 

We have also shared sample for your reference and the sample can be downloaded from the following link. 

 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample-1971636204.zip  

 

Kindly refer and let us know that your requirement is fulfilled. 

 

Regards, 

Abirami. 

[Swetaketu Majumder]

Hi Abirami,

Thank you. I was able to modify the properties.

Regards,

Swetaketu

[Abirami Varadharajan]

Hi Swetaketu, 

 

Thank you for updating us.  

 

We are glad that your requirement is fulfilled. Please let us know if you need any further assistance. 

 

Regards, 

Abirami.