search

felixbuenemann / xlsxtream

Streaming & Fast XLSX Spreadsheet Writer for Ruby
MIT License
216 stars 38 forks source link

Merge Cells #51

Open bprasetyo opened 3 years ago

bprasetyo commented 3 years ago

Add feature merge cells

From this: unmerge

To this: merged

felixbuenemann commented 3 years ago

@bprasetyo Thanks, can you describe your use case for this feature?

bprasetyo commented 3 years ago

@felixbuenemann thanks for your reply, I want to create some report with description at the top of data table, like this: report

but to keep width of cell for data table, i need to merge column A1 and A2 same with column of data table (A1:C1 and A2:C2) instead of using single cell which make column A4-A16 too wide.

also, like this too: report2 which merge cell C4:F4

i know gem Axlsx is good for styling an data excel, but in a real case, i have a big data which needed to create to report like this. so, i want to keep to use this gem because it very fast and low memory usage.

sandstrom commented 3 years ago

I understand if people disagree, but I think the pros of adding this (more capability) should be weighted against added complexity. The primary reason being to keep the complexity down, which makes the project easier to maintain over time.

Maybe it would make sense to add a 'discussions' tab to this repo (github feature) and gauge interested before certain capabilities are added?