Could not load type system.runtime.compilerServices.CallSite

Question

Could not load type system.runtime.compilerServices.CallSite

Kao Xue LIU (SP) 0

system.runtime.compilerServices.CallSite error when accessing Excel by C#

Answer 1

Limitless Technology 41,191

Hello there,

Can you share your code so that it might for the community?

Because the error is generic, it is difficult to detect the source.

I suggest to check if all involved objects are valid. Another check might be trying to read the cell first.

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer–

Kao Xue LIU (SP) 0

Thanks for your answer.

I am trying to develop a Revit Addin which will extract Revit model information and export to Excel.

Here is the using part:

using System;

using System.Collections.Generic;

using System.Linq;

using Excel = Microsoft.Office.Interop.Excel;

using System.Reflection;

using Autodesk.Revit.DB;

using Autodesk.Revit.UI;

using Autodesk.Revit.UI.Selection;

using Autodesk.Revit.ApplicationServices;

using Autodesk.Revit.Attributes;

using Autodesk.Revit.UI.Events;

using System.Diagnostics;

using System.ComponentModel.DataAnnotations.Schema;

using System.IO;

//

... ...

//

I have tried to debug the code line by line until it reached to the part below.


            //
            try
            {
                // Excel
                string xslFilename = "D:/AY2324/BE8136BIM/BIMDevelopment/Summary.xlsx";
                Excel.Application oXL;
                oXL = new Excel.Application();
                oXL.Visible = true;

                Excel._Workbook oWB;
                oWB = oXL.Workbooks.Open(xslFilename);
                Excel.Range oRng;
                Excel._Worksheet oSheet; // up to here the code works well
                //oWB=oXL.Worksheets[1].Activate(); // Err message when this line is added
       // Err message : Could not load type  ' System.Runtime.CompilerServices.CallSite'1 from assembly 'System.Ling.Expessions, ... ...


                 //oSheet=(Excel._Worksheet) oWB.ActiveSheet(); // Nor does this line work

Could not load type system.runtime.compilerServices.CallSite

1 answer

Activity