createFile(options?:object)

{
    password:"123456", //设置文件的访问密码
}

import excel from "excel"
let excelFile1 = excel.createFile()
//创建带有访问密码的文件
let excelFile2 = excel.createFile({password:"123456"})

openFile(filePath:string,options?:object)

{
    password:"123456", //文件的访问密码
}

import excel from "excel"
let excelFile1 = excel.openFile("./test1.xlsx")
//如果test2.xlsx有访问密码
let excelFile2 = excel.openFile("./test2.xlsx",{password:"123456"})

newSheet(sheetName:string)

import excel from "excel"
let file = excel.createFile()
console.log(file.newSheet("Sheet2"))//打印1,因为默认已经存在Sheet1

newStyle(style:object)

import excel from "excel"
let file = excel.createFile()
const style = {
    border: [
        { type: "left", color: "#000000", style: 1 },
        { type: "top", color: "#000000", style: 1 },
        { type: "bottom", color: "#000000", style: 1 },
        { type: "right", color: "#000000", style: 1 }
    ],
    fill: {
        type: "pattern",
        pattern: 1,
        color: ["#FFFF00"],
        shading: 0
    },
    font: {
        bold: true,
        italic: true,
        underline: "",
        family: "Arial",
        size: 12,
        strike: false,
        color: "#FF0000",
        colorTint: 0,
        vertAlign: ""
    },
    alignment: {
        horizontal: "center",
        indent: 0,
        justifyLastLine: false,
        readingOrder: 0,
        relativeIndent: 0,
        shrinkToFit: false,
        textRotation: 0,
        vertical: "center",
        wrapText: false
    },
    protection: {
        hidden: false,
        locked: true
    },
    numFmt: 14,
    decimalPlaces: 2,
    customNumFmt: "\"¥\"#,##0.00",
    negRed: true
};
//返回样式对象的索引值
let styleIndex = file.newStyle(style)

setSheetName(oldName:string, newName:string)

import excel from "excel"
let file = excel.createFile()
file.setSheetName("Sheet1", "新sheet名称")

setSheetRow(sheetName:string,cell:string,rows:any[])

import excel from "excel"
let file = excel.createFile()
file.setSheetRow("Sheet1","A1",["姓名","年龄"])
for (let i = 2; i < 10; i++) {
    file.setSheetRow("Sheet1","A"+i,["人员",12])
}
file.save("./excel.xlsx")

getSheetList():string[]

import excel from "excel"
let file = excel.createFile()
console.log(file.getSheetList()) //打印：[ 'Sheet1' ]

getSheetIndex(name:string):int

import excel from "excel"
let file = excel.createFile()
console.log(file.getSheetIndex("Sheet1")) //打印：0
console.log(file.getSheetIndex("Sheet2")) //打印：-1

getSheetName(index:int):string

import excel from "excel"
let file = excel.createFile()
console.log(file.getSheetName(0)) //打印：Sheet1
console.log(file.getSheetName(1)) //打印：

setActiveSheet(index:int)

import excel from "excel"
let file = excel.createFile()
file.newSheet("Sheet2")
console.log(file.setActiveSheet(1))//设置第二个工作表为活动工作表

setCellValue(sheetName:string, cell:string, value:any)

import excel from "excel"
let file = excel.createFile()
file.setCellValue("Sheet1", "A1", "测试1")
file.setCellValue("Sheet1", "A2", 1)
file.setCellValue("Sheet1", "A3", true)
file.setCellValue("Sheet1", "B1", 1.21)
file.setCellValue("Sheet1", "B2", null)
file.setCellValue("Sheet1", "B3", 323n)

setCellFormula(sheetName:string, cell:string, formula:string)

import excel from "excel"
let file = excel.createFile()
file.setSheetRow("Sheet1","A1",["姓名","年龄"])
for (let i = 2; i < 10; i++) {
    file.setSheetRow("Sheet1","A"+i,["人员",12])
}
//计算B1:B9的和
file.setCellFormula("Sheet1","B10","sum(B1:B9)")
file.save("./excel.xlsx")

setColWidth(sheetName:string,startCol:string,endCol:string,width:int)

import excel from "excel"
let file = excel.createFile()
//将第1,2列的宽度都设置为50
file.setColWidth("Sheet1","A","B",50)

setRowHeight(sheetName:string,row:int,height:int)

import excel from "excel"
let file = excel.createFile()
//将第1行的高度设置为30
file.setRowHeight("Sheet1",1,30)

setCellStyle(sheetName:string,topLeftCell:string,bottomRightCell:string,styleIndex:int)

import excel from "excel"
let file = excel.createFile()
file.setCellValue("Sheet1", "A1", "测试1")
file.setCellValue("Sheet1", "A2", 1)
file.setCellValue("Sheet1", "A3", true)
file.setCellValue("Sheet1", "B1", 1.21)
//设置单元格样式,styleIndex由newStyle函数创建并返回
file.setCellStyle("Sheet1", "B1", "B1",styleIndex)

setColStyle(sheetName:string,col:string,styleIndex:int)

import excel from "excel"
let file = excel.createFile()
//设置第二列样式,styleIndex由newStyle函数创建并返回
file.setColStyle("Sheet1", "B",styleIndex)

setRowStyle(sheetName:string,startRow:int,endRow:int,styleIndex:int)

import excel from "excel"
let file = excel.createFile()
//设置1-3行的样式,styleIndex由newStyle函数创建并返回
file.setRowStyle("Sheet1", 1,3,styleIndex)

deleteSheet(sheetName:string)

import excel from "excel"
let file = excel.createFile()
file.deleteSheet("Sheet1")

getCellValue(sheetName:string, cell:string):string

import excel from "excel"
let file = excel.openFile("./1.xlsx")
let value = file.getCellValue("Sheet1", "A1")
console.log(value)

getRows(sheetName:string):any[]

import excel from "excel"
let file = excel.openFile("./excel.xlsx")
let rows = file.getRows("Sheet1")
console.log(rows) //结果为: [ [ '字符串', '1.21' ], [ '', '2222' ], [ 'TRUE', '43434' ] ]

mergeCell(sheetName:string,topLeftCell:string,bottomRightCell:string)

import excel from "excel"
let file = excel.openFile("./excel.xlsx")
//第一行的第1-2列进行合并
file.mergeCell("Sheet1","A1","B1")

save(filePath:string)

import excel from "excel"

let file = excel.createFile()
file.setCellValue("Sheet1", "A1", "测试1")
file.setCellValue("Sheet1", "A2", "测试2")
file.save("./1.xlsx")

write(writer:Writer)

import excel from "excel"
let file = excel.createFile()
file.setCellValue("Sheet1", "A1", "测试1")
file.setCellValue("Sheet1", "A2", "测试2")
let buf = new Buffer()
file.write(buf)

close()

import excel from "excel"
let file = excel.createFile()
file.setCellValue("Sheet1", "A1", "测试1")
file.setCellValue("Sheet1", "A2", "测试2")
file.save("./1.xlsx")
file.close()

getBuffer():Buffer

import excel from "excel"

let file = excel.createFile()
file.setCellValue("Sheet1", "A1", "测试1")
file.setCellValue("Sheet1", "A2", "测试2")
let bu = file.getBuffer()

{ 
    type: "left", //边框类型（如 "left", "top", "right", "bottom", "diagonalDown", "diagonalUp"）
    color: "#000000", //边框颜色（使用 RGB 十六进制格式，如 "#000000"）
    style: 1 //边框样式（具体样式参见下表）
}

import excel from "excel"
let file = excel.createFile()
const style = {
    border: [
        { type: "left", color: "#000000", style: 1 },
        { type: "top", color: "#000000", style: 1 },
        { type: "bottom", color: "#000000", style: 1 },
        { type: "right", color: "#000000", style: 1 }
    ]
};
let styleIndex = file.newStyle(style)

{
    type: "pattern",//填充类型,取值范围 [pattern,gradient],
    pattern: 1, //填充模式索引（参考下表）
    color: ["#FFFF00"],//填充颜色数组
    shading: 0 //填充阴影索引（可选）（参考下表）
}

import excel from "excel"
let file = excel.createFile()
const style = {
    fill: {
        type: "pattern",
        pattern: 1,
        color: ["#FFFF00"],
        shading: 0
    },
};
let styleIndex = file.newStyle(style)

{
    bold: true,//是否加粗
    italic: true,//是否斜体
    underline: "single",//下划线样式，可选范围：["none", "single", "double"]
    family: "Arial",//字体
    size: 12, //字体大小
    color: "#FF0000", //字体颜色（使用 RGB 十六进制格式，如 "#FF0000"）
    colorTint: 0,//颜色的色调调整.正值表示变亮，负值表示变暗,浮点数，范围从 -1 到 1
    strike: false,//是否使用删除线
    vertAlign: "" //文本的垂直对齐方式，可选范围：[baseline,superscript,subscript];baseline(默认基线对齐),superscript(上标),subscript(下标)
}

import excel from "excel"
let file = excel.createFile()
const style = {
    font: {
        bold: true,
        italic: true,
        underline: "",
        family: "Arial",
        size: 12,
        strike: false,
        color: "#FF0000",
        colorTint: 0,
        vertAlign: ""
    },
};
let styleIndex = file.newStyle(style)

{
    horizontal: "center",//水平对齐方式（参考下表）
    vertical: "center",//垂直对齐方式（参考下表）
    indent: 0, //定义单元格内容的缩进级别。每一级缩进表示三个空格的宽度。整数，表示缩进级别。示例：Indent: 2（表示缩进 2 级，即 6 个空格）
    justifyLastLine: false,//（可选）最后一行对齐在水平对齐设置为 "justify" 时，如果为 true，则对齐最后一行内容。
    readingOrder: 0, //单元格内容的阅读顺序。取值范围:[0,1,2]。0：上下文相关,1：从左到右,2：从右到左
    relativeIndent: 0,//（可选）相对缩进级别,用于进一步调整文本的缩进。整数，表示相对缩进级别
    shrinkToFit: false,//（可选）自动缩小以适应单元格大小。如果为 true，则自动缩小内容以适应单元格大小
    textRotation: 0,//定义单元格内容的文本旋转角度。整数，范围为 0 到 180，表示逆时针旋转角度；示例：TextRotation: 90（表示文本逆时针旋转 90 度）
    wrapText: false //（可选）自动换行。如果为 true，则自动换行显示单元格内容
}

import excel from "excel"
let file = excel.createFile()
const style = {
    alignment: {
        horizontal: "center",
        indent: 0,
        justifyLastLine: false,
        readingOrder: 0,
        relativeIndent: 0,
        shrinkToFit: false,
        textRotation: 0,
        vertical: "center",
        wrapText: false
    },
};
let styleIndex = file.newStyle(style)

{
    hidden: false,//是否隐藏单元格内容
    locked: true //是否锁定单元格
}

import excel from "excel"
let file = excel.createFile()
const style = {
    protection: {
        hidden: false,
        locked: true
    },
};
let styleIndex = file.newStyle(style)

import excel from "excel"
let file = excel.createFile()
const style = {
    numFmt: 14,
};
let styleIndex = file.newStyle(style)

import excel from "excel"
let file = excel.createFile()
const style = {
    decimalPlaces: 2,
};
let styleIndex = file.newStyle(style)

import excel from "excel"
let file = excel.createFile()
const style = {
    customNumFmt: "\"¥\"#,##0.00",
};
let styleIndex = file.newStyle(style)

import excel from "excel"
let file = excel.createFile()
const style = {
    negRed: true
};
let styleIndex = file.newStyle(style)