Skip to main content

Posts

Showing posts from March 1, 2015

Object-oriented programming

Object-oriented programming Object-oriented programming is a programming paradigm that uses abstraction to create models based on the real world. It uses several techniques from previously established paradigms, including modularity, polymorphism, and encapsulation.    Object-oriented programming is intended to promote greater flexibility and maintainability in programming, and is widely popular in large-scale software engineering. Terminology Namespace A container which allows developers to bundle all functionality under a unique, application-specific name. Class Defines the characteristics of the object.   Object An Instance of a class. Property An object characteristic, such as color. Method An object capability, such as walk. It is a subroutine or function associated with a class. Constructor A method called at the moment of instantiation of an object.   Inheritance A class can inherit characteristics from another class. Encapsulation A met

Export XML from Excel 2010

Prerequisites XML file with structure matching the Excel data - can be a previously exported xml file Enable Developer tab in Excel main tabs. This can be done in  Options  -  Customize Ribbon Exporting to xml Open Excel  file If filters are enabled go to  Data  tab and disable them Go to  Developer  tab and click  Source  which will open a sidbar XML Source sidebar. Click  XML Maps...  there In the window that pops up choose  Add map   then choose the previously generated xml, click  ok   in the message box that says that it doesn't contain XML Schema, and click ok to close  XML Maps  window. 5) Drag over the Row element to the A1 cell. This will create the xml mapping. 6) Not the xml mappings are created. Go ahead and save the file as xml.  File  ->  Save as  and choose  File type  as  XML Data .