How to transpose sheet with POI SS/XSSF?

Question

I am using POI XSSF API and I would like to transpose a sheet.

how can I do that?

Thanks.

Answer 1

Transpose, as in swap A2 with B1 and A3 with C1 (so columns become rows)?

If so, there's nothing built in, so you'd need to do a little bit of coding yourself. You'd likely want to grab a pair of cells, save the contents of one (value and style), copy the second to the first, then overwrite the second.

See the quick guide if you're not sure on all the reading/writing parts.