The parameters that we need to pass to the get_Range() specify where we want the range to start and where it should end. Here, excelApp refers to an instance of .Application class. Range range = excelApp.get_Range(sheet.Cells, sheet.Cells)
Get an Excel range – For folks familiar with Excel interop, they would be aware that for most operations we would need to get our hands on an Excel Range object and then perform the intended operation on the range. So let’s take a look at the steps involved: To accomplish this, we need to perform 3 steps, and they are as easy as they come – each step requires a single line of code in C#. Specifically, let’s look at how we can merge a collection of cells and center them through. However, there are still many systems that rely heavily on Interop for this so in this post, I will be talking using the Interop approach to work with Excel. To be clear, Open XML is the recommended approach for working with Office applications using. 
Many a times, we need to generate Excel reports as output from Windows applications.
0 kommentar(er)
