import office from 'apigo.cc/gojs/office'
import co from 'apigo.cc/gojs/console'
import file from 'apigo.cc/gojs/file'

// 测试 makeCellID
for (let x = 0; x < 1000; x++) {
    for (let y = 0; y < 100; y++) {
        let cellID = office.makeCellID(x, y)
        let [x1, y1] = office.parseCellID(cellID)
        if (x1 !== x || y1 !== y) {
            co.error('failed', x, y, cellID, x1, y1)
            return 'test parseCellID failed'
        }
    }
}

let x = office.openExcel('a.xlsx', '123456')
x.set(0, [['A', 'B', 'C'], ['1', '2', '3'], [1, 2, 3], [1, 2, 3]])

let d = x.get(0, 'A2')
if (d[0][1] !== '2') {
    co.error('test get failed', d)
    return 'test get failed'
}
if (d[1][1] !== 2) {
    co.error('test get failed', d)
    return 'test get failed'
}

x.setData(0, [{ '1': 4, '2': 5, '3': 6 }, { '1': 'A', '2': 'B', '3': 'C' }], 'A2', 'B3')
x.save()

try {
    office.openExcel('a.xlsx', '12345')
    return 'test openExcel with bad password failed'
} catch {
}

let x1 = office.openExcel('a.xlsx', '123456')
d = x1.getData(0, 'A2', 'C4')
if (d[0]['1'] !== 4) {
    co.error('test getData failed', d)
    return 'test getData failed'
}
if (d[0]['3'] !== 3) {
    co.error('test getData failed', d)
    return 'test getData failed'
}
if (d[1]['2'] !== 2) {
    co.error('test getData failed', d)
    return 'test getData failed'
}


file.remove('a.xlsx')

return true