static void Main(string[] args)
{
InitializeWorkbook();
ISheet s = hssfworkbook.GetSheetAt(0);
ICell cell = s.GetRow(4).GetCell(1);
cell.CopyCellTo(3); //copy B5 to D5
IRow c = s.GetRow(3);
c.CopyCell(0, 1); //copy A4 to B4
s.CopyRow(0, 1); //copy row A to row B, original row B will be moved to row C automatically
WriteToFile();
}
private void InsertColumn(int afterColumn, int insertCount, ISheet destSheet)
{
if (insertCount <= 0)
{
return;
}
IEnumerator rowEnumerator = destSheet.GetRowEnumerator();
{
while (rowEnumerator.MoveNext())
{
IRow row = rowEnumerator.Current as IRow;
for (int index = row.LastCellNum - 1; index > afterColumn && index > row.FirstCellNum; index--)
{
ICell cell = row.GetCell(index);
if (cell != null)
{
cell.CopyCellTo(index + insertCount);
}
}
for (int index = 1; index <= insertCount; index++)
{
ICell source = row.GetCell(afterColumn);
ICell dest = row.GetCell(afterColumn + index);
if (dest != null)
{
dest.SetCellValue("");
if (row.RowNum == 0)
{
if (source != null)
{
dest.SetCellValue(GetCellValue(source));
}
}
if (source != null)
{
CopyCell(source, dest, destSheet.Workbook);
}
}
}
}
}
}
public ICell CopyCellTo(int targetIndex)
{
return(_cell.CopyCellTo(targetIndex));
}
