Adding new rows with Start End expressions in Excel templates

[maretec]

I'm using Start End expressions in an Excel template.  This template has one tab.  There are 2 tables within this unique tab: the Roof Materials and the Walls Materials tables as shown below.   The tables are defined by the borders.  Each table has 5 rows.

Sometimes  there are more than 5 items (rows). In this scenario, the Start End expressions don't  insert/add new rows so cells are overwritten as seen in the image below.

Is there a way to insert new rows so cells are not overwritten?

[Markus_Malessa]

I might be wrong, but I think that is one of the problems with using a spreadsheet for a template and defining a fixed space with a start/end expression and then using a secondary start/end expression. You might try only a singular row under each material table, but my guess is you will still get data overwritten. Might want to try a document template with tables instead.

[maretec]

Thanks for your answer @Markus_Malessa.  My customer needs the Excel format so I can't try a document.

The content below the Start End expression is always overwritten, no matter if it's only text, a formula or anything else.

[Markus_Malessa]

I have not tried using an XML template, so I don't know if it would retain the formatting correctly while also not overwriting subsequent row blocks, but it could be worth a try. But then you may need to mess around with converting xml back to Excel if that is what your customer wants in the end.

[maretec]

I haven't used XML templates either.  Also, I have to convert it to Excel, just as you mentioned.  Maybe is a solution, but also it's a lot of work.

Thanks for the idea. 

[Marc_Dillon]

No, you can't do that with excel templates. Use a CSV template instead.

[maretec]

Thank you @Marc_Dillon. 

The inconvenience with CSV is that the format will be lost, but I'll give it a try.  If it works I can use for other apps.

[AleksiAlkio]

Have you tried what happens if both of these tables on your template has just 2 rows? Or do you need to have one blank row between these two tables and that's why the existing format?

[maretec]

I need to have one blank row between these two tables as part of the format.

[maretec]

I think I must use Apps Script to add new rows automatically.