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

  1. Pingback: What is GemBox.Spreadsheet – Bug Fixes & Coding Solutions

Leave a comment

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

Blog at WordPress.com.

Up ↑

Design a site like this with WordPress.com
Get started