如何锁定Excel里sheet

Question

如何锁定一个sheet 或者锁定指定单元格也行主要是我代码新建sheet2填充数据后 sheet1里的图片就变小了

Answer 1

怎么好好的 save后  图片就会变小呢

Answer 2

//合并单元格
                excel.Merge(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 32]);
                //在指定单元格里添加标题
                excel.WriteRange(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1], title);
                //粗体
                excel.SetBold(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1]);
                //居中
                excel.SetHAlignCenter(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1]);
                //背景色
                excel.SetBgColor(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1], System.Drawing.Color.Silver);
                //字体大小
                excel.SetFontSize(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1], 16);
                //行高
                excel.SetRowHeight(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1], 20);
                //设置标题
                worksheet.Cells[2, 1] = "aaa";
                worksheet.Cells[2, 2] = "bbb";
                worksheet.Cells[2, 3] = "ccc";
                worksheet.Cells[2, 4] = "ddd";