L.2.10.3.1.1 Summary Revision Table
L.2.10.3.1.1 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.
Last updated on