$excel - 表格操作#

//读取第一个表格数据
let data = $excel.read("data.xlsx");//相对路径
log(data);
// 输出:
// [
//    ["学号","姓名","年龄","性别","入学日期"],
//    ["2023001","张三","20","男","2023-09-01"],
//    ["2023002","李四","19","女","2023-09-01"],
//    ["2023003","王五","21","男","2022-09-01"],
//    ["2023004","赵六","20","女","2023-09-01"]
// ]

//读取第2个表格数据
let data = $excel.read("data.xlsx", 1);//相对路径
log(data);
// 输出:
// [
//    ["商品ID","商品名称","商品单价","库存"],
//    ["P001","笔记本电脑","4999","10"],
//    ["P002","智能手机","3999","25"],
//    ["P003","平板电脑","2499","18"],
//    ["P004","无线耳机","799","50"]
// ]

//获取表格的数量
let sheetNum = $excel.num("data.xlsx");//相对路径
log(sheetNum);//输出:3

//获取表格的数量
let sheetList = $excel.ls("data.xlsx");//相对路径
log(sheetList);//输出:["班级表","商品表","部门表"]

//遍历所有表格数据
let data = $excel.loop("data.xlsx", (name, data) => {
    alert(name,data);
});

//数据
let sheetData = [
    ["姓名", "年龄"],
    ["小红", "18"],//注意必须都是字符串类型
    ["小明", "19"]
];
//表名
let sheetName = "我的表格";
//路径(必须是绝对路径)
let savePath = "/sdcard/demo.xlsx";
$excel.write(sheetName, sheetData, savePath);