In this solution we will use only rows, because, usually, tables are «vertically directed» and our template will «grow» from top to bottom. Select whole row or rows, next – go to Formulas, next – go to Define name. Variable name is field name in data structure.įor rows which will be multiplied – create a Named Range: Make templateĮach variable – in square bracket.

+ cost of change (add 2 fields + remove 2 fields + rename 2 fields)Ĭlone source with abapgit.switch application / alt + tab = 3 points.keyboard type: one word / tab / enter = 1 point.mouse click: single click / double click / select = 2 points.Metrics for simplicity (lower is better): If you know easier way – please, notify me. So, if your daily tasks look like that – my solution is the best for you. It’s a good package, I just add some automation to remove routine manual work. replace few variables in template (date, document number, etc.).So, my project is aimed at simplifying the implementation of most common Excel tasks, such: It’s powerful tools, but, in my opinion, for regular and common Excel tasks – it’s overhead and require too much manual action. Inspired by interest and comments on my previous article ( Best way to generate Microsoft word docx from ABAP), I decided to create similar solution for Microsoft EXCEL.įirst of all, I checked these projects on the same topic:

Microsoft excel reader free