如何在C＃中循环使用excel工作表 [英] How do I loop through excel worksheets in C#

问题描述

我正在尝试循环使用Excel工作表。



我尝试了什么：



这是我到目前为止的代码。它只读取第一张。

I am trying to loop through excel worksheets.

What I have tried:

This is the code I have so far. It only reads the first sheet.

public byte[] GenerateExcel(SLExcelData data)
      {
          var stream = new MemoryStream();
          var document = SpreadsheetDocument
              .Create(stream, SpreadsheetDocumentType.Workbook);

          var workbookpart = document.AddWorkbookPart();
          workbookpart.Workbook = new Workbook();
          var worksheetPart = workbookpart.AddNewPart<WorksheetPart>();
          var sheetData = new SheetData();

          worksheetPart.Worksheet = new Worksheet(sheetData);

          var sheets = document.WorkbookPart.Workbook.
          AppendChild<Sheets>(new Sheets());


          var sheet = new Sheet()
          {
              Id = document.WorkbookPart
              .GetIdOfPart(worksheetPart),
              SheetId = 1,
              Name = data.SheetName ?? "Sheet 1"
          };
          sheets.AppendChild(sheet);

推荐答案

您可以尝试使用以下代码：

you can try with below code:

private void readExcel()
    {
Application excelApp = new Application();
        Microsoft.Office.Interop.Excel.Workbook workBook = excelApp.Workbooks.Open("E:\\List.xlsx");
        foreach (Worksheet sheet in workBook.Worksheets)
        {
            data += "*******   Sheet " + i++.ToString() + "   ********\n";
            foreach (Range row in sheet.UsedRange.Rows)
            {
                
            }
        }

        excelApp.Quit();
}

如果找到解决方案，请将其标记为已解决。



谢谢

please mark it as solved if you find your solution.

Thanks

这篇关于如何在C＃中循环使用excel工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！