Application Development Blog Posts
Learn and share on deeper, cross technology development topics such as integration and connectivity, automation, cloud extensibility, developing at scale, and security.
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

One of my maiden attempts at creating an excel output in SAP, was using the iXML method.

I found plenty of resources across SCN and other sites which explained how to create an excel.

But what I had trouble with was finding the right attributes to suit my requirements.

Below, I have noted down the attributes that I had used in my developments from my experience.

This is an attempt to add and accumulate all the attributes developers to add to / correct the below attributes.

Sr. No

ElementAttributeValuesUseChild of

Things to Note

1BorderPositionBottom
Left
Top
Right
Bottom Border Position
Left Border Position
Top Border Position
Right Border Position
Borders
2LineStyleContinuous
Dotted
Continuous Border
Dotted Border
3Weight< Any Numeric Value >Weight of the border line
4DataTypeString
Number
Cell contains string data
Cell contains numeric data. (Needed to perform numeric calculations)
Cell
5CellStyleID< Name of style >Apply style to cellRow
6Index< Any Numeric Value >Numeric position of cell
7MergeAcross< Any Numeric Value >Merge cells horizontallyIt is mandatory to specify indexes if you are using MergeAcross
8MergeDown< Any Numeric Value >Merge cells verticallyIf you do a MergeDown, it is not required to create a row explicitly for the subsequent row, but it is required to specify atleast one cell in the following row using an index
9FontFontName< Required font installed in system>Apply a font to a styleStyle
10Bold1
< space >
Bold font
Normal font
11UnderlineSingle
Double
Single Underline
Double Underline
12Color< Any color name or hex value >Apply color to font
13Size< Any Numeric Value >Change font size
14AlignmentHorizontalLeft
Right
Center
Align text left horizontally
Align text right horizontally
Align text center horizontally
15VerticalTop
Bottom
Center
Align text top vertically
Align text bottom vertically
Align text center vertically
16Workbookxmlns< xml name space to be used >Part of open office specification.Document
17StyleID< Any Name >Assign name to your styleStyles
18NumberFormatFormat< example '0.00' >
<example '0,000.00'>
Set the number format in the cellStyleShould be preceeded with a format attribute with value '@'
If you do not specify the number of decimals, no decimals will be displayed
19WorksheetName< any name >Name to be assigned to the worksheetRoot
20TableFullColumns1 or 0Display and use all columnsWorksheet
21FullRows1 or 0Display and use all rows
22ColumnWidth< Any Numeric Value >Set column widthTable
1 Comment