学步园

/// <summary><br /> /// 将Excel列的整数索引值转换为字符索引值<br /> /// </summary><br /> /// <param name="n"></param><br /> /// <returns></returns><br /> public string IntToLetter(int n)<br /> {<br /> if (n > 256)<br /> throw new Exception("索引超出范围，Excel的列索引不能超过256！");</p> <p> int i = Convert.ToInt32(n / 26);<br /> int j = n % 26;</p> <p> char c1 = Convert.ToChar(i + 64);<br /> char c2 = Convert.ToChar(j + 64);</p> <p> if (n > 26)<br /> return c1.ToString() + c2.ToString();<br /> else if (n == 26)<br /> return "Z";<br /> else<br /> return c2.ToString();<br /> }

/// <summary><br /> /// 插列（在指定列右边插入指定数量列）<br /> /// </summary><br /> /// <param name="columnIndex"></param><br /> /// <param name="count"></param><br /> public void InsertColumns(int columnIndex,int count,Excel.Worksheet sheet)<br /> {<br /> try<br /> {<br /> Excel.Range range = (Excel.Range)sheet.Columns[Missing.Value, columnIndex];<br /> for (int i = 0; i < count; i++)<br /> {<br /> range.Insert(Excel.XlInsertShiftDirection.xlShiftToRight, Missing.Value);<br /> }<br /> }<br /> catch (Exception e)<br /> {<br /> throw e;<br /> }<br /> }

/// <summary><br /> /// 插行（在指定行上面插入指定数量行）<br /> /// </summary><br /> /// <param name="rowIndex"></param><br /> /// <param name="count"></param><br /> public void InsertRows(int rowIndex,int count,Excel.Worksheet sheet)<br /> {<br /> try<br /> {<br /> Excel.Range range = (Excel.Range)sheet.Rows[rowIndex, Missing.Value];<br /> for (int i = 0; i < count; i++)<br /> {<br /> range.Insert(Excel.XlInsertShiftDirection.xlShiftDown, Missing.Value);<br /> }<br /> }<br /> catch (Exception e)<br /> {<br /> throw e;<br /> }<br /> }

/// <summary><br /> /// 复制行（在指定行下面复制指定数量行）<br /> /// </summary><br /> /// <param name="rowIndex"></param><br /> /// <param name="count"></param><br /> public void CopyRows(int rowIndex,int count,Excel.Worksheet sheet)<br /> {<br /> try<br /> {<br /> Excel.Range range1 = (Excel.Range)sheet.Rows[rowIndex,Missing.Value];<br /> for (int i = 1; i <= count; i++)<br /> {<br /> Excel.Range range2 = (Excel.Range)sheet.Rows[rowIndex + i,Missing.Value];<br /> range1.Copy(range2);<br /> }<br /> }<br /> catch (Exception e)<br /> {<br /> throw e;<br /> }<br /> }

/// <summary><br /> /// 复制列（在指定列右边复制指定数量列）<br /> /// </summary><br /> /// <param name="columnIndex"></param><br /> /// <param name="count"></param><br /> public void CopyColumns(int columnIndex,int rowIndex, int count,Excel.Worksheet sheet)<br /> {<br /> try<br /> {<br /> // range1 = (Excel.Range)workSheet.Columns[columnIndex,this.missing];<br /> Excel.Range range1 = (Excel.Range)sheet.get_Range(this.IntToLetter(columnIndex) + rowIndex.ToString(), this.IntToLetter(columnIndex) + rowIndex.ToString());</p> <p> for (int i = 1; i <= count; i++)<br /> {<br /> // range2 = (Excel.Range)workSheet.Columns[this.missing,columnIndex + i];<br /> Excel.Range range2 = (Excel.Range)sheet.get_Range(this.IntToLetter(columnIndex + i) + rowIndex.ToString(), this.IntToLetter(columnIndex + i) + rowIndex.ToString());<br /> range1.Copy(range2);<br /> }<br /> }</p> <p> catch<br /> {<br /> throw;<br /> }<br /> }