i want to try copy rows. At first i insert a new row with
- Code: Select all
worksheet->InsertRow(range->row + 1 , range->LastRow);
Can I copy all Datas from range into new Row?
Thanks in advance and Have a nice day !
Lars
worksheet->InsertRow(range->row + 1 , range->LastRow);
using Spire.Xls;
namespace XlsCopyRows
{
class Program
{
static void Main(string[] args)
{
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"..\..\MiscDataTable.xls");
Worksheet worksheet = workbook.Worksheets[0];
int firstColumn = worksheet.FirstColumn;
int lastColumn = worksheet.LastRow;
int firstRow = worksheet.FirstRow;
int lastRow = worksheet.LastRow;
//rows count
int copyRows = lastRow - firstRow + 1;
//insert rows count
worksheet.InsertRow(lastRow + 1, copyRows);
CellRange originDataRang = worksheet.Range[firstRow, firstColumn, lastRow, lastColumn];
CellRange targetDataRang = worksheet.Range[lastRow + 1, firstColumn, lastRow + 1, lastColumn];
worksheet.Copy(originDataRang, targetDataRang, true);
workbook.SaveToFile("Sample.xls");
try
{
System.Diagnostics.Process.Start(workbook.FileName);
}
catch
{
}
}
}
}
ws.Copy(originDataRang, targetDataRang, true, true, true, true);
string path = "c:/CODE/test.xlsx";
Workbook workbook = new();
workbook.LoadFromFile(path/*, ExcelVersion.Version2010*/);
var ws = workbook.Worksheets[0];
int firstColumn = ws.FirstColumn;
int lastColumn = ws.LastColumn;
int firstRow = ws.FirstRow;
int lastRow = ws.LastRow;
//rows count
int copyRows = lastRow - firstRow + 1;
//insert rows count
ws.InsertRow(lastRow + 1, copyRows);
CellRange originDataRang = ws.Range[firstRow, firstColumn, lastRow, lastColumn];
CellRange targetDataRang = ws.Range[lastRow + 1, firstColumn, lastRow + 1, lastColumn];
ws.Copy(originDataRang, targetDataRang, true, true, true, true);
workbook.SaveToFile("c:/CODE/test2.xlsx");
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"test2.xlsx", ExcelVersion.Version2010);
var ws = workbook.Worksheets[0];
int lastColumn = ws.LastColumn;
int firstRow = ws.FirstRow;
int lastRow = ws.LastRow;
//rows count
int copyRows = lastRow - firstRow + 1;
//insert rows count
ws.InsertRow(lastRow + 1, copyRows);
CellRange originDataRang = (CellRange)ws.MaxDisplayRange;
CellRange targetDataRang = ws.Range[lastRow + 1, 1, lastRow + 1, lastColumn];
ws.Copy(originDataRang, targetDataRang, true, true, true, true);
workbook.SaveToFile(@"resut.xlsx");