Read XLS file by using the GemBox.Spreadsheet.NET component.

var workbook = ExcelFile.Load("MyWorkbook.xls");
var worksheet = workbook.Worksheets.ActiveWorksheet;
MessageBox.Show(worksheet.Cells["A1"].GetFormattedValue());

EXPLANATION

  1. Excel file will be loaded.
  2. Active worksheet will be selected.
  3. The value of first cell in MessageBox will be displayed.

One thought on “Read XLS file by using the GemBox.Spreadsheet.NET component.”

Add yours

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Create a free website or blog at WordPress.com.

Up ↑

Create your own website, free on WordPress.com.Create your own website.
Start free