C#:
private void EncryptExcel(string FileName)
{
try
{
FileName = @"D:\Inetpub\PORTAL\Test\MyFilests.xlsx";
Microsoft.Office.Interop.Excel.Application xlApp = null;
Workbook wb = null;
Worksheet ws = null;
Range aRange = null;
xlApp = new Microsoft.Office.Interop.Excel.Application();
//打開Server上的Excel檔案
xlApp.Workbooks.Open(FileName, 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);
//第一個Workbook
wb = xlApp.Workbooks[1];
//設密碼
wb.Password = "123456";
//另存新檔
wb.SaveAs(@"D:\Inetpub\PORTAL\Test\NewPasswordx.xlsx");
//取得worksheet
ws = (Worksheet)wb.Worksheets[1];
Label1.Text = ws.Name;
//開啟檔案
System.Diagnostics.Process.Start(@"D:\Inetpub\PORTAL\Test\NewPasswordx.xlsx");
}
catch (Exception)
{
throw;
}
}
沒有留言:
張貼留言