How to Overcome Microsoft.Office.Interop.Excel errors in Visual Studio 2012

-
When you are developing Excel Applications in visual Studio 2012 not sure about Visual studio 2010 (didn't have time to check on that) you will get some kind of harsh errors every developer don't want to see....Ha ha joking.. so when These error occurs I'm doing a simple trick to overcome those things. In the below I mention that trick in a step by step manner.

  •  So these are the some of errors you will get when you build the application  

  • To solve these kind of problems you can do various things. you can use Appropriate Application Interface to overcome some problems but when comes to the coding I'm bit lazy....ha ha joke  again.so What I'm doing is Go Project Properties and Change the Target FrameWork to 3.5 or low



  • And remove System.Threading.Tasks namespace from your project. And Rebuild it...It should work smoothly. Hope This will help you.... See you soon.

Comments

Post a Comment

Popular posts from this blog

Deep dive into OpenXML Part 1

-
Image
Okay guys today I'm going to say about the Excel manipulation using the OpenXML. you can do various things using OpenXML and here I'm going to explain most important things you should know about OpenXML when comes to the Excel programming. okay then let's start. First of all go to visual studio and create a console Application. To work with OpenXML you need to add several Dlls to your project. so after you create the project then go to project reference and add following dlls.        1. DocumentFormat.OpenXml. you can download this dll from here .        2. WindowsBase okay now we are half there. now our project is ready to welcome the OpenXML. so let start coding and make some application.       so now we need to add a class called ExcelUtilities to put our common method which we are going to  use every time. so let's go and create that class and add those common methods and don't forget to add these namespaces t...
Read more

Deep dive into OpenXML Part 2

-
Image
So In the Deep dive in to OpenXML part 1 I showed you the common methods which we can use to generate an excel file. but most of you are not aware to use those methods so today i'm going to show you the way to use those method and generate an excel file.  for this exercise use a Console application project. Excel File Generator Class /// <summary> /// File Generator Class /// </summary> class FileGenerator { #region Variable Declaration /// <summary> /// Column Span for Grouping /// </summary> private const string ColSpanLine = "1:4"; private const string SheetName = "Sample"; #endregion #region Public Methods /// <summary> /// Generates the report. /// </summary> /// <param name="reportList">The report list.</param> /// <param name="fileLocation">Th...
Read more

Convert XML data to dynamic (ExpandoObject) Object

-
Image
public static IEnumerable<dynamic> GetExpandoFromXml(string file, string descendantid) { var expandoFromXml = new List<dynamic>(); var doc = XDocument.Load(file); var nodes = doc.Root.Descendants(descendantid); foreach (var element in doc.Root.Descendants(descendantid)) { dynamic expandoObject = new ExpandoObject(); var dictionary = expandoObject as IDictionary<string, object>; foreach (var child in element.Descendants()) { if (child.Name.Namespace == "") dictionary[child.Name.ToString()] = child.Value.Trim(); } yield return expandoObject; } }
Read more