> Its still to short. >From the WriteExcel docs:
"The width corresponds to the column width value that is specified in Excel. It is approximately equal to the length of a string in the default font of Arial 10." So if you are using a different font or different size it could be way off. You just need to play with it to get a good fit. Maybe the length of the target string times 2 (or 1.5, etc). Rob -----Original Message----- From: Paul Kraus [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 4:17 PM To: 'Wagner, David --- Senior Programmer Analyst --- WGO' Cc: [EMAIL PROTECTED] Subject: RE: Spreadsheet::WriteExcel Column width That is what I am currently doing. So $maxwidth= length $mylargeststring But if I then set the width to that length it does not work. Its still to short. Any ideas? -----Original Message----- From: Wagner, David --- Senior Programmer Analyst --- WGO [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 3:46 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Spreadsheet::WriteExcel Column width Paul Kraus wrote: > Is there any way to set the column width to the be as wide as the > longest cell in that column? > > Paul Kraus $MyWorkSheet->set_column(Col1, Col2, widthdesired); Now to get width desired, need to do a length of the data being processed and save the largest to be applied vs the col(s) desired. Wags ;) ********************************************************** This message contains information that is confidential and proprietary to FedEx Freight or its affiliates. It is intended only for the recipient named and for the express purpose(s) described therein. Any other use is prohibited. **************************************************************** -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
