如何将Excel文件中的值存储到数组中进行测试

我建议您执行以下操作：

关闭量角器的控制流，并切换到异步/等待语法。不建议使用控制流功能，请参阅docs。

以我的经验，了解控制流在幕后发生的事情比切换到异步/等待语法要困难得多。这将使您完全控制代码的执行方式。您可以通过添加SELENIUM_PROMISE_MANAGER: false到量角器配置文件来完成此操作。

因此，您的代码片段必须看起来像这样：

import { AppPage } from './app.po';
import { browser, logging, element, by } from 'protractor';
import { Workbook, Row, Cell, Worksheet } from 'exceljs';
import * as log4js from 'log4js';

describe('E2E Tests', () => {
  let wb: Workbook;
  let sheet: Worksheet;
  let rowObject: Row;
  let cellObject: Cell;
  let deviceName: string;
  let dataContainer: any[];
  let row: any[];
  let logger;

  beforeAll(async () => {
    log4js.configure({
      appenders: { igwan: { type: 'file', filename: 'cheese.log' } },
      categories: { default: { appenders: ['igwan'], level: 'error' } }
    });
    logger = log4js.getLogger('IGWAN');
    logger.level = 'trace';
  });

  beforeEach(async () => {
    const page = new AppPage();

    wb = new Workbook();
    dataContainer = [];
    row = [];

    await browser.sleep(5000);
    await page.navigateToPark();
  });
  //console.log = (msg) => logger.trace(msg);

  it('whatever man', async () => {
    dataContainer = await wb.xlsx.readFile('e2e/src/testsE2E.xlsx').then(() => {
      sheet = wb.getWorksheet('Eqpt');

      for (let k = 1; k <= sheet.rowCount; k++) {
        dataContainer.push([]);
      }

      for (let l = 1; l <= sheet.rowCount; l++) {
        rowObject = sheet.getRow(l);

        for (let m = 1; m <= sheet.columnCount; m++) {
          cellObject = rowObject.getCell(m);
          dataContainer[l - 1].push(cellObject.toString());
        }
      }
      console.log('hello2');

      return dataContainer;
    });

    for (let i = 0; i < dataContainer.length; i++) {
      row = dataContainer[i];

      if (row[0].toString() === '1') {
        deviceName = row[1];

        await element(by.id('device_input')).clear();
        await element(by.id('device_input')).sendKeys(deviceName);
        await element(by.id('search_button')).click();

        for (let j = 2; j <= row.length; j++) {
          switch (j) {
            case 2: {
              //it('should fetch and display correct type data for device ' + deviceName.toString(), () => {
              expect(await element(by.id('type')).getText()).toEqual(
                dataContainer[i][j]
              );
              //});
              break;
            }
            case 3: {
              //it('should fetch and display correct POP data for device ' + deviceName.toString(), () => {
              expect(await element(by.id('pop')).getText()).toEqual(
                dataContainer[i][j]
              );
              //});
              break;
            }
            case 4: {
              //it('should fetch and display correct ipMngt data for device ' + deviceName.toString(), () => {
              expect(await element(by.id('ipMngt')).getText()).toEqual(
                dataContainer[i][j]
              );
              //});
              break;
            }
            case 5: {
              //it('should fetch and display correct internalState data for device ' + deviceName.toString(), () => {
              expect(await element(by.id('internalState')).getText()).toEqual(
                dataContainer[i][j]
              );
              //});
              break;
            }
            case 6: {
              //it('should fetch and display correct prodState data for device ' + deviceName.toString(), () => {
              expect(await element(by.id('prodState')).getText()).toEqual(
                dataContainer[i][j]
              );
              //});
              break;
            }
            case 7: {
              //it('should fetch and display correct currentSwRelease data for device ' + deviceName.toString(), () => {
              expect(
                await element(by.id('currentSwRelease')).getText()
              ).toEqual(dataContainer[i][j]);
              //});
              break;
            }
            case 8: {
              //it('should fetch and display correct hwChassis data for device ' + deviceName.toString(), () => {
              expect(await element(by.id('hwChassis')).getText()).toEqual(
                dataContainer[i][j]
              );
              //});
              break;
            }
            case 9: {
              //it('should fetch and display correct rfsNode data for device ' + deviceName.toString(), () => {
              expect(await element(by.id('rfsNode')).getText()).toEqual(
                dataContainer[i][j]
              );
              //});
              break;
            }
            case 10: {
              //it('should fetch and display correct peId data for device ' + deviceName.toString(), () => {
              expect(await element(by.id('peId')).getText()).toEqual(
                dataContainer[i][j]
              );
              //});
              break;
            }
          }
        }
      } else {
        console.log('Line was marked as skipped by author of .xlsx file');
      }
    }
  });

  //sheet = wb.getWorksheet("POP");
  // TO DO

  //sheet = wb.getWorksheet("Clients");
  // TO DO

  afterEach(async () => {
    // Assert that there are no errors emitted from the browser
    const logs = await browser
      .manage()
      .logs()
      .get(logging.Type.BROWSER);
    expect(logs).not.toContain(
      jasmine.objectContaining({
        level: logging.Level.SEVERE
      } as logging.Entry)
    );
  });
});