open and write an excel file in dot net

 

How to open an Excel file in C#

  1. Install IronXL Excel Library from NuGet or the DLL download
  2. Use the WorkBook.Load method to read any XLS, XLSX or CSV document.
  3. Get Cell values using intuitive syntax: sheet["A11"].DecimalValue

Install the Excel Library to your Visual Studio Project

IronXL.Excel provides a versatile, advanced, and efficient library for opening, reading, editing and saving Excel files in .NET.

The first step will be to install IronXL.Excel, and this is most easily achieved using our NuGet package, although you may also choose to manually install the DLL to your project or to your global assembly cache.

PM > Install-Package IronXL.Excel

Open an Excel File

  1. using IronXL;
  2. using System;
  4. WorkBook workbook = WorkBook.Load("test.xlsx");
  5. WorkSheet sheet = workbook.DefaultWorkSheet;
  7. Range range = sheet["A2:A8"];
  9. decimal total = 0;
  11. //iterate over range of cells
  12. foreach (var cell in range)
  13. {
  14. Console.WriteLine("Cell {0} has value '{1}", cell.RowIndex, cell.Value);
  16. if (cell.IsNumeric)
  17. {
  18. //Get decimal value to avoid floating numbers precision issue
  19. total += cell.DecimalValue;
  20. }
  21. }
  23. //check formula evaluation
  24. if (sheet["A11"].DecimalValue == total)
  25. {
  26. Console.WriteLine("Basic Test Passed");
  27. }

Write and Save Changes to the Excel File

  1. sheet["B1"].Value = 11.54;
  3. //Save Changes
  4. workbook.SaveAs("test.xlsx");

Summary

In summary, IronXL.Excel is a stand alone .Net software library library for reading a wide range of spreadsheet formats. It does not require Microsoft Excel to be installed, nor depend on Interop.

Further Reading

To learn more about working with IronXL, you may wish to look at the other tutorials within this section, and also the examples on our homepage; which most developers find enough to get them started.

Our Object Reference with specific reference to the WorkBook class.

Information contained on this page is provided by an independent third-party content provider. Frankly and this Site make no warranties or representations in connection therewith. If you are affiliated with this page and would like it removed please contact pressreleases@franklymedia.com