Page Index Toggle Pages: 1 Send TopicPrint
Normal Topic How can I limit the number of rows and columns in a sheet? (Read 2511 times)
john
YaBB Newbies
*
Offline


I Love MindFusion!

Posts: 6
Joined: Aug 31st, 2017
How can I limit the number of rows and columns in a sheet?
Sep 4th, 2017 at 8:20am
Print Post  
as title

thanks
  
Back to top
 
IP Logged
 
Meppy
God Member
*****
Offline


MindFusion support

Posts: 1783
Joined: Jul 20th, 2005
Re: How can I limit the number of rows and columns in a sheet?
Reply #1 - Sep 4th, 2017 at 9:51am
Print Post  
Hi,

You can hide the unnecessary rows and columns. For example, to show only the first 10 columns in a sheet, use the following code:

Code
Select All
worksheet.getColumns().get(10, worksheet.getColumns().getCount() - 1).setIsHidden(true); 


Regards,
Meppy
  
Back to top
 
IP Logged
 
john
YaBB Newbies
*
Offline


I Love MindFusion!

Posts: 6
Joined: Aug 31st, 2017
Re: How can I limit the number of rows and columns in a sheet?
Reply #2 - Sep 5th, 2017 at 7:30am
Print Post  
Great ~ Cheesy
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send TopicPrint