Summary Revision Table
Contents of the Shared Workbook Revision Header part (revisionHeaders.xml).
Inside the summary table there is a revision header definition corresponding to the time of the edit:
<header guid="{902054C2-C7B5-48BA-BFB2-4D439D9758D6}" dateTime="2006-04-14T10:33:16" maxSheetId="4" userName="User 1" r:id="rId2" minRId="1" maxRId="11"> <sheetIdMap count="3"> <sheetId val="1"/> <sheetId val="2"/> <sheetId val="3"/> </sheetIdMap> </header>
Notice that the user name, @userName
, and date and time stamp, @dateTime
, for the edit is stored along with an outline of the sheet structure. Use the @r:id
value of rId2
and then follow the relationship expressed in revisionHeaders.xml.rels. In this way, the corresponding Shared Workbook Revision Log can be located.