summaryrefslogtreecommitdiffstats
path: root/sc/workben/cache.py
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-07 09:06:44 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-07 09:06:44 +0000
commited5640d8b587fbcfed7dd7967f3de04b37a76f26 (patch)
tree7a5f7c6c9d02226d7471cb3cc8fbbf631b415303 /sc/workben/cache.py
parentInitial commit. (diff)
downloadlibreoffice-ed5640d8b587fbcfed7dd7967f3de04b37a76f26.tar.xz
libreoffice-ed5640d8b587fbcfed7dd7967f3de04b37a76f26.zip
Adding upstream version 4:7.4.7.upstream/4%7.4.7upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'sc/workben/cache.py')
-rw-r--r--sc/workben/cache.py87
1 files changed, 87 insertions, 0 deletions
diff --git a/sc/workben/cache.py b/sc/workben/cache.py
new file mode 100644
index 000000000..ba96abe97
--- /dev/null
+++ b/sc/workben/cache.py
@@ -0,0 +1,87 @@
+# -*- Mode: python; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# License, v. 2.0. If a copy of the MPL was not distributed with this
+# file, You can obtain one at http://mozilla.org/MPL/2.0/.
+#
+
+import sys
+import struct
+
+column_block_type = {
+ 0 : "empty block",
+ 1 : "numeric block",
+ 2 : "string block"
+ }
+
+
+def parse_block(data, index):
+ start_row = struct.unpack('Q', data[index:index+8])[0]
+ index += 8
+ data_size = struct.unpack('Q', data[index:index+8])[0]
+ index += 8
+ block_type = struct.unpack('B', data[index:index+1])[0]
+ index += 1
+ vals = {}
+ if block_type == 1:
+ # numeric block
+ for i in range(data_size):
+ vals[start_row + i] = struct.unpack('d', data[index:index+8])[0]
+ index += 8
+ elif block_type == 2:
+ # string block
+ for i in range(data_size):
+ str_length = struct.unpack('i', data[index:index+4])[0]
+ index += 4
+ vals[start_row + i] = data[index:index+str_length].decode("utf-8")
+ index += str_length
+ elif block_type == 3:
+ # formula block
+ read_rows = 0
+ while read_rows < data_size:
+ formula_group_size = struct.unpack('Q', data[index:index+8])[0]
+ index += 8
+ str_length = struct.unpack('i', data[index:index+4])[0]
+ index += 4
+ vals[start_row + read_rows] = (data[index:index+str_length].decode("utf-8"), "formula group length %i"% formula_group_size)
+ read_rows += formula_group_size
+ index += str_length
+
+ return index, data_size, vals
+
+
+def parse_column(data, index):
+ column_index = struct.unpack('Q', data[index:index+8])[0]
+ index += 8
+ column_entries = struct.unpack('Q', data[index:index+8])[0]
+ index += 8
+ imported_columns = 0
+ column_values = {}
+ while imported_columns < column_entries:
+ index, block_size, vals = parse_block(data, index)
+ imported_columns += block_size
+ column_values.update(vals)
+ return index, column_values
+
+def parse_columns(data, index):
+ column_count = struct.unpack('Q', data[index:index+8])[0]
+ index += 8
+ columns = {}
+ for i in range(column_count):
+ index, column_values = parse_column(data, index)
+ columns[i] = column_values
+
+ return columns
+
+def main():
+ filename = sys.argv[1]
+ with open(filename, "rb") as f:
+ content = f.read()
+ index = 0
+ columns = parse_columns(content, index)
+ print(columns)
+
+if __name__ == "__main__":
+ main()
+
+# vim:set shiftwidth=4 softtabstop=4 expandtab: */