网上几乎所有禁止用户选择Excel的单元格的方法都是在Excel程序里直接手动设置,那么如何通过编程方式实现呢?
于是设想利用EXCEL的录制宏功能,手动设置禁止选中单元格后,查看宏的VB代码,借助MSDN文档翻译为C#代码
代码如下:
using Microsoft.Office.Interop.Excel;
using Excel = Microsoft.Office.Interop.Excel;
public void openExcelLockCell()
{
string file_path = @"d:\test.xlsx";//打开2010版的excel文件
//string file_path="d:\test.xls"//打开2003版的excel文件
Excel.Application excelApp = new Excel.Application();//Excel应用程序
Excel.Workbook excelWorkbook = null;//Excel工作薄
Excel.Worksheet excelSheet = null;//Excel工作表
excelApp.Application.Workbooks.Open(file_path);
excelApp.Visible = true; //让Excel文件可见
excelWorkbook = excelApp.ActiveWorkbook;
excelSheet = (Excel.Worksheet)excelWorkbook.ActiveSheet;
//1先用Worksheets的Protect()方法对工作表进行锁定
excelSheet.Protect("MyPassword", Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing);
//2锁定的单元格中,不包括所选的单元格
excelSheet.EnableSelection = Excel.XlEnableSelection.xlNoSelection;//Nothing may be selected
}