fixed wrong excel column name calculation #71
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Build and Test | |
| # PREREQUISITES FOR PUSH-BACK OF TEST RESULTS | |
| # Please note: test project usually required nuget package JUnitTestLogger | |
| # to be able to provide JUnit compatible test results XML file (required | |
| # for pushing back details on succeeded/failed tests) | |
| # | |
| # NuGet install command: | |
| # - Install-Package JUnitTestLogger | |
| # Controls when the action will run. | |
| on: | |
| # Triggers the workflow on push or pull request events but only for the master branch | |
| push: | |
| branches: [main] | |
| pull_request: | |
| branches: [main] | |
| # Allows you to run this workflow manually from the Actions tab | |
| workflow_dispatch: | |
| env: | |
| # Path to the solution file relative to the root of the project | |
| SOLUTION_FILE_PATH: . | |
| # Configuration type to build | |
| BUILD_CONFIGURATION: CI_CD | |
| jobs: | |
| test: | |
| #needs: build | |
| runs-on: ${{ matrix.os }} | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| #arch: [x86, x86_64, arm] | |
| os: [windows-latest, ubuntu-latest, macos-latest] | |
| include: | |
| - os: macos-latest | |
| runNetExe: mono | |
| # arch: x86_64 | |
| #- os: ubuntu-latest | |
| # arch: x86 | |
| #- os: ubuntu-latest | |
| # arch: x86_64 | |
| #- os: ubuntu-latest | |
| # arch: arm | |
| #- os: windows-latest | |
| # build_configuration_suffix: "_WIN" | |
| # arch: x86 | |
| #- os: windows-latest | |
| # arch: x86_64 | |
| # the build-and-test job might be skipped, we don't need to run this job then | |
| #if: success() || failure() | |
| env: | |
| RESULTS_PATH: TestResults.xml | |
| steps: | |
| - name: Checkout | |
| uses: actions/checkout@v4 | |
| - name: Clone code+test files for subsequent projects | |
| shell: pwsh | |
| run: ./clone-build-files.ps1 | |
| - name: Setup .NET Core | |
| uses: actions/setup-dotnet@v4 | |
| with: | |
| dotnet-version: 8.0.x | |
| - name: Dir Listing (Win) | |
| if: startsWith(matrix.os, 'windows') | |
| run: dir | |
| - name: Dir Listing (Linux/Mac) | |
| if: (!startsWith(matrix.os, 'windows')) | |
| run: ls -la | |
| - name: unixODBC Driver Listing (Linux/Mac) | |
| if: (!startsWith(matrix.os, 'windows')) | |
| continue-on-error: true | |
| run: odbcinst -q -d | |
| - name: Install dependencies | |
| run: dotnet restore /p:Configuration=CI_CD${{matrix.build_configuration_suffix}} | |
| - name: Build | |
| run: dotnet build --configuration=${{env.BUILD_CONFIGURATION}}${{matrix.build_configuration_suffix}} --no-restore | |
| #- name: Run Unit Tests | |
| # run: dotnet test --framework net8.0 --results-directory test-results --logger junit --configuration=${{env.BUILD_CONFIGURATION}}${{matrix.build_configuration_suffix}} --no-restore | |
| - name: Run Unit Tests CompuMaster.MsExcelComInteropTest.dll | |
| run: dotnet test --framework net8.0 --results-directory test-results-CompuMaster.MsExcelComInteropTest.dll --logger junit --configuration=${{env.BUILD_CONFIGURATION}}${{matrix.build_configuration_suffix}} MsExcelComInteropTest/bin/${{env.BUILD_CONFIGURATION}}${{matrix.build_configuration_suffix}}/net8.0/CompuMaster.MsExcelComInteropTest.dll | |
| - name: Run Unit Tests CompuMaster.Excel.Test.dll | |
| run: dotnet test --framework net8.0 --results-directory test-results-CompuMaster.Excel.Test.dll --logger junit --configuration=${{env.BUILD_CONFIGURATION}}${{matrix.build_configuration_suffix}} ExcelOpsTest/bin/${{env.BUILD_CONFIGURATION}}${{matrix.build_configuration_suffix}}/net8.0/CompuMaster.Excel.Test.dll | |
| - name: Run Unit Tests CompuMaster.Excel.TestFreeSpireXls.dll | |
| run: dotnet test --framework net8.0 --results-directory test-results-CompuMaster.Excel.TestFreeSpireXls.dll --logger junit --configuration=${{env.BUILD_CONFIGURATION}}${{matrix.build_configuration_suffix}} ExcelOpsTest-FreeSpireXls/bin/${{env.BUILD_CONFIGURATION}}${{matrix.build_configuration_suffix}}/net8.0/CompuMaster.Excel.TestFreeSpireXls.dll | |
| - name: Run Unit Tests CompuMaster.Excel.TestSpireXls.dll | |
| run: dotnet test --framework net8.0 --results-directory test-results-CompuMaster.Excel.TestSpireXls.dll --logger junit --configuration=${{env.BUILD_CONFIGURATION}}${{matrix.build_configuration_suffix}} ExcelOpsTest-SpireXls/bin/${{env.BUILD_CONFIGURATION}}${{matrix.build_configuration_suffix}}/net8.0/CompuMaster.Excel.TestSpireXls.dll | |
| #- name: Dir Listing (Win) test-results | |
| # if: startsWith(matrix.os, 'windows') | |
| # run: dir test-results | |
| #- name: Dir Listing (Linux/Mac) test-results | |
| # if: (!startsWith(matrix.os, 'windows')) | |
| # run: ls -la test-results | |
| #Following lines maybe required again after test&dev?! | |
| # # the action is useless on pull_request events | |
| # # (it can not create check runs or pull request comments) | |
| # if: always() #&& startsWith(matrix.os, 'ubuntu') #&& github.event_name != 'pull_request' | |
| #- name: Unit Test Results (Linux) | |
| # uses: EnricoMi/publish-unit-test-result-action@v2 | |
| # if: always() && startsWith(matrix.os, 'ubuntu') | |
| # with: | |
| # github_token: ${{ secrets.GITHUB_TOKEN }} | |
| # files: "test-results/TestResults.xml" | |
| # check_run_annotations: all tests | |
| # comment_title: Unit Test Statistics (${{matrix.os}}) | |
| # check_name: Unit Test Results (${{matrix.os}}) | |
| # report_individual_runs: true | |
| #- name: Unit Test Results (Win/Mac) | |
| # uses: EnricoMi/publish-unit-test-result-action/composite@v2 | |
| # if: always() && (!(startsWith(matrix.os, 'ubuntu'))) | |
| # with: | |
| # github_token: ${{ secrets.GITHUB_TOKEN }} | |
| # files: "test-results/TestResults.xml" | |
| # check_run_annotations: all tests | |
| # comment_title: Unit Test Statistics (${{matrix.os}}) | |
| # check_name: Unit Test Results (${{matrix.os}}) | |
| # report_individual_runs: true | |
| - name: Unit Test Results (Linux) CompuMaster.MsExcelComInteropTest.dll | |
| uses: EnricoMi/publish-unit-test-result-action@v2 | |
| if: always() && startsWith(matrix.os, 'ubuntu') | |
| with: | |
| github_token: ${{ secrets.GITHUB_TOKEN }} | |
| files: "test-results-CompuMaster.MsExcelComInteropTest.dll/TestResults.xml" | |
| check_run_annotations: all tests | |
| comment_title: Unit Test Statistics (${{matrix.os}}) CompuMaster.MsExcelComInteropTest.dll | |
| check_name: Unit Test Results (${{matrix.os}}) CompuMaster.MsExcelComInteropTest.dll | |
| report_individual_runs: true | |
| - name: Unit Test Results (Win/Mac) CompuMaster.MsExcelComInteropTest.dll | |
| uses: EnricoMi/publish-unit-test-result-action/composite@v2 | |
| if: always() && (!(startsWith(matrix.os, 'ubuntu'))) | |
| with: | |
| github_token: ${{ secrets.GITHUB_TOKEN }} | |
| files: "test-results-CompuMaster.MsExcelComInteropTest.dll/TestResults.xml" | |
| check_run_annotations: all tests | |
| comment_title: Unit Test Statistics (${{matrix.os}}) CompuMaster.MsExcelComInteropTest.dll | |
| check_name: Unit Test Results (${{matrix.os}}) CompuMaster.MsExcelComInteropTest.dll | |
| report_individual_runs: true | |
| - name: Unit Test Results (Linux) CompuMaster.Excel.Test.dll | |
| uses: EnricoMi/publish-unit-test-result-action@v2 | |
| if: always() && startsWith(matrix.os, 'ubuntu') | |
| with: | |
| github_token: ${{ secrets.GITHUB_TOKEN }} | |
| files: "test-results-CompuMaster.Excel.Test.dll/TestResults.xml" | |
| check_run_annotations: all tests | |
| comment_title: Unit Test Statistics (${{matrix.os}}) CompuMaster.Excel.Test.dll | |
| check_name: Unit Test Results (${{matrix.os}}) CompuMaster.Excel.Test.dll | |
| report_individual_runs: true | |
| - name: Unit Test Results (Win/Mac) CompuMaster.Excel.Test.dll | |
| uses: EnricoMi/publish-unit-test-result-action/composite@v2 | |
| if: always() && (!(startsWith(matrix.os, 'ubuntu'))) | |
| with: | |
| github_token: ${{ secrets.GITHUB_TOKEN }} | |
| files: "test-results-CompuMaster.Excel.Test.dll/TestResults.xml" | |
| check_run_annotations: all tests | |
| comment_title: Unit Test Statistics (${{matrix.os}}) CompuMaster.Excel.Test.dll | |
| check_name: Unit Test Results (${{matrix.os}}) CompuMaster.Excel.Test.dll | |
| report_individual_runs: true | |
| - name: Unit Test Results (Linux) CompuMaster.Excel.TestFreeSpireXls.dll | |
| uses: EnricoMi/publish-unit-test-result-action@v2 | |
| if: always() && startsWith(matrix.os, 'ubuntu') | |
| with: | |
| github_token: ${{ secrets.GITHUB_TOKEN }} | |
| files: "test-results-CompuMaster.Excel.TestFreeSpireXls.dll/TestResults.xml" | |
| check_run_annotations: all tests | |
| comment_title: Unit Test Statistics (${{matrix.os}}) CompuMaster.Excel.TestFreeSpireXls.dll | |
| check_name: Unit Test Results (${{matrix.os}}) CompuMaster.Excel.TestFreeSpireXls.dll | |
| report_individual_runs: true | |
| - name: Unit Test Results (Win/Mac) CompuMaster.Excel.TestFreeSpireXls.dll | |
| uses: EnricoMi/publish-unit-test-result-action/composite@v2 | |
| if: always() && (!(startsWith(matrix.os, 'ubuntu'))) | |
| with: | |
| github_token: ${{ secrets.GITHUB_TOKEN }} | |
| files: "test-results-CompuMaster.Excel.TestFreeSpireXls.dll/TestResults.xml" | |
| check_run_annotations: all tests | |
| comment_title: Unit Test Statistics (${{matrix.os}}) CompuMaster.Excel.TestFreeSpireXls.dll | |
| check_name: Unit Test Results (${{matrix.os}}) CompuMaster.Excel.TestFreeSpireXls.dll | |
| report_individual_runs: true | |
| - name: Unit Test Results (Linux) CompuMaster.Excel.TestSpireXls.dll | |
| uses: EnricoMi/publish-unit-test-result-action@v2 | |
| if: always() && startsWith(matrix.os, 'ubuntu') | |
| with: | |
| github_token: ${{ secrets.GITHUB_TOKEN }} | |
| files: "test-results-CompuMaster.Excel.TestSpireXls.dll/TestResults.xml" | |
| check_run_annotations: all tests | |
| comment_title: Unit Test Statistics (${{matrix.os}}) CompuMaster.Excel.TestSpireXls.dll | |
| check_name: Unit Test Results (${{matrix.os}}) CompuMaster.Excel.TestSpireXls.dll | |
| report_individual_runs: true | |
| - name: Unit Test Results (Win/Mac) CompuMaster.Excel.TestSpireXls.dll | |
| uses: EnricoMi/publish-unit-test-result-action/composite@v2 | |
| if: always() && (!(startsWith(matrix.os, 'ubuntu'))) | |
| with: | |
| github_token: ${{ secrets.GITHUB_TOKEN }} | |
| files: "test-results-CompuMaster.Excel.TestSpireXls.dll/TestResults.xml" | |
| check_run_annotations: all tests | |
| comment_title: Unit Test Statistics (${{matrix.os}}) CompuMaster.Excel.TestSpireXls.dll | |
| check_name: Unit Test Results (${{matrix.os}}) CompuMaster.Excel.TestSpireXls.dll | |
| report_individual_runs: true | |
| #- name: Publish Unit Test Results | |
| # uses: actions/upload-artifact@v4 | |
| # if: always() | |
| # with: | |
| # name: NUnit Test Results ${{ matrix.os }} | |
| # path: test-results/TestResults.xml | |
| - name: Publish Unit Test Results CompuMaster.MsExcelComInteropTest.dll | |
| uses: actions/upload-artifact@v4 | |
| if: always() | |
| with: | |
| name: NUnit Test Results ${{ matrix.os }} - CompuMaster.MsExcelComInteropTest | |
| path: "test-results-CompuMaster.MsExcelComInteropTest.dll/TestResults.xml" | |
| - name: Publish Unit Test Results CompuMaster.Excel.Test.dll | |
| uses: actions/upload-artifact@v4 | |
| if: always() | |
| with: | |
| name: NUnit Test Results ${{ matrix.os }} - CompuMaster.Excel.Test | |
| path: "test-results-CompuMaster.Excel.Test.dll/TestResults.xml" | |
| - name: Publish Unit Test Results CompuMaster.Excel.TestFreeSpireXls.dll | |
| uses: actions/upload-artifact@v4 | |
| if: always() | |
| with: | |
| name: NUnit Test Results ${{ matrix.os }} - CompuMaster.Excel.TestFreeSpireXls | |
| path: "test-results-CompuMaster.Excel.TestFreeSpireXls.dll/TestResults.xml" | |
| - name: Publish Unit Test Results CompuMaster.Excel.TestSpireXls.dll | |
| uses: actions/upload-artifact@v4 | |
| if: always() | |
| with: | |
| name: NUnit Test Results ${{ matrix.os }} - CompuMaster.Excel.TestSpireXls | |
| path: "test-results-CompuMaster.Excel.TestSpireXls.dll/TestResults.xml" | |