Bagikan melalui

Excel Demo

Browse code

This is a basic Excel demo sample in .NET Core. It is designed to work with .NET Core 3.1. It is based on the How to automate Microsoft Excel from Microsoft Visual C#.NET sample for .NET Framework.

Key Features

Demonstrates how to consume Office Primary Interop Assemblies (PIA) with .NET Core 3.1.

  • Embedding of Interop types (i.e. No-PIA).
  • Support for the IDispatch interface.

Note Adding COM references to .NET Core projects from Visual Studio is not currently supported. The workaround is to create a .NET Framework project, add the COM references, and then copy the relevant COMReference elements in the project. See ExcelDemo.csproj for further details.

Build and Run

To build and run the sample, you could load it in Visual Studio 2019 or use MSBuild command line. Build support for COMReference elements is not supported in the dotnet tool for the Preview 1 release, but the scenario is demoable from within Visual Studio 2019.

To build and run this sample using Visual Studio:

  1. Install .NET Core 3.1.

  2. Load ExcelDemo.csproj in Visual Studio 2019.

    • Double click on ExcelDemo.csproj in File Explorer.

    or

    • Open a Developer Command prompt and open with devenv.exe ExcelDemo.csproj.

  3. Press F5 to build and debug the project.

To build and run this sample using MSBuild command line:

  1. Install .NET Core 3.1.

  2. Open a Developer Command prompt in the sample directory

  3. Enter the following commands

msbuild -t:Restore;Build ExcelDemo.csproj
bin\Debug\netcoreapp3.1\ExcelDemo.exe