$excel - 表格操作#

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

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

//获取表格的数量
定义 表格数量 = $表格.数量("data.xlsx");//相对路径
日志(表格数量);//输出:3

//获取表格的数量
定义 表格列表 = $表格.罗列("data.x罗列x");//相对路径
日志(表格列表);//输出:["班级表","商品表","部门表"]

//遍历所有表格数据
$表格.遍历("data.xlsx", (名称, 数据) => {
    提示(名称,数据);
});

//数据
定义 表格数据 = [
    ["姓名", "年龄"],
    ["小红", "18"],//注意必须都是字符串类型
    ["小明", "19"]
];
//表名
定义 表格名称 = "我的表格";
//路径(必须是绝对路径)
定义 保存路径 = "/sdcard/demo.xlsx";
$表格.写入(表格名称, 表格数据, 保存路径);