How to read data from XSLX document (MS Office 2007 spreadsheet) using Bytescout Spreadsheet SDK for .NET
This source code sample demonstrates how to read cells from existing .XLSX Excel 2007 spreadsheet file using Bytescout Spreadsheet lib for .NET
Source Excel 2007 XLSX document screenshot:
using System;
using System.Collections.Generic;
using System.Text;
using Bytescout.Spreadsheet;
namespace HelloWorld
{
class Program
{
static void Main(string[] args)
{
// Create new Spreadsheet
Spreadsheet document = new Spreadsheet();
// load from file
document.LoadFromFile(“Hello_world.xlsx”);
// Get worksheet
Worksheet worksheet = document.Workbook.Worksheets.ByName(“Sheet1”);
// Read cell value
Console.WriteLine(“Cell (0,0) value: {0}”, worksheet.Cell(0, 0).ValueAsString);
// Write message
Console.Write(“Press any key to continue…”);
// Wait user input
Console.ReadKey();
}
}
}
Download example source code: bytescoutxls_read_xslx_excel2007.zip (8 KB)