BOYGAO12的博客

dynamic drawingPs = sheet1.DrawingPatriarch; dynamic childrens = drawingPs.Children; foreach(var item in childrens) { dynamic anchor = item.Anchor; if(anchor.Row1 == ...

有时，我们可能需要某些单元格只读，如在做模板时，模板中的数据是不能随意让别人改的。在Excel中，可以通过“审阅->保护工作表”来完成，如下图：HSSFSheet sheet1 = hssfworkbook.CreateSheet("Sheet1");sheet1.ProtectSheet("password");//设置密码HSSFRow row1 = sheet1.CreateRow(0); HSSFCell cel1 = row1.CreateCell(...