Test in production without watermarks.
Works wherever you need it to.
Get 30 days of fully functional product.
Have it up and running in minutes.
Full access to our support engineering team during your product trial
The C# Excel Library
using IronXL;
using System;
using System.Linq;
// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Select worksheet at index 0
WorkSheet workSheet = workBook.WorkSheets[0];
// Get any existing worksheet
WorkSheet firstSheet = workBook.DefaultWorkSheet;
// Select a cell and return the converted value
int cellValue = workSheet["A2"].IntValue;
// Read from ranges of cells elegantly.
foreach (var cell in workSheet["A2:A10"])
{
Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
}
// Calculate aggregate values such as Min, Max and Sum
decimal sum = workSheet["A2:A10"].Sum();
// Linq compatible
decimal max = workSheet["A2:A10"].Max(c => c.DecimalValue);
In this tutorial, we delve into the process of copying Excel cell content using IronXL in C#. The video guides viewers through copying single cells, entire rows, columns, and even two-dimensional ranges programmatically. To begin, ensure the IronXL library is installed via the NuGet package manager. The demonstration involves importing the IronXL namespace, which provides access to necessary classes and methods. By using functions like GetColumn
and GetRow
, viewers learn to copy data from specified cells or ranges and paste it in desired locations within the same worksheet. The tutorial also covers saving the workbook using the SaveAs
method, allowing users to verify the results. Key examples include copying cell data from C10 to B13, replicating column A into column H, and duplicating a range from D6 to F8. Finally, viewers are encouraged to explore the software's capabilities by downloading it from the provided link. This comprehensive guide highlights the versatility and power of IronXL in automating Excel file manipulation.
PM > Install-Package IronXL.Excel
30-day Trial Key instantly.
15-day Trial Key instantly.
Your trial key should be in the email.
If it is not, please contact
support@ironsoftware.com
Install-Package IronXL.Excel
Have a question? Get in touch with our development team.
No credit card required
Your trial key should be in the email.
successfully.
If it is not, please contact
support@ironsoftware.com
No credit card required
Get started for FREE
No credit card required
Test in production without watermarks.
Works wherever you need it to.
Get 30 days of fully functional product.
Have it up and running in minutes.
Full access to our support engineering team during your product trial
No credit card or account creation required
Your trial key should be in the email.
If it is not, please contact
support@ironsoftware.com
Get started for FREE
No credit card required
Test in production without watermarks.
Works wherever you need it to.
Get 30 days of fully functional product.
Have it up and running in minutes.
Full access to our support engineering team during your product trial
Licenses from $749. Have a question? Get in touch.
Book a 30-minute, personal demo.
No contract, no card details, no commitments.
10 .NET API products for your office documents