/// <summary>
/// 获取Excel工作簿文档属性
/// </summary>
/// <param name="key"></param>
/// <returns></returns>
public object GetWorkbookDocementProperties(string key)
{
var collection = Workbook.Worksheets.BuiltInDocumentProperties;
if (collection.Contains(key))
{
DocumentProperty doc = collection[key];
switch (doc.Type)
{
case PropertyType.Boolean:
return(doc.ToBool());
case PropertyType.DateTime:
return(doc.ToDateTime());
case PropertyType.Double:
return(doc.ToDouble());
case PropertyType.Number:
return(doc.ToInt());
case PropertyType.String:
return(doc.ToString());
default:
return(null);
}
}
return(null);
}
