问C#转到类的精确实例

EN

...
class ExcelHandler
    {
        static Excel.Application xlApp;
        static Excel.Workbook xlWorkBook;
        static Excel.Worksheet xlWorkSheet;
        static object misValue = System.Reflection.Missing.Value;

        static string _filename;

        public ExcelHandler(string filename)
        {
            openExcel(_filename);
        }

        internal static bool openExcel(string filename)
        {
            _filename = filename;
        ... other code ...
        internal Array GetRange(string range)
        {
        Array xlValues;
        string[] rangeSplit = range.Split(':');
        Excel.Range xlRange = xlWorkSheet.get_Range(rangeSplit[0], rangeSplit[1]);
        xlValues = (Array)xlRange.Cells.Value;
        return xlValues;
        }
        ... other code ...

ExcelHandler eh01 = new ExcelHandler(file01); // file for write to
for (blahblah) {  // 1 to 5
  ExcelHandler eh02 = new ExcelHandler(file02);
  Array licLoad = eh02.GetRange("C5:CB5");
  eh02.closeExcel();
  foreach (blahbla) // 26 values
  {
     eh01.insertCell(f.ToString(), row++, 3);
  }
}
eh01.closeExcel();