excel
简介
一个用于对excel文件读写的库 (Import xlnt library)
组件接口
excel.gs
| 函数原型 | 函数作用 |
|---|---|
| object open(string path, string mode = "rw") | 以指定模式打开excel文件, 使用"w"选项时,若文件不存在则会进行创建，默认表（sheet）编号为0 |
| object open_from_data(string path, string mode, buffer data) | 使用缓冲区中的数据创建新文件 |
| mixed read_all(string path, buffer data = nil, int sheet = 0, bool is_to_str = false) | 读取指定文件或缓冲区中的指定表格 |
| mixed read_all_by_sheets(string path, buffer data = nil, mixed sheet_info = nil, bool is_to_str = false) | 读取指定文件或缓冲区中的指定表格 |
| mixed write_all(string path, array arr, int sheet = 0) | 将表格数据写入指定文件的指定的单个表格中，覆盖式写入 |
| mixed write_all_by_sheets(string path, array sheets_content, array sheet_num) | 将表格数据写入指定文件的指定的多个表格中，将sheets_content[i]中的数组数据写入sheet_num[i]表格中，覆盖式写入 |
workbook.gs
支持对已经打开的excecl文档的操作
枚举
CellValueType
NIL = 0,
INTEGER = 1,
BOOLEAN = 2,
REAL = 3,
STRING = 4,
ExcelFontAttribute
FONT_ATTRIBS = 0,
FONT_SIZE = 1,
FONT_BOLD = 2,
FONT_COLOR = 3,
FONT_ITALIC = 4,
FONT_STRIKEOUT = 5,
FONT_UNDERLINE = 6
OpenFlag
NONE = 0x00,
// Excel can write
WRITE = 0x01,
// Excel can read
READ = 0x02,
ExcelErrorCode
OK = 0,
DATA_CORRUPT,
ERR,
INVALID_PATH,
NOT_EXIST,
NOT_FILE,
NOT_SUPPORT,
READ_FAIL,
ALREADY_OPENED,
OPEN_FAIL,
OUT_OF_MEMORY,
VERSION_MISMATCH,
WRITE_FAIL,
SET_BACKGROUND_FAIL,
SET_FONT_COLOR_FAIL,
OUT_OF_SHEET_INDEX,
CAN_NOT_WRITE,
CELL_ALREADY_MERGED,
BAD_VALUE_TYPE,
BAD_VALUE,
BAD_STYLE,
INVALID_SHEET,
NAME_NOT_CHANGED,
underline_style
none,
double_,
double_accounting,
single,
single_accounting
border_style
none,
dashdot,
dashdotdot,
dashed,
dotted,
double_,
hair,
medium,
mediumdashdot,
mediumdashdotdot,
mediumdashed,
slantdashdot,
thick,
thin
样例
// sample.gs
import gs.util.file;
import pkg.excel;
string path = "tests/test.xlsx";
object excel_obj = excel.open(path, "rw");
excel_obj.set("Country", 1, 1);
excel_obj.set("Capital", 1, 2);
excel_obj.save();
// 修改后务必调用 .save() 保存
// 修改后务必调用 .save() 保存
// 修改后 务必调用 .save() 保存
array data_arr = excel.read_all("tests/test.xlsx", nil, 1 , true);
write(data_arr);