title: How to access the Date Last Saved property from a memory stream of excel workbook C#
body: <p>I have a method that takes a saved .xlsx file as a byteArray input &amp; will out put a datatable of the content with an additional column displaying the last modified date.</p>
  
  <p>I'm unable to retrieve the "Date Last Saved".</p>
  
  <p>I can see the date created, but this changes when the file gets updated &amp; I need to capture this property.</p>
  
  <p>'''</p>
  
  <pre><code>public DataTable Transform_closed_XML(byte[] dataBytesArray)
          {
              logger.LogInformation("XLSX Transform");
  
              using (MemoryStream stream = new MemoryStream(dataBytesArray))
              {
  
                  MemoryStream stream_xlsx = XLSXTransformerHelper.XLSX_Formatter(stream);           
  
  
                  var workBook = new XLWorkbook(stream_xlsx);
  
                  var pubDate = workBook.Properties.Created; //content created time
                  var LastSaved= workBook.Properties.Modified; // this just returns "{01/01/0001 
                   00:00:00}"
  
                   ...
  </code></pre>
  
  <p>'''</p>
  
  <p>Excel Interop &amp; System.Io work arounds to access this property involve opening an excel file using a file path. I just want to do this directly from the stream.</p>
  
  <p>Any pointers would be much appreciated.</p>
  
  <p>Thanks</p>