How to add the dependencies of ExcelDataReader and Excel dataset in Azure functions using C#

Question

Is it possible to add the reference for ExcelDataReader and ExcelDataset in Azure functions? I uploaded dll file of NuGet packages (exceldatareader.3.4.0.nupkg) to the program. But I'm not sure how actually it has to be used. Can anyone help me to achieve this.

#r "Microsoft.WindowsAzure.Storage"
#r "System.IO"
#r "System.Data"
#r "exceldatareader" //*I'm not able to add this reference|*
using System;
using System.IO;
using System.Net;
using System.Runtime.Serialization.Formatters.Binary;
using Microsoft.WindowsAzure.Storage;
using Microsoft.WindowsAzure.Storage.Blob;
using Microsoft.WindowsAzure.Storage.Auth;
using ExcelDataReader;
using System.Data;

Thank you.

please see the whole process - dotnetfunda.com/articles/show/3489/… — Ajay2707
– Ajay2707, Commented Aug 1, 2018 at 12:51
I have added the reference I tried to add in the question above — Sapna
– Sapna, Commented Aug 1, 2018 at 12:56
@ajay2707 That article is regarding console application right. I'm able to complete my task in the console application. I want to implement the same using the Azure functions. using ExcelDataReader; throws error saying, 'reference is missing'. — Sapna
– Sapna, Commented Aug 1, 2018 at 13:04

Jerry Liu · Accepted Answer · 2018-10-25 05:37:45Z

1

To install packages for Azure functions on portal, we need to create dependencies file under function folder. Click View files on the right of function panel, Add file according to runtime.

If your function runtime is ~1, create project.json with following content.

{
  "frameworks": {
    "net46":{
      "dependencies": {
        "ExcelDataReader.DataSet": "3.4.0"
      }
    }
   }
}

If your function runtime is ~2, create function.proj as below.

<Project Sdk="Microsoft.NET.Sdk">
    <PropertyGroup>
        <TargetFramework>netstandard2.0</TargetFramework>
    </PropertyGroup>
    <ItemGroup>
        <PackageReference Include="ExcelDataReader.DataSet" Version="3.4.0"/>
    </ItemGroup>
</Project>

After file created, assemblies will be added to function host environment. Also need to remove unnecessary #r "exceldatareader" or you will got error.

edited Oct 25, 2018 at 5:37

answered Aug 2, 2018 at 9:26

Jerry Liu

17.9k4 gold badges47 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sapna Over a year ago

I have already found the solution. Thank you for your time and help.

Collectives™ on Stack Overflow

How to add the dependencies of ExcelDataReader and Excel dataset in Azure functions using C#

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related