Hello,
I have a lot of attributes that need to be input into specfic cells in an excel template. Some of these cells are merged and some are not.
How would i write each individual attribute into seperate cells based on the template?
Many thanks,
@Takashi Iijima @Mark Stoakes @nielsgerrits @ebygomm @jkr_da @mark2atsafe @jdh
I think when i've done this in the past, I've created namedranges in the templates and written to the named range.
I think when i've done this in the past, I've created namedranges in the templates and written to the named range.
Hello,
Many thanks for the reply, do you have an example of how you did this? Would be good if i could see an excel template file and the workspace?
Thanks
Merged cells in your template are not much of an issue I think. Excel counts the left top corner of the merged cells as the cell the value should be in.
The Excel writer has the option to write based on ColumnPosition and xlsx_row_id. This way you can write values in specific cells.
