-
Notifications
You must be signed in to change notification settings - Fork 4
/
helpers.js
51 lines (45 loc) · 1.65 KB
/
helpers.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
function getColumnLetter (column) {
if (!column || column <= 0) {
throw 'column must be more than 0'
}
const array = []
while (column > 0) {
var remainder = column % 26
column /= 26
column = Math.floor(column)
if (remainder === 0) {
remainder = 26
column--
}
array.push(64 + remainder)
}
return String.fromCharCode.apply(null, array.reverse())
}
exports.convertToBit = function (value) {
if (typeof value === 'boolean') {
return value ? 1 : 0
} else if (typeof value === 'string') {
return value.toLowerCase() === 'true' ? 1 : 0
} else {
return 0
}
}
exports.addCell = function (options) {
const { rowIndex, type } = options
const cellReference = `${getColumnLetter(options.cellIndex)}${rowIndex}`
const styleIndex = options.styleIndex || 0
// check if valid value and cast to string -> this fixes the issue when passing non-string values when column type is string
const hasValidValue = options.value != null
const value = hasValidValue ? options.value.toString() : ''
if (type) {
return `<x:c r="${cellReference}" s="${styleIndex}" t="${type}"><x:v>${value}</x:v></x:c>`
} else {
const encodedValue = value.replace(/&/g, '&').replace(/'/g, ''').replace(/>/g, '>').replace(/</g, '<')
return `<x:c r="${cellReference}" s="${styleIndex}" t="inlineStr"><x:is><x:t>${encodedValue}</x:t></x:is></x:c>`
}
}
exports.addMergeCell = function ({ row, fromColumn, toColumn }) {
const fromCellReference = `${getColumnLetter(fromColumn)}${row}`
const toCellReference = `${getColumnLetter(toColumn)}${row}`
return `<mergeCell ref="${fromCellReference}:${toCellReference}" />`
}