topic Re: DOI Excel：How do I insert multiple empty lines in the same format as one line in Application Development and Automation Discussions

DOI Excel：How do I insert multiple empty lines in the same format as one line

former_member828218 — Thu, 29 Dec 2022 02:55:42 GMT

Hi, experts.

As two picture below. I want to insert some empty rows in the same format as row "14", and then I can Insert inner table data to the rows. When I insert the empty rows, other rows like "Rma Discount" and "TOTAL" are down Automatically.

How can I do that using DOI?

pic 1.

pic 2.

Re: DOI Excel：How do I insert multiple empty lines in the same format as one line

Sandra_Rossi — Thu, 29 Dec 2022 08:32:34 GMT

DOI is limited to simple operations like reading values and formats, writing values and formats, not inserting rows, etc. If you want to do special operations, you need to use direct OLE, either by extracting the OLE "object" used by DOI and executing OLE from ABAP, or by using the Script Collection in DOI which is based on VBScript and the Excel object model, both OLE and VBScript will work with the same methods and properties. In all cases, you know which methods and properties are to be used, by using the Excel macro recorder (and then you'll translate in either ABAP OLE or VBScript).

NB: DOI is slow, limited, can run only in foreground, needs Excel to be installed on user's laptop, prefer using abap2xlsx (community API used for more than 10 years) whenever possible.

Re: DOI Excel：How do I insert multiple empty lines in the same format as one line

former_member828218 — Thu, 29 Dec 2022 09:29:36 GMT

Thank you. I will try abap2xlsx

Re: DOI Excel：How do I insert multiple empty lines in the same format as one line

former_member828218 — Thu, 29 Dec 2022 09:37:32 GMT

By the way, Can abap2xlsx achieve the above effect?

Re: DOI Excel：How do I insert multiple empty lines in the same format as one line

Sandra_Rossi — Thu, 29 Dec 2022 15:06:53 GMT

There's no direct feature in abap2xlsx to insert a row by duplicating another row, but you have the Template feature which does it for you:

Best way to generate Microsoft Excel xlsx from template in ABAP | SAP Blogs

It was developed by Anton in a cloned repository, which he later merged into standard abap2xlsx.