PEAR Forum :: PHP Extension and Application Repository

PEAR Forum Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Excel Spreadsheet-Set Alignment For range of cells

 
Post new topic   Reply to topic    PEAR Forum Forum Index -> PEAR
View previous topic :: View next topic  
Author Message
yuvarajmani



Joined: 29 Aug 2008
Posts: 2

PostPosted: Fri Aug 29, 2008 12:36 pm    Post subject: Excel Spreadsheet-Set Alignment For range of cells Reply with quote

Hi

i had set the alignment of cells by using addFormat(). but since i had nearly 35,000 rows it shows some erros. Pls help me how to set the alignment for Range of cells. im new to php development.

Thanks in Advance
Yuvaraj
Back to top
View user's profile Send private message Send e-mail
mark



Joined: 07 Jan 2007
Posts: 1235

PostPosted: Fri Aug 29, 2008 3:30 pm    Post subject: Re: Excel Spreadsheet-Set Alignment For range of cells Reply with quote

yuvarajmani wrote:
i had set the alignment of cells by using addFormat(). but since i had nearly 35,000 rows it shows some erros.


Do you call addFormat() for every row? I had tried this some months ago, and Excel didn't like that many formats at around 1000 rows. The solution was to call addFormat() only for formats that differ, and to reuse already created formats for the other rows.
Back to top
View user's profile Send private message
yuvarajmani



Joined: 29 Aug 2008
Posts: 2

PostPosted: Fri Aug 29, 2008 9:44 pm    Post subject: Re: Excel Spreadsheet-Set Alignment For range of cells Reply with quote

Thanks for the Reply and i solved it . Once again thanks Mark
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    PEAR Forum Forum Index -> PEAR All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



PEAR Forum topic RSS feed 
Powered by phpBB © 2001, 2005 phpBB Group

Provided by Ministry of Web developement