Pushing the output data to an excel template

[Ganesshh_95]

Hi All,

Greetings for the day!!!!

I wanted to push my output data to a excel template which I have created. 

I tried to push my output data to excel template & was working fine. My template has 1774 rows. 

If my output data has the same number of rows like that of the excel template (1774 rows) then its working fine.

But if the number of rows of my output data increases then I couln't able to push the data to excel template (I am not able to get the format which I wanted in my output data)

Please help me to resolve this problem which I am facing!!!!

Thanks in advance!!!

[PhilipMannering]

Unless you're willing to do some VBA or Python, you might have to settle for conditionally formatting the cells of your template when a column (which you know is always going to have data) is not empty.

[sergejs_kutkovics · Accepted solution]

@Ganesshh_95, if you use the Output Data tool, you can specify the last Excel row as your data range limit. You won't be able export more rows to Excel in any case. )