/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose(bool disposing)
{
if (useExcel == true)
{
try
{
excelApp.Application.Workbooks.Close();
excelApp.Application.Quit();
excelApp.Quit();
excelBook = null;
excelSheet = null;
excelApp = null;
GC.Collect();
}
catch
{
throw new Exception("Excel 关闭错误！");
}
}
if (disposing)
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose(disposing);
}
public void Dispose()
{
try
{
if (_mExcelApplication != null)
{
Close(false);
_mExcelApplication.Quit();
_mExcelApplication = null;
}
}
catch (Exception ex)
{
Debug.Write(ex.ToString());
}
}
/// <summary>
/// Replace single scripts depend value sheet
/// </summary>
public void DependentValReplace(string source, string file)
{
string _sPath_Source = source;
string _sPath_Destine = file;
object oMissing = System.Reflection.Missing.Value;
System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US");
objExl_Source.EnableEvents = false;
objExl_Source.DisplayAlerts = false;
objExl_Source.Visible = false;
double[] widthOfScripts = new double[15] {
84.75, 134.25, 54, 36.75, 127.5, 220.5, 80.25, 99, 103.5, 132.75, 54, 54, 54, 54, 54
};
// objExl_Source.ScreenUpdating = true;
Excel.Workbook objWBook_Source = objExl_Source.Workbooks.Open(_sPath_Source, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
//ApplicationClass objExl_Destine = new ApplicationClass();
//objExl_Destine.EnableEvents = false;
//objExl_Destine.DisplayAlerts = false;
//objExl_Destine.Visible = false;
// objExl_Destine.ScreenUpdating = true;
Excel.Workbook objWBook_Destine = objExl_Source.Workbooks.Open(_sPath_Destine, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
//Workbook objWBook_Source = objExl_Source.Workbooks.Open(_sPath_Source,
// 0,false,5,oMissing,oMissing,false,XlPlatform.xlWindows,
// oMissing,true,false,0,true,false,false);
//Workbook objWBook_Destine = objExl_Destine.Workbooks.Open(_sPath_Destine,
// 0, false, 5, oMissing, oMissing, false, XlPlatform.xlWindows,
// oMissing, true, false, 0, true, false, false);
string strSheetName = "Scripts";
Excel.Worksheet objWSheet_Source = (Excel.Worksheet)objWBook_Source.Worksheets[strSheetName];
//objWSheet_Source.Copy((Excel.Worksheet)objWBook_Destine.Sheets[objWBook_Destine.Sheets.Count], oMissing);
//strSheetName = "Action DataValDepend";
//objWSheet_Source = (Excel.Worksheet)objWBook_Source.Worksheets[strSheetName];
//objWSheet_Source.Copy((Excel.Worksheet)objWBook_Destine.Sheets[objWBook_Destine.Sheets.Count], oMissing);
Excel.Range range = objWSheet_Source.get_Range(objWSheet_Source.Cells[1, 1], objWSheet_Source.Cells[900, 20]);
// range.Value = "123";
Excel.Worksheet sheet1 = (Excel.Worksheet)objWBook_Destine.Sheets[1];
Excel.Range range1 = sheet1.get_Range(sheet1.Cells[1, 1], sheet1.Cells[900, 20]);
range.Copy(range1);
for (int i = 1; i <= 15; i++)
{
Excel.Range rmgSource = (Excel.Range)objWSheet_Source.Cells[1, i];
Excel.Range rmgDestine = (Excel.Range)sheet1.Cells[1, i];
rmgDestine.EntireColumn.ColumnWidth = rmgSource.EntireColumn.ColumnWidth;
//rmgDestine.EntireColumn.ColumnWidth = widthOfScripts[i - 1];
//rmg.EntireColumn.AutoFit();
//rmg.Width = widthOfScripts[i-1];
//MessageBox.Show(rmg.Width.ToString());
}
foreach (Excel.Worksheet xSheet in objWBook_Source.Worksheets)
{
if (xSheet.Name.Equals("Notes") || xSheet.Name.Equals("Note"))
{
strSheetName = "Notes";
objWSheet_Source = (Excel.Worksheet)objWBook_Source.Worksheets[strSheetName];
objWSheet_Source.Copy(oMissing, (Excel.Worksheet)objWBook_Destine.Sheets[objWBook_Destine.Sheets.Count]);
}
}
//objWBook_Source.Save();
objWBook_Destine.Save();
objWBook_Destine = null;
objExl_Source.Quit();
// objExl_Destine.Quit();
}
//**********************************************************************
/// <summary>
/// Close the excel
/// </summary>
public void close()
{
xBook.Save();
excelMain.Quit();
excelMain = null;
}
