gc-excel - 快速入门

根据 sheetName 获取 sheet

// 通过工作表名称访问（例如 "Sheet1"）
IWorksheet worksheet = workbook.getWorksheets().get("Sheet1");

读写 tag

// 为整个工作表设置 Tag
worksheet.setTag("This is a Tag for sheet.");

// 为某个单元格设置 Tag
worksheet.getRange("C1").setTag("This is a Tag for Cell C1");

// 为某一行设置 Tag
worksheet.getRange("A4").getEntireRow().setTag("This is a Tag for Row 4");

// 为某一列设置 Tag
worksheet.getRange("F5").getEntireColumn().setTag("This is a Tag for Column F");

// 为一个范围设置 Tag
worksheet.getRange("A1:B2").setTag("This is a Tag for A1:B2");