excelxs-copy-range.js 311 Bytes
Newer Older
Leon's avatar
Leon committed
1 2 3 4
require("topsin.excelxs");
try {
    var book = new Book;
    var ok = book.open("test.xlsx");
Leon's avatar
Leon committed
5
    if (!ok) throw "open xlsx failed.";
Leon's avatar
Leon committed
6 7 8 9 10 11 12 13
    var sheet = book.getSheet(0);
    var range = sheet.addRange(0, 0, 0, 4);
    sheet.copyRange(range, 1, 0);
    book.save();
    book.close();
} catch(e) {
    print(e);
}