Change Excel report information

35TlEcDva year ago

Hello,

I want to add a new value to the excel route report.

I added a new column to the /templates/export/route.xlsx file after 'attributes' but it didn't work.

Are there any other files I need to modify to add a new value to this report and how can I format the data contained in the table?

thanks.

Anton Tananaeva year ago

You probably forgot to modify the range in the comments.

35TlEcDva year ago

Ok thanks i see that end Column H instead of I, i can change that on the excel template or in a file in traccar ?

Anton Tananaeva year ago

In the template of course.

35TlEcDva year ago

Yes ty i founded it, first time i use this.
So i added a new column after attribute in "I" column named "temp" and i change the lastcell for I9 and i build a new target file but unfortunatly it doesn't want to show me the "I" column.

35TlEcDva year ago

Hello,

I couldn't get my "I" column to display even after changing the lastCell, do you have any idea what might be blocking it or what I might have forgotten?

Thanks

Anton Tananaeva year ago

Have you changed the range in all the places? There's usually two.

35TlEcDva year ago

Yes i changed the three comments who had lastCells

Anton Tananaeva year ago

No other ideas.

35TlEcDva year ago

Ok i will try to do it again, so to add another column in the route report excel i just need to create my new column in the template and change lastCell to the new column value, that all ?