excelapplication.cs

工作时用C#编写的WPS密码测试工具,主要用于测试与MSO文件兼容(IO)而写的.功能主要是由MSO文件加密.WPS打开,再由WPS加密,再由MSO打开.每个加密都是根据文件加密类型来加的,此代码.与

using System;
using System.IO;
using System.Threading;
using System.Diagnostics;
using System.Runtime.InteropServices;
using v6SmokeTest;
using v6SmokeTest.PasswordTest.PlugIn.Global;

namespace v6SmokeTest.PasswordTest.PlugIn
{
	/// <summary>
	/// EXCEL应用程序服务类
	/// </summary>
	public class EXCELApplication
	{
        static private Excel.Workbook m_pExcelWorkBook = null;
        static private Excel.Application m_pExcelApp = null;
		static private CaptureException m_pCapEx = null;

        /// <summary>
        /// 构造函数
        /// </summary>
		public EXCELApplication()
		{
		}
		/// <summary>
		/// 传递关闭异常类对象指针
		/// </summary>
		static public CaptureException SetCaptureException
		{set{m_pCapEx = value;}}
		/// <summary>
        /// 创建应用程序实例
        /// </summary>
        /// <param name="quiet">是否显示程序主窗口</param>
        /// <returns>返回启动是否成功</returns>
        static public bool StartProcess(bool quiet)
        {
			bool _blResult = false;
			Thread _pThread = new Thread(new ThreadStart(CloseExcDlg));
			_pThread.Priority = ThreadPriority.Lowest;
			_pThread.Start();
			try
            {
                m_pExcelApp = new Excel.ApplicationClass();
                m_pExcelApp.Visible = quiet;
				_blResult = true;
			}
			catch
			{_blResult = false;}
			try
			{
				_pThread.Abort();
				_pThread = null;
			}
			catch
			{}
			return _blResult;
		}
        /// <summary>
        /// 打开文件
        /// </summary>
        /// <param name="strFilename">打开的文件名</param>
        /// <param name="password">打开文件时的密码</param>
        /// <returns>返回打开成功与否</returns>
        static public bool OpenFile(string strFilename, string password)
        {
            int _nTryTimes = 0;
            bool _blResult = false;
            Thread _pThread = new Thread(new ThreadStart(CloseExcDlg));
            _pThread.Priority = ThreadPriority.Lowest;
            _pThread.Start();
        OpenFileTest:
            try
            {
                object[] _pArgs = {strFilename, 0, false, 3, password, String.Empty, true, 
                Excel.XlPlatform.xlWindows, ' ', true, false, null, false, true, Excel.XlCorruptLoad.xlNormalLoad};
                m_pExcelWorkBook = m_pExcelApp.Workbooks.Open(_pArgs[0].ToString(), _pArgs[1],
                    _pArgs[2], _pArgs[3], _pArgs[4], _pArgs[5], _pArgs[6], _pArgs[7]
                    , _pArgs[8], _pArgs[9], _pArgs[10], _pArgs[11], _pArgs[12]
                    , _pArgs[13], _pArgs[14]);
                _blResult = true;
            }
            catch
            {
                if(_nTryTimes < 5)
                {
                    APIIntegrate.SleepSomeSecond("1000");
                    _nTryTimes ++;
                    goto OpenFileTest;
                }
                else
                    _blResult = false;
            }
            try
            {
                _pThread.Abort();
                _pThread = null;
            }
            catch
            {}
            return _blResult;
        }
		/// <summary>
		/// 处理输入密码对话框等异常对话框线程
		/// </summary>
		static private void CloseExcDlg()
		{
            while(1 == 1)
            {
                IntPtr _nHwnd = APIIntegrate.FindWindow("bosa_sdm_XL9", "密码");
                if(_nHwnd != IntPtr.Zero)
                    APIIntegrate.CloseWindow(_nHwnd);
				APIIntegrate.SleepSomeSecond("500");
				m_pCapEx.CloseExcepWin("PasswordTest", String.Empty);
				APIIntegrate.SleepSomeSecond("500");
			}
        }
        /// <summary>
        /// 转存文件
        /// </summary>
        /// <param name="targetFilename">转存为的文件名</param>
        /// <param name="provider">加密类型的提供者</param>
        /// <param name="name">加密类型名</param>
        /// <param name="password">密码信息</param>
        /// <returns>返回转存是否成功</returns>
        static public bool SaveAs(string targetFilename, string provider, string name, PasswordInf password)
        {
            bool _blResult = false;
            int _nTryTimes = 0;
			Thread _pThread = new Thread(new ThreadStart(CloseExcDlg));
			_pThread.Priority = ThreadPriority.Lowest;
			_pThread.Start();
		SaveAsFileTest:
            try
            {
                m_pExcelWorkBook.SetPasswordEncryptionOptions(provider, name,
                    password.Length, password.EncryFilePro);
                object[] _pArgs = {targetFilename, Excel.XlFileFormat.xlCurrentPlatformText, password.Password, String.Empty,
                false, false, Excel.XlSaveAsAccessMode.xlNoChange, Excel.XlSaveConflictResolution.xlLocalSessionChanges, 
                false, false, false, true};
                m_pExcelWorkBook.SaveAs(_pArgs[0], _pArgs[1], _pArgs[2], _pArgs[3],
                    _pArgs[4], _pArgs[5], (Excel.XlSaveAsAccessMode)_pArgs[6], _pArgs[7], _pArgs[8], 
                    _pArgs[9], _pArgs[10], _pArgs[11]);
                _blResult = true;
            }
            catch
            {
                if(_nTryTimes < 5)
                {
                    APIIntegrate.SleepSomeSecond("1000");
                    _nTryTimes ++;
                    goto SaveAsFileTest;
                }
                else
                    _blResult = false;
            }
			try
			{
				_pThread.Abort();
				_pThread = null;
			}
			catch{}
			if(_blResult && File.Exists(targetFilename))
                return true;
            else
                return false;
        }
        /// <summary>
        /// 杀掉进程
        /// </summary>
        static public void DestroyProcess()
        {
            try
            {
                foreach(Process _pProcess in Process.GetProcessesByName("EXCEL"))
                    _pProcess.Kill();
            }
            catch
            {}
        }
        /// <summary>
        /// 关闭文档
        /// </summary>
        /// <returns>返回关闭成功与否</returns>
        static public bool CloseDocument()
        {
            Object[] _pPars = {false, String.Empty, false};
            try
            {
                m_pExcelWorkBook.Close(_pPars[0], _pPars[1], _pPars[2]);
                return true;
            }
            catch
            {return false;}
        }
    }
}