Read and Write Document Properties
Read Built-In Document Properties
Code Samples
//Open an excel file
XlsWorkbook workbook = new XlsWorkbook("book1.xls");
//Get author
string author = workbook.BuiltInDocumentProperties.Author;
//Get company
string company = workbook.BuiltInDocumentProperties.Company;
//Get subject
string subject = workbook.BuiltInDocumentProperties.Subject;
//Get keywords
string keywords = workbook.BuiltInDocumentProperties.Keywords;
//Get comments
string comments = workbook.BuiltInDocumentProperties.Comments;
'Open an excel file
Dim workbook As XlsWorkbook = New XlsWorkbook("C:\book1.xls")
'Get author
Dim author As string = workbook.BuiltInDocumentProperties.Author
'Get company
Dim company As string = workbook.BuiltInDocumentProperties.Company
'Get subject
Dim subject As string = workbook.BuiltInDocumentProperties.Subject
'Get keywords
Dim keywords As string = workbook.BuiltInDocumentProperties.Keywords
'Get comments
Dim comments As string = workbook.BuiltInDocumentProperties.Comments
Write Built-In Document Properties
Code Sampels
//Open an excel file
XlsWorkbook workbook = new XlsWorkbook("book1.xls");
//Set author
workbook.BuiltInDocumentProperties.Author = " Nasosoft Excel Writer";
//Set company
workbook.BuiltInDocumentProperties.Company = "Nasosoft Ltd.";
//Set subject
workbook.BuiltInDocumentProperties.Subject = "Nasosoft Excel for .NET";
//Set keywords
workbook.BuiltInDocumentProperties.Keywords = "Nasosoft Excel Component, Spreadsheet";
//Set comments
workbook.BuiltInDocumentProperties.Comments = "Nasosoft Excel for .NET";
workbook.Save("book1.xls")
'Open an excel file
Dim workbook As XlsWorkbook = New XlsWorkbook("C:\book1.xls")
'Set author
workbook.BuiltInDocumentProperties.Author = "Nasosoft Excel Writer"
'Set company
workbook.BuiltInDocumentProperties.Company = "Nasosoft Ltd."
'Set subject
workbook.BuiltInDocumentProperties.Subject = "Nasosoft Excel for .NET"
'Set keywords
workbook.BuiltInDocumentProperties.Keywords = "Nasosoft Excel Component, Spreadsheet"
'Set comments
workbook.BuiltInDocumentProperties.Comments = "Nasosoft Excel for .NET"
workbook.Save("book1.xls")