如何保护这两张纸?目前,该代码只保护第一张纸。
var plan = spreadsheetNew("TEST", true);
SpreadsheetCreateSheet(plan , "TEST2" );
cfspreadsheet(
action="write", fileName="temp.xslx", name="plan",
overwrite=true, sheetname="TEST", password="123"
);
我还测试了在cf电子表格中省略表格名称
cfspreadsheet(action="write", fileName="temp.xslx", name="plan", overwrite=true, password="123");
更新(基于评论(
如果你想更改所选的工作表,我会恢复到你的代码,然后使用内部Java库来设置密码。
plan = spreadsheetNew("TEST", true);
SpreadsheetCreateSheet(plan , "TEST2" );
workbookJavaObj = plan.getWorkBook();
workbookJavaObj.getSheetAt(0).protectSheet('123');
workbookJavaObj.getSheetAt(1).protectSheet('123');
spreadsheetSetActiveSheet(plan, "TEST2");
cfspreadsheet(
action="write", fileName="temp.xlsx", name="plan", overwrite=true
);
冷融合溶液
我认为应该这样做。创建一个新的电子表格对象,并使用action="update"
将该工作表添加到先前编写的文件中。
plan = spreadsheetNew("TEST", true);
cfspreadsheet(action="write", fileName="temp.xlsx", name="plan", overwrite=true, sheetname="TEST", password="123");
plan2 = spreadsheetNew("TEST2", true);
cfspreadsheet(action="update", fileName="temp.xlsx", name="plan2", sheetname="TEST2", password="123");