How to overcome System.IO.Packaging.Package error while working with OpenXML SDK

-

Hi,

Okay this error will occur when you try to work with OpenXML SDK 2. Now You are added OpenXML dll and added OpenXML related to namespaces to the class...and you are good to build the solution. when you press the Build (F5) Button, Visual studio shows you a crazy error. and most of you try to add System.IO namespace to the solution or calss to overcome this. To be honest in first time I also tried. he he heeeee. but that's not the solution for this error.


When you are working with OpenXML namespace this is a very common error and It's not a very complex error. you can fix this problem very easily. so what you have to do is go to project's reference area in the solution explorer and right click to add a new reference then in the reference browser dialog select and add WindowsBase.dll in Framework Assemblies Tab.



Okay that's all. press Build (F5) Button again. if you did other things correctly (joking) It'll build smoothly. Have a nice day folks. 

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