Document Management in the Spreadsheet

• Sep 09, 2024

The Spreadsheet control always contains a document. When you open a document, the control loads it to storage in the web server’s memory (RAM). This storage is a static dictionary inaccessible to developers.

The Spreadsheet uses unique strings to identify documents in the storage. The way a document gets its identifier depends on the document source:

• When you open a document from a file system, the control uses the physical path to this document as the identifier.
• When you open a document from a byte array or stream, you pass an identifier as a method parameter.
• A new document has an empty identifier. Generate a unique string identifier for the new document to be able to save pending changes.

The document remains in server memory until one of the following events:

• Your code closes the document.
• The server is restarted. Until this event, the document takes up memory even if this document is not being used for a long time.
• The DocumentManager hibernates the document. Enable document hibernation to reduce server memory consumption and prevent the loss of unsaved changes when the server is restarted.