Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Setting Excel cell formats

by Samy_rio (Vicar)
on Jul 26, 2007 at 10:31 UTC ( #628890=note: print w/ replies, xml ) Need Help??


in reply to Setting Excel cell formats

Hi merrymonk, you can customize the cell as below:

$sheet->Cells($st, 1)->{NumberFormat} = "mm:ss"; $sheet->Cells($st, 1)->{Value} = "15:59:12";

Regards,
Velusamy R.


eval"print uc\"\\c$_\""for split'','j)@,/6%@0%2,`e@3!-9v2)/@|6%,53!-9@2~j';


Comment on Re: Setting Excel cell formats
Select or Download Code
Re^2: Setting Excel cell formats
by merrymonk (Friar) on Jul 26, 2007 at 14:13 UTC
    Many thanks to all.
    The codes line were just what I wanted.
    I do have another setting question that I posted yesterday.
    As I have not had any replies I have taken the liberty of repeating it below.

    I want to change the values for an Excel spreadsheet that are set
    manually with File->page set up. Below is part of the code I am using.
    All works fine except the $sheet->set_margins_LR which has not effect at all
    $workbook = $excel->Workbooks->Add; $sheet = $workbook->Worksheets("Sheet1"); $sheet->Activate(); $sheet->{Name} = "Tool List"; $sheet_margin = 2; $sheet->set_margins_LR($sheet_margin);
    What should I be doing?

      Hi merrymonk, set the left and right margin value like below

      $sheet1->PageSetup->{LeftMargin} = $Excel->InchesToPoints("0.19"); $sheet1->PageSetup->{RightMargin} = $Excel->InchesToPoints("0.54");

      In the same way, you can set the value of the remaining margin.

      TopMargin BottomMargin HeaderMargin FooterMargin

      Regards,
      Velusamy R.


      eval"print uc\"\\c$_\""for split'','j)@,/6%@0%2,`e@3!-9v2)/@|6%,53!-9@2~j';

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://628890]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (6)
As of 2014-08-30 22:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (294 votes), past polls