Spread sheet issues-vertcal align not working using php

PHP
1

hi all

please check the attached image .Can anyone know about how can I generate
text in vertical style in spreadsheet using pear as it is shown in the attached image.

In site point,Image verification takes time please check this link
Attached image link
Thanks

2

hi all

I need to show the text in vertical style using pear in php

any one done this kind of subject?

Thanks

3

Hello,

I don’t use PEAR for creating Excel spreadsheet but directly xhtml code with header like “application/excel” and <style> balise which permit a lot of configuration for recent excel software versions.

If it can help …

4

tried below code but not getting text in vertical style in Excel using pear spreadsheet package
please help me to solve.if any one want to use you may try to use pear spreadsheet package.


<?php 
// Include PEAR::Spreadsheet_Excel_Writer 
require_once "Writer.php"; 

// Create an instance 
$xls =& new Spreadsheet_Excel_Writer(); 
$sheetTitleFormat =& $xls->addFormat(array('bold'=>1,
  'size'=>10));
//$sheetTitleFormat=& $xls->addFormat(array('vAlign'=>'vcenter'));

// Send HTTP headers to tell the browser what's coming 
$xls->send("test.xls"); 

// Add a worksheet to the file, returning an object to add data to 
$sheet =& $xls->addWorksheet('Binary Count'); 
 $xls->addFormat(array('vAlign'=>'vcenter'));
$sheet->write(0,0,'Name',$sheetTitleFormat); 
$sheet->write(0,1,'Address',$sheetTitleFormat);
$sheet->write(0,2,'Town',$sheetTitleFormat); 
$sheet->write(0,3,'City',$sheetTitleFormat); 

$col=0;
$row=2;
// Write some numbers 
for ( $i=2;$i<11;$i++ ) { 
if($col==4)
{
$col=0;
$row= $row+1;
}

 // Use PHP's decbin() function to convert integer to binary 
 $sheet->write($row,$col,decbin($i)); 
$col=$col+1;
} 

// Finish the spreadsheet, dumping it to the browser 
$xls->close(); 


?>