Insert blank row dynamically before header

[SH_94]

Hi community,

I would like to ask how do we add the blank row dynamically before the header before rendering it in excel format.

Thank you.

[aatalai]

@SH_94 not overly comfortable with reporting, but I would assume it has to do with the layout tool and having spacing in between sections, hope this helps

[jrlindem · Accepted solution]

After you render your table, you can specify the location of the output to start on cell A2, for example.  This would create that blank row above your table.

Here's an example of how you can output starting at a specific cell location (you might have to specify the full range, I can't remember):  C:\Path\To\Your\File.xlsx|||SheetName!A2

Here's an example of a workflow that builds the cell range and generates an output starting on row 2.  You do have to specify the entire range, so I also added a row count that gets used in a formula to dynamically specify the ending of the range.  Then a formula to build that output string in full:

Workflow also attached for reference.

Hope that helps get you closer, -Jay

[SH_94]

Hi @jrlindem ,

Thank you for the suggestion. 

However, i try to run it with different range as per screenshot below but it prompt the error message . How we can handle different range for multiple data?

Thank you.

[jrlindem]

@SH_94 Similar to how we're dynamically counting the rows (and adding one for the header) you can also use the field info tool to count the number of columns and then add that into your dynamic range.  Give me a min and i'll mock it up.  -Jay

[jrlindem · Accepted solution]

@SH_94 like this (and attached):

So, all we're doing here is using data from the workflow to understand how many rows (plus header) and how many columns and then using formulas to translate that into instructions that can be used in the filepath formula to create the full path you then use in the output tool!

-Jay

[SH_94]

Hi @jrlindem ,

Thanks a lot for the quick response and it is really smart way to solve it.