public virtual bool IsValidExcel(byte[] xlsBuffer, ExcelMetadata metadata)
{
var workbook = new Workbook(new MemoryStream(xlsBuffer));
var property = workbook.BuiltInDocumentProperties;
return(metadata.Keywords == property.Keywords &&
metadata.RevisionNumber == metadata.RevisionNumber &&
metadata.Author == property.Author &&
metadata.Company == property.Company);
}
public virtual ExcelMetadata GetMetadataByKey(string key)
{
var fileBuffer = GetExcelTemplateFile(key);
var workbook = new Workbook(new MemoryStream(fileBuffer));
var property = workbook.BuiltInDocumentProperties;
var metadata = new ExcelMetadata
{
Author = property.Author,
Company = property.Company,
Keywords = property.Keywords,
RevisionNumber = property.RevisionNumber,
FileBuffer = fileBuffer,
};
workbook = null;
return(metadata);
}
