如何在C#中从Excel读取数据

或者直接在这里下载DLL

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 206

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 206
Function: _error_handler

File: /var/www/ironpdf.com/application/views/products/sections/banner_home.php
Line: 155
Function: getNuGetImgShield

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 88
Function: view

File: /var/www/ironpdf.com/application/libraries/Widget.php
Line: 27
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 374
Function: load_widget_section

File: /var/www/ironpdf.com/application/controllers/Products/Usecase.php
Line: 41
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

无须互操作读取Excel文件查看所有\b代码示例

using IronXL;
using System;
using System.Linq;

// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Select worksheet at index 0
WorkSheet workSheet = workBook.WorkSheets[0];

// Get any existing worksheet
WorkSheet firstSheet = workBook.DefaultWorkSheet;

// Select a cell and return the converted value
int cellValue = workSheet["A2"].IntValue;

// Read from ranges of cells elegantly.
foreach (var cell in workSheet["A2:A10"])
{
    Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
}

// Calculate aggregate values such as Min, Max and Sum
decimal sum = workSheet["A2:A10"].Sum();

// Linq compatible
decimal max = workSheet["A2:A10"].Max(c => c.DecimalValue);