carboneio / carbone

Fast and simple report generator, from JSON to pdf, xslx, docx, odt...
https://carbone.io
Other
1.29k stars 189 forks source link

Merge cells based on length of the array in the next/previous row #30

Open haydave opened 5 years ago

haydave commented 5 years ago

merged cells.xlsx

It will be great to have something similar to the following: Templater allows you to merges cells vertically if you put a top level tag and a tag for a nested collection in one row.

steevepay commented 4 years ago

Hi @haydave,

First, thanks for your post! Can you explain the usage you want ? Do you want to add dynamic or static data into merges cells ?

haydave commented 4 years ago

Hi @steevepay,

Thanks for the response. My goal is to generate an Excel sheet of employee's attendances. Assume that row 2 (B2-AE2) contains numbers from 1 to 30. I would like to have merged cells in row 1 (B1-AE1) and include the name of the month in it. It should be dynamic in my case but it will be nice to have a possibility to put static data as well.

steevepay commented 4 years ago

Hi @haydave,

Your use case is an interesting usage, unfortunately carbone can't merge cells depending on iterations. We are keeping the idea and we will consider it for next releases. For now, we are fixing major bugs. Thanks again and we will come back to you.