.net office interop copy word table to excel

Reading Named Ranges in Excel Worksheet.get_Range Method If you want to select a specific cell in Excel sheet, you can code like this.Įxcel.Worksheet excelSheet = workbook.ActiveSheet Įxcel.Range rng = (Excel.Range)excelSheet.Cells XlWorkSheet = (Excel.Worksheet)_Item(1) Īfter get the selcted worksheet, next step is to specify the used range in worksheet XlWorkBook = 0, true, 5, '', '', true, .XlPlatform.xlWindows, ' ', false, false, 0, true, 1, 0) Next step is to open the Excel file and get the specified worksheet. Select Microsoft Excel 15.0 Object Library of COM leftside menu and click OK button.Īfter import the reference library, we have to initialize the Excel application Object. Select Add Reference dialogue from Project menu of your Visual Studio. How to use COM Interop to Create an Excel Spreadsheetįorm the following pictures you can find how to add Excel reference library in your project. NET, you have to add the Microsoft Excel 15.0 Object Library to you project.Ĭreate a new project in your Visual Studio and add a Command Button to your C# Form. To access the object model from Visual C#. Also you can see how to find Named Ranges in Excel and get the range of occupied cells (Used area) in excel sheet. The following program illustrates how to open an existing Excel spreadsheet in C# using.

Wb.SaveAs('NewXlsxFile.xlsx') //Export as. WorkBook wb = WorkBook.Load('XlsFile.xls') //Import. If we want to create a new file in a custom path then we can use Read the tutorial here to learn more about how to export Excel files in. Remember: Don't forget to write extension with file name while importing or exporting.īy default, new Excel files will be created in the bin>Debug folder of the project. In the code below, our XlsFile.xls file exists in bin>Debug folder of the project. It is very easy to export an Excel file with an. Let's see one by one how easy it can be to export Excel file data into these formats. It is also possible to export the data to. IronXL provides the most accessible way to export the data to Excel with (. IronXL classes can be accessed using IronXL namespace. PM > Install-Package IronXL.Excelĭownload and add its reference in your project.

Download IronXL DLL or install with NuGet for free use in development projects.

For an easy way to work with Excel files in.

.net office interop copy word table to excel