frictionlessdata / tabulator-py

Python library for reading and writing tabular data via streams.

https://frictionlessdata.io

MIT License

235 stars 42 forks source link

Handle merged cells for XLSX/XLS load format type #329

Closed cschloer closed 4 years ago

cschloer commented 4 years ago

Overview

We have some datasets coming in that have merged cells. Currently tabulator fills in the first cell with the value and the rest of the cells as None. It would be great if there was an option in tabulator that set every cell within the merged area to the value of the merged cell.

I will share the file in a moment when I get confirmation that is allowedd to be open to the public.

Please preserve this line to notify @roll (lead of this repository)

roll commented 4 years ago

Hi @cschloer,

Have you tried fill_merged_cells - https://github.com/frictionlessdata/tabulator-py#xlsxlsx-read--write

cschloer commented 4 years ago

:facepalm: