使用https://pub.dev/packages/excel包

方法

Future<ExcelData> fetchAndReadExcelDirectly() async {
  final response = await http
      .get(Uri.parse('https://go.microsoft.com/fwlink/?LinkID=521962'));
  if (response.statusCode == 200) {
    // The request was successful
    final bytes = response.bodyBytes;
    // Read the Excel file
    var excel = Excel.decodeBytes(bytes);
    var firstTable = excel.tables.keys.first;
    var firstRow = excel.tables[firstTable]?.rows[1];
    //.rows[1]; you can access all rows and get their data.
    if (firstRow == null) {
      throw Exception('The excel file is empty');
    }
    print(ExcelData.fromExcelRow(firstRow));
    return ExcelData.fromExcelRow(firstRow);
  } else {
    // The request failed, throw an exception
    throw Exception('Failed to load Excel file');
  }
}

字符串

模型样本

import 'package:excel/excel.dart';
class ExcelData {
  final String segment;
  final String country;
  final String product;
  final String discountBand;
  final String unitsSold;
  final String manufacturingPrice;
  final String salePrice;
  final String grossSales;
  final String discounts;
  final String sales;
  final String cogs;
  final String profit;
  final String date;
  final String monthNumber;
  final String monthName;
  final String year;
  // You need to organize the data according to their data types and convert them to the relevant types instead of toString below.
 
  ExcelData({
    required this.segment,
    required this.country,
    required this.product,
    required this.discountBand,
    required this.unitsSold,
    required this.manufacturingPrice,
    required this.salePrice,
    required this.grossSales,
    required this.discounts,
    required this.sales,
    required this.cogs,
    required this.profit,
    required this.date,
    required this.monthNumber,
    required this.monthName,
    required this.year,
  });
  // This function works similar to a 'fromJson' method
  factory ExcelData.fromExcelRow(List<dynamic> row) {
    return ExcelData(
      segment: (row[0] as Data).value.toString(),
      country: (row[1] as Data).value.toString(),
      product: (row[2] as Data).value.toString(),
      discountBand: (row[3] as Data).value.toString(),
      unitsSold: (row[4] as Data).value.toString(),
      manufacturingPrice: (row[5] as Data).value.toString(),
      salePrice: (row[6] as Data).value.toString(),
      grossSales: (row[7] as Data).value.toString(),
      discounts: (row[8] as Data).value.toString(),
      sales: (row[9] as Data).value.toString(),
      cogs: (row[10] as Data).value.toString(),
      profit: (row[11] as Data).value.toString(),
      date: (row[12] as Data).value.toString(),
      monthNumber: (row[13] as Data).value.toString(),
      monthName: (row[14] as Data).value.toString(),
      year: (row[15] as Data).value.toString(),
      // Please organize the model according to variable types.
    );
  }
  @override
  String toString() {
    return 'ExcelData{segment: $segment, country: $country, product: $product, discountBand: $discountBand, unitsSold: $unitsSold, manufacturingPrice: $manufacturingPrice, salePrice: $salePrice, grossSales: $grossSales, discounts: $discounts, sales: $sales, cogs: $cogs, profit: $profit, date: $date, monthNumber: $monthNumber, monthName: $monthName, year: $year}';
  }
}

型
如果传入文件是xls：
我们需要使用ASP.NET将文件转换为xlsx。（不幸的是，您无法使用dart进行转换。）
Asp.net核心控制器代码：

[Route("api/[controller]")]
[ApiController]
public class ExcelController : ControllerBase
{
    [HttpPost]
    public IActionResult Post([FromBody] LinkRequest request)
    {
        ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
        using (var client = new WebClient())
        {
            // Download the file data from the provided URL
            var data = client.DownloadData(request.Link);
            using (var reader = ExcelReaderFactory.CreateReader(new MemoryStream(data)))
            {
                var dataSet = reader.AsDataSet();
                var dataTable = dataSet.Tables[0];
                // Convert the DataTable to a list of dynamic objects
                var rows = dataTable.AsEnumerable().Skip(1) // Skip the header row
                    .Select(row => new
                    {
                        Segment = row["Column0"],
                        Country = row["Column1"],
                        Product = row["Column2"],
                        DiscountBand = row["Column3"],
                        UnitsSold = row["Column4"],
                        ManufacturingPrice = row["Column5"],
                        SalePrice = row["Column6"],
                        GrossSales = row["Column7"],
                        Discounts = row["Column8"],
                        Sales = row["Column9"],
                        COGS = row["Column10"],
                        Profit = row["Column11"],
                        Date = row["Column12"],
                        MonthNumber = row["Column13"],
                        MonthName = row["Column14"],
                        Year = row["Column15"]
                    })
                    .ToList();
                // Return the list of rows as a JSON response
                return new JsonResult(rows);
            }
        }
    }
}
public class LinkRequest
{
    public string Link { get; set; }
}

型
并请求样本

的数据
asp.net软件包

的