Hide Rows in excel using report script

Posted by Ciska de Jager

Posted on Wed, 01/19/2011 - 07:33 in Professional ARIS

Hi,

Is there a report script command that I can use to hide rows in excel when generating an output.

Ciska

20.3k

by Vladimir Bis

Posted on Tue, 02/14/2012 - 08:39

Hi Ciska,

try to set row height to zero - use Report class XlsRow, method setHeight(0).

by Ciska de Jager Author

Posted on Wed, 02/15/2012 - 05:09

Thanks, but i had to hide a few rows so I've used:

sheet2.setRowGroupCollapsed(xpos, true);

Ciska

Rookie

Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.

Recent Unlocks

Klemens Hauk

27 Points

Matthew Crate

25 Points

Paul Doctor

20 Points

Stuart Perren

19 Points

Hans Dieter Koch

15 Points