How the extension built . . . . .

Office Open XML (XLSX, XLSM, XLTX, XLTM, and XLAM files)


These files are composed of several XML parts, all bundled within a zip-compressed file for efficient storage every feature in the product can be saved into this XML format.
This is how the Extension built -->

What are the main features & characteristic of XSLT?

main features
XSLT uses XML as its syntax
XSLT is a weakly typed language
XSLT is very simple and often too simple
XSLT 2.0 is much more complex and powerful
XSLT is an XML-oriented programming language
XSLT is not designed for large programming tasks
XSLT is the standard language for XML-to-XML transformations

main characteristic 

• templates
• functional
• recursive

Assertiveness IV

Others na behavior can influence our ass behavior therefore we have to handle na from others. Na consists of statements that are tentative, apologetic or self-demanding and there are forms of na which are difficult to detect. When we respond assertively to na we have to retain control our feelings to do that we should being aware of how the other person’s na can influence your own feelings. Then we should have a sound inner dialogue with ourselves.

When we have to deal with na emotions of others try to avoid them and try and get the other person to behave assertively.

To be an ass person we should be ass upwards that means when we dealing with people without considering our position we should express our ideas. For that we should know about how seniority is viewed. To identify that whether we are treading too warily ass upwards we have to check the beliefs we hold about the seniority. There are several beliefs which are barriers to being ass upwards.

We have to remove negative consequences as well to be an ass person. If we are fear to speak up and think that unpleasant things will happen we should change it to be an ass person. By including sound inner dialogue and no fear to mention our own ideas will reduce the fear of negative consequences.

We have to know about our rights and we should decide what kind of responsibility we have to take, and this is a way to negotiating on excessive workloads. When there is increase of work load we don’t have to be under pressure because we have right to negotiate workload but we should aiming to win/win outcome. Having sound inner dialogues we can mentally prepare to handle the situation assertively.

It is risky when we try to raising our workload as a distinct issue, to have a succeed approach to this we need to get timing right, be clear what is acceptable and be clear about our workload.

We have several rights when we are a member of a meeting which we should know to contribute assertively in meeting. Sound inner dialogues also helps for that and also specific behaviors, wider considerations and some sort of nonverbal behavior in meetings.

There are several things how the assertiveness can help to handle future changes in such a way that feel more productive and less stressful. High uncertainty cause to have na and agg therefore we have to handle uncertainty in order to be ass.

Blaming others leads us to have agg behavior and blaming ourselves cause to have na behavior. We should keep blame behaviors to minimum to clarify our own mind and include sound inner dialogues. This helps us to handle our unthinking blame mind mode.

Stress is more demands are placed on us than we feel able to meet. There are several physical and behavioral signs of stress. There are things which cause to stress in us, we have to manage stress through ass to handle stressful situations. And also we have to make sure that we are not creating stress for others.

To improve our assertiveness we should choose the right situation, then prepare for situation, behave assertively while situation and reviewing situations after wards. And also we should be able to handle unexpected situations to be an assertive person.

What is NEW in XSLT 2.0??? User-defined functions...

XSLT 2.0 works with XPath 2.0. for the purposes of XSLT users, the two are linked together.we can't use XPath 2.0 with XSLT 1.0 or XPath 1.0 with XSLT 2.0.

certain areas of missing functionality such as, Multiple output documents, Built-in support for grouping, Conversion of result tree fragments to node-sets, User-defined functions.

User-defined functions

XSLT 2.0 introduces the ability for users to define their own functions which can then be used in XPath expressions.

Functions are defined using the xsl:function element.


format

<xsl:function  name="local:fun" as?=sequence-type override? = "yes" | "no">
content of the function
</ xsl:function>

Assertiveness III

When we need to improve ass in our selves it is important that to handle feelings. We can Stifle (don’t give any outward expression) or Give vent (expressing feeling freely) our feelings.Some feeling are with us from birth and some are learned by experience. Some of these are productive which lead to effective behavior and some are unproductive. Our behavior both before and after the situation will be more assertive if we can ‘Intervene’ in our thinking process with inner dialogue then we can handle unproductive feeling without stifling or giving vent to them.

Giving or receiving criticism is not an easy task when we talking about unsatisfactory aspects of performance. Goal of a criticizing performance is a change in the way a person carries out a particular aspect of their job. To make our criticism assertively we have to not only accept that we have rights which involved with criticism but also requires sound inner dialogues.
When we give criticism there are several steps we can use, taking the initiative in raising an issue with someone. Then concern with setting the scene by announcing the topic for discussion before the criticism. Then we need to assertively to make our criticism and getting agreement to our criticism. Then we encourage other person to come up with suggestions and summarized what has been agreed.

When we receive criticism, we should accept that other person has right to criticize our performance. If we are unclear about the criticism we can ask for clarification. If the criticism is in form of a personal attack we should be able to get out the valid part from it. We have right to disagree if criticism is not acceptable to us. These kinds of actions will lead to receive criticism assertively.

Other people’s agg or na behavior may cause our ass behavior in a bad way. They have the facts, opinions and suggestions they put forward (content) or they have the way they put these facts, opinions and suggestions forward (behavior) these are the two elements of influence. Others behavior may cause us to respond as aggressively or non-assertively.
To be an ass person we have to handle agg from others. Higher level agg which is usually takes form of personal attacks and lower level agg which could be Sarcasm, Blaming, Patronizing, etc. these levels are the different forms of agg.

If we used agg or na to responding to others previously we have to overcome those barriers to respond assertively. There few steps we can use to handle agg from others. Crucial 1st step is getting a sound inner dialogue, then ask the questions assertively. Then we can say more about where we are, and step up your ass at this stage. If it worked then we may experience strong feelings which become barriers to our ass. If that not worked we have two options one is cut off, or second is raising the process level.

We also should be able to handle every day put downs which are not straight forward. We need to decide how we going to handle them in a ass way.

What is XSL ???

XSL = Style Sheets for XML XSL describes how the XML document should be displayed!

XSL consists of three parts
XSLT - transforming XML documents
XPath - navigating in XML documents
XSL-FO - formatting XML documents

Why do we need XSL???Problem???

XML does not use predefined tags, therefore not well understood them.
< table > browser does not know how to display it.
< table > tag in HTML browser knows because HTML uses predefined tags
XSL describes how the XML document should be displayed!

---XSLT---
XSLT stands for Extensible Stylesheet Language Transformations
XSLT is used to transform XML documents into other kinds of documents--usually, but not necessarily, XHTML
XSLT uses two input files:
The XML document containing the actual data
The XSL document containing both the “framework” in which to insert the data, and XSLT commands to do so

---XPath---
XPath is a language for finding information in an XML document.
XPath is a major element in the XSLT standard. Without XPath knowledge you will not be able to create XSLT documents
In XPath, there are seven kinds of nodes: element, attribute, text, namespace, processing-instruction, comment, and document nodes.

---XSL-FO---
XSL-FO is about formatting XML data for output.
It is a language for formatting XML data.
XSL-FO and XSL the same thing

Assertiveness II

Practical process of how can we starting to be more assertive at any work in our life. There are several situations we can figure out.
Situation 1 is “making request”, any difficulties we may experience to making request due to na and agg beliefs. If we believe that we have right to ask for request it will helpful for both parties. There are few hints we can use when we making request such as Be direct, keep short, Don’t justify yourself, give a reason for your request, Don’t apologize plentifully, Don’t sell your request, Don’t play on people relationships, Don’t take refusal in person.
Situation 2 “Disagreeing and stating your views”, we have right to do this. If we don’t use it and believe as na and agg way there may be lots of unsatisfied times in our life. To avoid those problems ass behavior will helpful like State disagreement clearly, Express doubt in constructive way, Use ‘I’ statements, Change your opinion, Give reasons, Identify other’s point of view.
Situation 3 “giving praise”, lots of people are working in places where praise is very rare. Because of na and agg behavior which is not helps to express ourselves appropriately. We can maintain eye contact, keep it brief and clear, make it specific to behave assertively when we giving praise.
Situation 4 “receiving praise”, definitely na and agg behavior affect on receiving praise in negative manner. Therefore to avoiding them we can simply thank, Keep response short, and accept the praise.
Situation 5 “giving bad news”, in here aim is that to pass the information accurately and in a way that it doesn’t damage the others confidence. If we can handle these situations in ass way like Taking the initiative, Give specific bad news, Listen to suggestions and agree, Use ‘I’ statements, etc.
There are several ways to negotiate assertive behavior, both parties will feel pleased if it win/win situation. Compromise may lead both parties dissatisfied. Achieve win/win need to be more ass. Clarifying the other person needs will lead to achieve win/win. Giving out win/win vibes means both verbal and non verbal behavior. This can achieve by State your position positively, Show recognition of the other person needs and state your own needs, Flag that you are aiming for a win/win, Sound and look positive, respect their rights.
Handling hassles while giving win/win can achieve doing Separate out what is valid from what is not, acknowledge their position and restate your own, Ask question to find out needs behind the hassle.
Saying no assertively, when is it appropriate to say “NO”. There are several barriers to say NO assertively, but I have right to say ’NO’. Saying ‘NO’ should slow down and emphasize which not cause to close the conversation.
There are Six types of ass are basic, Empathetic, Discrepancy, negative feelings, Consequence, Responsive. When to use different ass we try to use minimum degree of assertion for achieving our aim.

How to map excel data in to XML file

First go and click on office button --> then click on “Excel options” button at the bottom --> then put the tick on show developer tab in the ribbon.


Then click on the developer tab --> and click source --> then side window will open

Create xml file like this
As an ex -:



Aa
SSEngineer


Aa
SS Engineer



Then click on XML maps button in that side bar and brows the created xml file.



Then click on data and drag and drop on to the ‘name’ in data sheet.


Then you can export the data using developer tab.

After exporting file will be like this




aaa
11


bbb
22


ccc
33



--thusitha--

Assertiveness

Assertiveness behavior merely means that fulfilled the requirements of both parties who involved in the particular situation.
Person who doesn’t know his rights with have negative mind set and always try to avoid conflict and to please others because not enough confidence to say ‘No’ is non assertive (na) behavior.
Short term effects on us due to na are feeling sorry for ourselves, reduction in anxiety, etc. and loose of self-esteem, cause psycho problems, etc are the long term effects. There are some bad effects on others and organizations as well.
Reasons which cause to na behavior are not having confidence about your abilities, fear about what might happen next, don’t know about the rights, encouraged to behave as non assertively, misunderstanding with politeness and non assertiveness, think that it is helpful to others being na.
Aggressive (agg) behavior is always trying to satisfy own needs without giving any respect to others.
Short term effects on us due to agg are may reward us because it leads to satisfy our needs and also it works. In spite of that longer time undesirable effects such as people leave us isolated, unable to keep friendships and job prospect, etc. There are some bad effects on others and organizations as well.
Reasons which cause to agg behavior are believe that is the way to get the job done, earlier na behavior, due to over reacting, unable to develop required skills, etc.
We should be assertive because it leads us to satisfy our needs, it can build personality and confidence in ourselves as well as others, increased responsibility for own behavior and not afraid to make mistakes, etc.
Assertiveness behavior of workers will give more advantages to the company they work such as reduce the company hierarchy; workers are more responsible and not afraid to take decisions, etc.
Verbal aspects can help to identify those types of behaviors. ‘I’ statements, give the opinion simple and up to the point, questions and find out thoughts, suggestions, etc are few verbal aspects of ass.
Confusing statements, self authoritarian, uncertain statements, etc are few verbal aspects of na. Arrogant, own opinion expressed, advisable, sarcasm statements are few verbal aspects of agg. Nonverbal aspect is very important because it can make huge impact on what we are saying such as speech pattern, eye contact, facial expressions, etc.
Beliefs rights and responsibilities are few facts that make effect on assertiveness. To be an ass person he should identify what are his rights? When we accepting rights we have take responsibility for that.
Beliefs also affect unless it is difficult to accept the rights and responsibilities which helps to ensure assertive behavior.