On 2020/03/20 18:26:04, Tomasz Melcer <[email protected]> wrote: > However, I cannot find information on how to recognize merged cells in a > streaming fashion. Is it even possible? As far as I know, in case of xlsx > files, information on which cells are in a merged region is stored in the > <mergeCells> element of the sheet xml, and in my example files this element > is at the end of the file.
I ended up writing my own parser that using XSSFReader seeks the following template: <mergeCells count="2"> <mergeCell ref="A1:B2" /> <mergeCell ref="C3:D4" /> </mergeCells> I do two runs over each sheet: first to detect merged cells, second to actually parse content. So far it works, and the first run is surprisingly fast. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
