Document
The Document Aptitude provides the ability to interact with documents (currently only XLSX files).
API
Example
Permissions

xlsxEncode

xlsxEncode provides ability to encode a workbook object into XLSX data. It returns A promise of Uint8Array.
1
import { document } from '@oliveai/ldk';
2
3
// Imagine that we have a workbook, that workbook contains a worksheet.
4
// To locate a single cell, we need the row numbner and cell number.
5
// We need a workbook object
6
const workbook = {
7
worksheets: [
8
{
9
hidden: false,
10
hiddenColumns: [],
11
hiddenRows: [],
12
name: 'name',
13
rows: [{ cells: [{ value: 'cell value' }] }],
14
},
15
],
16
};
17
const uint8ArrayData = await document.xlsxEncode(workbook);
Copied!

xlsxDecode

xlsxDecode Decodes uint8Array into a Workbook Object. It returns a promise of Workbook.
1
import { document } from '@oliveai/ldk';
2
3
// Decode Uint8Array to a Workbook Object.
4
// The uint8ArrayData is the same as the one we get from xlsxEncode method.
5
const workbook = document.xlsxDecode(uint8ArrayData);
Copied!
This is the structure of a workbook:
Workbook: {
worksheets: Worksheet[];
}
Worksheet: {
hidden: bolean;
// Representation of a basic workbook with a single sheet where some rows and columns are hidden
hiddenColumns: number[];
hiddenRows: number[];
name: string;
rows: Row[];
}
Row: {
cells:cell[];
}
Cell: {
value:string;
}
Imagine that you want to read a patient's workbook programmatically. A good way to achieve this is to convert a workbook into xlsx data, which is an Uint8Array if using xlsxEncode(). In this example we created a Workbook object for demonstration, but you can use any XLSX file (workbook file with .xlsx extension) to achieve this.
Let's look at an example to better illustrate the point.
1
import { document } from '@oliveai/ldk';
2
import { Workbook } from '@oliveai/ldk/dist/document/types';
3
4
// Create a workbook Object.
5
const workbook: Workbook = {
6
worksheets: [
7
{
8
hidden: false,
9
hiddenColumns: [],
10
hiddenRows: [],
11
name: 'Iron Man',
12
rows: [{ cells: [{ value: 'Age' }, {value: '48'}] }],
13
},
14
],
15
};
16
17
// Use xlseEncode to convert workbook Object to Uint8Array
18
const uint8ArrayData = document.xlsxEncode(JSON.stringify(workbook));
19
20
// Convert uint8Array data to workbook Object
21
const convertedWorkbook = document.xlsxDecode(uint8ArrayData);
22
23
// Check cell Data of converted workbook
24
const cellData = convertedWorkbook.worksheets[0].rows[0].cells[1].value;
25
console.log('workbook is:', JSON.stringify(workbook));
26
console.log('uint8ArrayData is: ', uint8ArrayData);
27
28
// The console log results are attached below
29
// workbook is: {"worksheets":[{"hidden":false,"hiddenColumns":[],"hiddenRows":[],"name":"Iron Man","rows":[{"cells":[{"value":"Age"},{"value":"48"}]}]}]}
30
// uint8ArrayData is: 80,75,3,4,20,0,8,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,19,0,0,0,91,67,111,110,116,101,110,116,95,84,121,112,101,115,93,46,120,109,108,172,148,207,110,212,48,16,198,239,60,69,228,43,90,123,219,3,66,40,73,15,252,57,66,37,202,3,24,123,146,88,107,123,172,153,233,146,125,123,148,100,187,66,5,170,68,221,75,124,137,191,223,207,254,172,169,239,198,20,171,35,16,7,204,141,186,209,123,85,65,118,232,67,238,27,245,227,225,203,238,189,170,88,108,246,54,98,134,70,157,128,213,93,251,166,126,56,21,224,106,76,49,115,163,6,145,242,193,24,118,3,36,203,26,11,228,49,197,14,41,89,97,141,212,155,98,221,193,246,96,110,247,251,119,198,97,22,200,178,147,41,67,181,245,183,35,16,5,15,213,189,37,249,106,19,52,202,140,209,200,0,9,150,239,141,30,83,84,213,199,101,227,196,110,148,45,37,6,103,37,96,54,199,236,159,81,119,216,117,193,129,71,247,152,32,139,158,99,222,78,41,109,109,158,128,255,69,179,156,34,240,171,161,92,8,172,231,1,64,82,212,75,232,106,135,95,72,135,159,136,135,107,91,76,171,78,54,228,117,38,30,221,61,97,97,99,75,121,181,10,140,2,217,131,223,21,194,2,36,97,237,125,92,44,28,18,108,215,56,63,63,61,237,222,204,62,119,49,95,28,155,121,185,221,174,240,98,41,151,252,213,70,60,88,2,255,93,40,228,254,234,15,245,207,236,191,141,62,65,103,31,163,84,159,167,50,151,185,65,16,121,155,192,83,35,4,113,254,135,135,80,46,172,51,225,159,168,151,143,250,60,192,204,115,170,253,29,0,0,255,255,80,75,7,8,232,197,0,177,95,1,0,0,231,4,0,0,80,75,3,4,20,0,8,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,19,0,0,0,120,108,47,116,104,101,109,101,47,116,104,101,109,101,49,46,120,109,108,236,153,207,111,219,54,20,199,239,251,43,8,222,87,201,63,100,199,65,149,34,177,227,118,107,210,22,141,219,161,199,103,137,150,88,83,164,64,210,73,124,27,218,211,46,3,6,116,195,46,3,118,219,97,24,86,96,5,86,236,178,63,38,64,139,173,251,35,6,73,142,77,218,116,155,46,238,208,13,181,15,17,169,207,123,252,242,61,242,81,114,174,94,59,205,24,58,38,82,81,193,67,92,187,226,99,68,120,36,98,202,147,16,223,27,244,63,222,194,72,105,224,49,48,193,73,136,167,68,225,107,59,31,93,133,109,157,146,140,160,211,140,113,181,13,33,78,181,206,183,61,79,69,41,201,64,93,17,57,225,167,25,27,9,153,129,86,87,132,76,188,88,194,9,229,73,198,188,186,239,183,188,12,40,199,136,67,70,66,124,123,52,162,17,65,131,194,37,222,57,119,190,207,72,70,184,86,69,71,196,228,81,84,142,104,90,148,108,60,174,21,127,212,84,117,153,68,199,192,66,124,66,121,44,78,6,228,84,99,196,64,233,46,147,33,246,203,15,246,118,174,122,115,35,166,215,216,26,118,253,242,51,179,155,25,196,227,122,105,39,147,225,220,176,217,12,154,173,221,185,255,122,229,127,149,219,111,239,183,246,91,115,127,37,0,81,68,248,76,139,201,6,123,157,189,94,48,99,13,168,186,116,248,238,181,123,141,154,197,27,254,27,43,252,110,80,124,45,190,177,224,155,43,124,191,223,93,196,208,128,170,203,192,17,147,118,189,219,180,248,96,193,183,86,248,182,191,219,107,182,45,190,132,82,70,249,120,133,246,131,86,163,123,62,219,57,50,18,236,134,19,239,4,205,126,187,62,195,23,148,103,172,174,202,158,235,117,107,45,131,135,66,246,5,215,101,114,65,83,142,244,52,39,35,136,72,136,187,192,232,80,82,116,64,147,84,99,148,3,23,138,132,216,175,251,125,191,225,215,203,111,179,188,42,35,2,219,4,12,235,170,43,82,43,93,133,30,164,34,73,115,29,226,79,115,224,216,64,94,60,127,126,246,232,217,217,163,95,207,30,63,62,123,244,243,108,236,85,187,27,192,19,211,238,213,15,95,253,245,221,231,232,207,95,190,127,245,228,107,55,175,76,254,229,79,95,188,252,237,247,215,185,215,150,172,111,158,190,124,246,244,197,183,95,254,241,227,19,7,190,43,97,104,226,3,154,17,133,110,145,19,116,87,100,192,93,3,144,161,124,59,139,65,10,212,178,128,84,100,224,0,247,117,106,129,183,166,192,92,220,30,177,67,120,95,82,30,187,192,235,147,135,150,214,163,84,78,52,117,128,55,211,204,2,15,133,96,123,66,58,167,115,179,24,203,156,206,132,39,238,193,229,196,228,238,2,28,187,198,238,46,37,120,127,146,167,36,163,46,151,221,148,88,50,239,48,224,26,18,194,137,70,197,61,49,38,196,97,246,128,82,43,174,135,52,146,66,137,145,70,15,40,218,3,234,12,201,128,14,181,219,232,6,205,128,193,212,37,112,144,130,21,155,195,251,104,79,48,151,251,30,57,182,73,224,9,48,151,75,194,172,48,94,135,137,134,204,169,24,50,102,146,7,160,83,151,200,163,169,140,172,128,43,45,129,39,132,9,180,31,19,165,92,54,183,229,212,146,123,19,24,117,167,253,144,77,51,155,148,154,142,93,228,1,8,97,146,61,49,238,166,144,229,78,205,148,167,38,251,137,26,11,193,0,221,17,218,41,66,216,59,164,104,11,70,129,175,77,247,125,74,244,219,109,235,123,52,73,221,11,164,184,51,145,174,45,65,132,189,31,167,108,4,164,116,238,45,149,244,140,242,55,214,247,165,202,30,252,59,149,221,93,116,55,80,211,221,224,101,170,249,174,164,206,61,181,92,195,215,113,255,193,202,221,131,9,191,67,120,234,66,63,20,238,15,133,251,127,95,184,215,237,229,205,151,235,69,133,246,42,67,227,201,61,91,251,224,62,162,140,29,233,41,35,7,170,172,237,74,48,26,247,41,99,101,163,52,154,191,39,228,105,151,201,217,112,22,151,72,40,175,145,20,250,51,170,211,163,20,114,18,226,90,57,66,162,102,174,19,133,114,161,66,236,227,181,190,139,27,108,146,29,138,184,234,173,213,206,95,77,97,91,129,94,244,251,193,188,95,83,174,171,222,86,123,241,14,54,119,95,182,18,101,10,8,74,167,23,23,97,12,102,139,104,56,68,180,27,23,19,81,243,55,165,162,227,80,177,85,123,157,10,207,200,10,163,28,1,79,66,28,52,43,69,72,69,192,72,92,228,169,178,63,207,238,198,51,189,46,152,246,180,235,142,233,117,154,23,11,242,5,50,109,137,48,150,155,45,194,88,134,41,196,100,185,123,195,185,238,116,220,169,174,59,101,180,183,222,69,174,189,213,218,192,184,221,66,39,33,110,53,2,31,163,8,242,16,143,24,104,140,162,44,143,67,172,138,186,9,44,225,33,142,244,44,208,255,164,178,228,82,233,30,168,180,194,202,91,213,252,51,170,137,68,140,102,33,222,50,211,192,248,66,91,173,222,246,223,95,113,29,255,253,139,156,183,156,100,50,26,145,72,175,233,89,52,15,148,174,156,56,239,94,18,46,26,98,162,137,60,74,227,19,52,100,19,121,23,226,16,7,237,90,17,192,152,42,61,143,102,76,165,177,184,23,81,92,42,87,179,173,104,253,100,182,216,162,192,242,20,102,39,138,89,204,43,188,188,158,203,49,230,81,42,93,158,149,231,10,225,48,233,111,226,212,125,179,209,142,93,52,215,28,32,237,181,85,236,221,29,242,134,170,134,91,85,224,172,117,157,173,55,156,18,151,63,16,12,105,91,110,105,13,183,180,117,103,199,6,31,8,140,225,90,107,226,86,127,237,153,116,137,211,96,121,213,122,198,115,101,217,90,249,223,132,24,62,36,145,238,145,17,76,152,86,165,84,114,170,37,116,207,127,85,158,87,130,210,116,231,239,0,0,0,255,255,80,75,7,8,55,48,252,24,76,5,0,0,117,25,0,0,80,75,3,4,20,0,8,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,24,0,0,0,120,108,47,119,111,114,107,115,104,101,101,116,115,47,115,104,101,101,116,49,46,120,109,108,140,144,205,106,235,48,16,133,247,247,41,196,236,111,228,20,90,74,176,28,10,33,180,187,210,191,189,98,141,99,17,73,99,52,147,218,125,251,98,39,54,89,118,119,208,232,251,152,51,229,118,136,65,125,99,102,79,201,192,122,85,128,194,84,147,243,233,104,224,243,99,255,255,17,20,139,77,206,6,74,104,224,7,25,182,213,191,178,167,124,226,22,81,212,16,67,98,3,173,72,183,209,154,235,22,163,229,21,117,152,134,24,26,202,209,10,175,40,31,53,119,25,173,155,160,24,244,93,81,60,232,104,125,130,139,97,147,255,226,160,166,241,53,238,168,62,71,76,114,145,100,12,86,60,37,110,125,199,80,149,206,71,76,99,31,149,177,49,240,180,134,170,212,203,99,85,78,27,124,121,236,249,38,43,177,135,119,12,88,11,58,3,146,207,8,106,236,120,32,58,141,243,23,103,160,24,69,11,113,155,103,211,126,90,245,53,43,135,141,61,7,121,163,254,25,253,177,21,3,235,251,133,158,127,93,161,157,21,59,143,174,121,185,110,245,27,0,0,255,255,80,75,7,8,31,2,97,73,250,0,0,0,161,1,0,0,80,75,3,4,20,0,8,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15,0,0,0,120,108,47,119,111,114,107,98,111,111,107,46,120,109,108,140,145,65,111,219,48,12,133,239,251,21,2,239,141,37,35,13,130,192,114,129,97,27,150,195,134,28,186,246,172,72,116,44,68,18,13,73,110,146,127,63,200,169,151,12,189,244,244,236,71,250,35,249,220,60,157,189,99,111,24,147,165,32,65,44,56,48,12,154,140,13,7,9,127,158,127,60,172,129,165,172,130,81,142,2,74,184,96,130,167,246,75,115,162,120,220,19,29,217,217,187,144,36,244,57,15,155,170,74,186,71,175,210,130,6,12,103,239,58,138,94,229,180,160,120,168,210,16,81,153,212,35,102,239,170,154,243,85,229,149,13,112,37,108,226,103,24,212,117,86,227,55,210,163,199,144,175,144,136,78,101,75,33,245,118,72,51,205,235,207,224,188,138,199,113,120,208,228,7,149,237,222,58,155,47,19,20,152,215,155,237,33,80,84,123,135,18,206,226,113,38,159,197,227,7,180,183,58,82,162,46,47,52,249,247,37,63,220,43,120,37,196,245,228,182,233,172,195,151,107,234,76,13,195,111,229,203,20,7,204,169,148,191,27,155,209,72,88,1,115,116,194,255,140,56,14,95,71,235,140,4,177,92,214,28,218,166,186,99,181,255,254,203,46,50,131,157,26,93,126,238,209,207,117,9,98,181,228,66,0,235,172,203,24,119,209,190,41,125,145,144,227,136,133,117,251,188,109,138,190,88,60,165,27,181,188,178,147,13,134,78,63,209,30,250,44,97,205,5,135,119,239,213,154,220,151,205,214,188,228,245,58,153,18,56,176,203,237,249,110,74,193,181,77,117,55,104,138,107,86,22,166,88,182,145,2,251,165,2,176,201,221,26,9,53,176,184,177,70,66,220,154,101,33,78,149,89,83,219,104,229,244,46,178,34,165,95,212,117,45,68,105,188,22,238,118,104,255,6,0,0,255,255,80,75,7,8,42,141,81,104,157,1,0,0,3,3,0,0,80,75,3,4,20,0,8,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,11,0,0,0,95,114,101,108,115,47,46,114,101,108,115,148,208,193,74,196,48,16,6,224,187,79,17,230,190,205,238,10,34,178,233,94,68,216,155,72,125,128,49,153,182,161,73,38,36,81,179,111,47,122,113,139,21,237,113,96,248,255,143,255,112,172,222,137,55,74,217,114,80,176,107,182,32,40,104,54,54,12,10,158,187,135,205,45,136,92,48,24,116,28,72,193,153,50,28,219,171,195,19,57,44,150,67,30,109,204,162,122,23,178,130,177,148,120,39,101,214,35,121,204,13,71,10,213,187,158,147,199,146,27,78,131,140,168,39,28,72,238,183,219,27,153,46,51,160,157,101,138,147,81,144,78,230,26,68,135,105,160,162,192,176,126,76,28,179,196,24,155,234,29,136,238,28,233,63,173,220,247,86,211,61,235,87,79,161,44,148,75,170,133,130,33,179,137,137,35,165,98,233,19,36,47,69,203,190,253,130,79,115,162,117,192,223,103,145,158,10,26,44,248,149,186,154,183,251,230,85,39,223,57,77,47,204,211,58,220,223,235,205,63,126,202,102,103,110,63,2,0,0,255,255,80,75,7,8,179,71,177,30,240,0,0,0,117,2,0,0,80,75,3,4,20,0,8,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,16,0,0,0,100,111,99,80,114,111,112,115,47,97,112,112,46,120,109,108,156,207,207,74,52,49,16,4,240,251,247,20,161,239,59,153,207,131,200,146,201,34,248,231,234,97,244,30,146,158,221,64,210,29,210,237,146,245,233,69,4,215,179,199,162,224,71,149,59,140,90,204,25,187,100,166,5,254,79,51,24,164,200,41,211,113,129,215,245,105,119,7,70,52,80,10,133,9,23,184,160,192,193,255,115,47,157,27,118,205,40,102,212,66,178,192,73,181,237,173,149,120,194,26,100,226,134,52,106,217,184,215,160,50,113,63,90,222,182,28,241,129,227,123,69,82,123,51,207,183,22,135,34,37,76,187,246,3,194,183,184,63,235,95,209,196,241,107,159,188,173,151,134,2,222,173,172,161,172,185,162,159,157,189,6,119,223,90,201,49,104,102,242,207,108,30,71,196,146,63,208,217,223,133,179,215,179,254,51,0,0,255,255,80,75,7,8,243,65,153,196,193,0,0,0,49,1,0,0,80,75,3,4,20,0,8,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,17,0,0,0,100,111,99,80,114,111,112,115,47,99,111,114,101,46,120,109,108,164,145,79,107,243,48,12,135,239,239,167,8,190,39,114,90,40,239,66,146,30,54,122,218,96,176,142,141,221,140,173,182,102,241,31,44,119,113,191,253,72,218,166,29,235,109,224,147,126,143,30,100,169,94,38,211,101,95,24,72,59,219,176,178,224,44,67,43,157,210,118,219,176,215,245,42,255,207,50,138,194,42,209,57,139,13,59,32,177,101,251,175,150,190,146,46,224,115,112,30,67,212,72,89,50,157,165,74,250,134,237,98,244,21,0,201,29,26,65,133,243,104,147,233,54,46,24,17,169,112,97,11,94,200,79,177,69,152,113,190,0,131,81,40,17,5,12,194,220,79,70,118,82,42,57,41,253,62,116,163,64,73,192,14,13,218,72,80,22,37,92,216,136,193,208,205,134,49,185,34,141,142,7,143,55,209,115,56,209,137,244,4,246,125,95,244,243,17,157,113,94,194,251,211,227,203,248,213,92,219,97,85,18,89,91,43,89,201,128,34,186,208,166,125,208,53,92,21,234,211,148,199,2,170,44,145,174,142,179,156,147,183,249,253,195,122,197,218,97,65,57,191,203,203,197,154,243,106,124,31,131,235,71,255,69,104,156,210,27,253,7,227,89,208,214,240,235,194,237,119,0,0,0,255,255,80,75,7,8,150,226,5,53,29,1,0,0,45,2,0,0,80,75,3,4,20,0,8,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,26,0,0,0,120,108,47,95,114,101,108,115,47,119,111,114,107,98,111,111,107,46,120,109,108,46,114,101,108,115,172,209,203,106,132,48,20,198,241,125,159,34,156,125,141,99,47,148,98,156,77,41,204,182,181,15,16,244,104,194,228,34,57,167,173,190,125,193,66,71,233,44,92,184,73,200,230,255,253,32,229,113,244,78,124,97,34,27,131,130,67,150,131,192,208,196,214,134,94,193,71,253,122,251,4,130,88,135,86,187,24,80,193,132,4,199,234,166,124,67,167,217,198,64,198,14,36,70,239,2,41,48,204,195,179,148,212,24,244,154,178,56,96,24,189,235,98,242,154,41,139,169,151,131,110,206,186,71,89,228,249,163,76,203,6,84,171,166,56,181,10,210,169,45,64,212,58,245,200,10,136,39,135,148,141,222,129,168,167,1,183,236,197,174,179,13,190,196,230,211,99,224,43,179,242,183,10,85,41,151,243,215,49,119,23,12,27,244,40,231,243,176,55,105,174,110,19,221,95,68,114,116,242,59,166,51,25,68,38,57,95,197,222,180,191,129,109,188,135,53,143,140,78,216,190,115,178,161,223,255,35,151,241,255,188,213,147,170,159,0,0,0,255,255,80,75,7,8,130,11,55,245,244,0,0,0,249,2,0,0,80,75,3,4,20,0,8,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,24,0,0,0,120,108,47,119,111,114,107,115,104,101,101,116,115,47,115,104,101,101,116,50,46,120,109,108,76,144,77,75,196,48,16,134,239,254,138,48,119,55,173,7,17,73,178,172,136,224,217,143,123,182,153,221,150,77,50,37,51,182,245,223,75,86,45,189,189,204,195,251,193,152,253,146,162,154,176,240,64,217,66,187,107,64,97,238,40,12,249,108,225,227,253,229,246,1,20,139,207,193,71,202,104,225,27,25,246,238,198,204,84,46,220,35,138,90,82,204,108,161,23,25,31,181,230,174,199,228,121,71,35,230,37,197,19,149,228,133,119,84,206,154,199,130,62,92,77,41,234,187,166,185,215,201,15,25,156,9,67,194,92,23,168,130,39,11,135,22,156,209,235,209,153,171,231,115,192,153,55,90,137,63,190,97,196,78,48,88,144,242,133,160,234,170,35,209,165,242,215,96,161,169,65,171,99,171,255,147,158,189,120,103,10,205,170,88,168,189,93,21,135,22,148,88,96,112,102,114,141,209,147,51,186,251,99,79,91,214,174,76,23,90,11,126,67,245,250,35,247,19,0,0,255,255,80,75,7,8,249,167,34,97,228,0,0,0,103,1,0,0,80,75,3,4,20,0,8,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,20,0,0,0,120,108,47,115,104,97,114,101,100,83,116,114,105,110,103,115,46,120,109,108,68,200,81,106,195,48,12,0,208,255,157,194,232,127,81,22,198,8,195,118,24,131,158,160,61,128,73,212,196,96,203,169,165,148,244,246,165,148,210,207,247,236,176,231,100,174,84,37,22,118,240,213,180,96,136,199,50,69,158,29,156,142,135,207,30,140,104,224,41,164,194,228,224,70,2,131,255,176,34,106,246,156,88,28,44,170,235,47,162,140,11,229,32,77,89,137,247,156,206,165,230,160,210,148,58,163,172,149,194,36,11,145,230,132,93,219,254,96,14,145,193,140,101,99,117,208,129,217,56,94,54,250,127,217,91,137,222,170,255,155,201,162,122,139,15,62,235,187,127,15,138,168,191,7,0,0,255,255,80,75,7,8,159,99,127,136,158,0,0,0,196,0,0,0,80,75,3,4,20,0,8,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,13,0,0,0,120,108,47,115,116,121,108,101,115,46,120,109,108,164,152,95,143,219,42,22,192,223,247,83,32,191,207,216,164,73,38,19,217,174,86,173,42,85,234,174,70,106,87,234,43,193,56,65,195,31,11,112,150,244,234,126,247,43,112,140,157,56,51,165,78,164,216,228,152,243,3,14,231,143,73,254,209,114,6,142,68,105,42,69,145,192,199,44,1,68,96,89,81,177,47,146,255,253,248,242,176,73,128,54,72,84,136,73,65,138,228,68,116,242,177,252,87,174,205,137,145,239,7,66,12,0,150,51,161,139,228,96,76,179,77,83,141,15,132,35,253,40,27,34,44,103,181,84,28,25,253,40,213,62,213,141,34,168,210,78,139,179,116,145,101,235,148,35,42,146,142,176,69,77,12,68,214,53,197,228,179,196,45,39,194,116,20,98,13,17,21,169,30,26,37,27,162,12,37,186,135,202,217,80,220,106,35,249,13,36,138,33,86,10,253,159,138,253,173,117,226,25,250,248,128,148,9,128,74,205,69,124,238,100,129,36,121,148,125,174,81,146,55,200,208,29,101,212,156,122,86,181,231,51,80,21,69,123,133,120,15,97,115,140,195,36,126,37,213,39,36,142,40,108,82,67,231,144,26,138,77,171,72,15,177,179,12,61,114,243,43,115,71,209,110,249,162,34,12,25,42,133,62,208,38,44,177,138,10,186,183,93,251,39,103,61,42,106,231,110,145,56,50,135,96,173,24,200,111,114,128,102,81,16,255,232,27,221,41,164,78,83,8,143,218,122,142,212,107,219,60,92,248,178,103,133,245,184,132,119,197,225,20,43,169,101,109,30,177,228,103,139,164,196,98,114,99,45,92,203,56,125,175,153,193,243,182,180,52,36,154,169,69,223,214,71,216,208,35,249,25,34,187,105,166,222,246,182,54,150,71,162,94,208,158,188,40,57,120,24,174,232,52,61,188,3,241,243,239,29,228,171,232,172,77,165,120,65,130,4,95,195,230,15,144,156,24,84,33,131,82,44,133,33,194,252,56,53,33,58,133,185,81,118,98,80,157,247,235,176,81,236,79,22,25,48,76,138,253,203,164,56,240,105,117,136,96,13,69,198,203,254,109,140,162,187,214,140,176,154,138,215,223,144,169,120,77,23,25,204,46,139,13,92,198,77,232,156,196,220,196,158,210,77,186,152,148,156,63,7,193,236,102,209,65,179,72,227,69,53,116,198,178,96,54,73,239,177,144,73,210,122,78,159,47,38,100,227,205,211,39,11,152,189,83,40,44,92,162,105,18,139,159,27,194,67,145,136,116,238,209,254,111,174,171,50,215,50,118,121,126,2,217,211,36,151,85,123,30,139,184,216,178,171,153,88,184,138,131,92,155,5,102,41,132,151,123,6,23,115,109,12,97,10,71,54,182,112,53,155,228,167,53,66,69,38,237,9,103,153,42,114,164,238,53,126,64,45,102,178,86,129,181,24,96,31,102,194,214,1,246,97,128,69,122,194,59,176,229,0,155,235,17,3,108,53,192,214,119,195,134,247,7,245,116,55,236,105,128,109,238,134,109,6,216,243,221,176,231,1,6,179,187,105,48,27,225,224,253,56,56,194,205,13,131,17,110,20,7,240,254,64,128,163,72,136,77,138,239,225,70,177,48,59,61,142,112,67,52,192,185,209,176,156,38,219,245,29,233,40,91,156,97,28,111,191,238,133,84,104,199,72,145,96,184,4,254,197,4,32,184,4,254,165,0,88,247,245,50,95,67,65,165,27,224,203,23,240,21,8,88,184,2,62,243,3,159,181,129,85,192,170,5,176,234,3,176,106,9,172,90,1,171,214,192,170,39,96,213,6,88,245,12,156,131,187,11,116,23,215,21,186,190,142,165,60,204,125,215,192,175,16,112,9,184,5,252,8,36,56,134,234,25,121,12,224,8,143,170,232,230,242,44,17,121,20,112,140,112,28,185,66,28,139,164,85,98,123,214,127,8,250,238,8,180,229,8,111,143,195,129,80,190,215,183,27,235,124,235,53,222,165,119,100,181,109,105,85,36,127,101,231,207,67,150,101,240,161,111,117,151,254,243,119,82,230,181,20,70,3,44,91,97,138,4,158,5,101,174,127,129,35,98,69,2,157,40,213,191,202,28,75,38,21,48,7,194,73,215,49,245,146,50,23,136,147,174,243,39,196,232,78,81,247,204,9,203,188,70,156,178,83,247,112,225,196,157,192,53,252,40,254,166,203,188,166,140,133,73,184,142,78,80,230,13,50,134,40,241,133,50,6,206,109,119,54,41,18,33,5,113,184,81,7,7,243,183,223,168,238,21,58,193,197,234,45,109,127,211,101,190,147,170,34,234,194,48,157,168,204,25,169,221,212,187,155,162,251,131,251,117,190,27,217,148,121,234,175,59,105,140,228,101,158,246,13,247,150,37,5,114,131,140,154,61,245,220,208,101,142,9,99,223,205,137,145,159,245,197,248,182,6,162,229,95,184,249,90,21,73,150,0,103,187,190,73,25,59,55,59,76,247,163,204,83,91,187,141,26,17,59,254,221,104,96,235,233,24,1,239,7,187,24,33,72,129,243,140,34,249,175,59,182,178,1,3,118,45,101,134,138,0,13,10,227,182,46,243,202,14,83,247,29,157,160,204,141,203,86,151,195,102,9,168,72,141,90,102,94,232,81,26,255,176,72,134,246,55,183,101,112,29,122,253,8,136,34,25,218,255,33,21,109,185,119,222,209,24,46,38,194,191,179,229,63,1,0,0,255,255,80,75,7,8,163,250,220,212,193,4,0,0,226,21,0,0,80,75,1,2,20,0,20,0,8,0,8,0,0,0,0,0,232,197,0,177,95,1,0,0,231,4,0,0,19,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,91,67,111,110,116,101,110,116,95,84,121,112,101,115,93,46,120,109,108,80,75,1,2,20,0,20,0,8,0,8,0,0,0,0,0,55,48,252,24,76,5,0,0,117,25,0,0,19,0,0,0,0,0,0,0,0,0,0,0,0,0,160,1,0,0,120,108,47,116,104,101,109,101,47,116,104,101,109,101,49,46,120,109,108,80,75,1,2,20,0,20,0,8,0,8,0,0,0,0,0,31,2,97,73,250,0,0,0,161,1,0,0,24,0,0,0,0,0,0,0,0,0,0,0,0,0,45,7,0,0,120,108,47,119,111,114,107,115,104,101,101,116,115,47,115,104,101,101,116,49,46,120,109,108,80,75,1,2,20,0,20,0,8,0,8,0,0,0,0,0,42,141,81,104,157,1,0,0,3,3,0,0,15,0,0,0,0,0,0,0,0,0,0,0,0,0,109,8,0,0,120,108,47,119,111,114,107,98,111,111,107,46,120,109,108,80,75,1,2,20,0,20,0,8,0,8,0,0,0,0,0,179,71,177,30,240,0,0,0,117,2,0,0,11,0,0,0,0,0,0,0,0,0,0,0,0,0,71,10,0,0,95,114,101,108,115,47,46,114,101,108,115,80,75,1,2,20,0,20,0,8,0,8,0,0,0,0,0,243,65,153,196,193,0,0,0,49,1,0,0,16,0,0,0,0,0,0,0,0,0,0,0,0,0,112,11,0,0,100,111,99,80,114,111,112,115,47,97,112,112,46,120,109,108,80,75,1,2,20,0,20,0,8,0,8,0,0,0,0,0,150,226,5,53,29,1,0,0,45,2,0,0,17,0,0,0,0,0,0,0,0,0,0,0,0,0,111,12,0,0,100,111,99,80,114,111,112,115,47,99,111,114,101,46,120,109,108,80,75,1,2,20,0,20,0,8,0,8,0,0,0,0,0,130,11,55,245,244,0,0,0,249,2,0,0,26,0,0,0,0,0,0,0,0,0,0,0,0,0,203,13,0,0,120,108,47,95,114,101,108,115,47,119,111,114,107,98,111,111,107,46,120,109,108,46,114,101,108,115,80,75,1,2,20,0,20,0,8,0,8,0,0,0,0,0,249,167,34,97,228,0,0,0,103,1,0,0,24,0,0,0,0,0,0,0,0,0,0,0,0,0,7,15,0,0,120,108,47,119,111,114,107,115,104,101,101,116,115,47,115,104,101,101,116,50,46,120,109,108,80,75,1,2,20,0,20,0,8,0,8,0,0,0,0,0,159,99,127,136,158,0,0,0,196,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,49,16,0,0,120,108,47,115,104,97,114,101,100,83,116,114,105,110,103,115,46,120,109,108,80,75,1,2,20,0,20,0,8,0,8,0,0,0,0,0,163,250,220,212,193,4,0,0,226,21,0,0,13,0,0,0,0,0,0,0,0,0,0,0,0,0,17,17,0,0,120,108,47,115,116,121,108,101,115,46,120,109,108,80,75,5,6,0,0,0,0,11,0,11,0,198,2,0,0,13,22,0,0,0,0
Copied!
In this example, we created a Workbook Object and use xlsxEncode to encode our workbook to Uint8Array. Since Uint8Array represents an array of 8-bit unsigned integer, which means it's not that easy for people to identify its content and value. You may need to convert it to string so it's gonna be readable. But right now we'll skip this part and leave it to you to decide whether you want to convert the Uint8Array data to something else. So we converted the Uint8Array back to a workbook to check if we can still get the same value.
To use the Document Aptitude, simply set the following permissions in your package.json under the ldk object.
1
...
2
"ldk": {
3
"permissions": {
4
"document": {},
5
...
6
}
7
},
8
...
Copied!
Last modified 5d ago
Copy link