Skip to main content

CONVERT PHP ARRAY INTO EXCEL FILE

CONVERT PHP ARRAY INTO EXCEL FILE 


<?php

header("Content-Type: application/vnd.ms-excel");

header("Content-disposition: attachment; filename=spreadsheet.xls");

$exhibition = array(

  array('id' => '1','name' => 'Mr N .Vishwanath','jobTitle' => 'Director','company' => 'SLV 
RUBBERPRODUCTS','address' => 'Shed No 7,7th Main ,Doddanna Indl Area')

);

 
echo "<table border='1'>";
foreach($exhibition as $data ){
 echo "<tr>";
  foreach($data as $key=>$val ){
   echo "<td>";
   echo   $val ;  
  echo "</td>";
  }
 echo "</tr>";
}
echo '</table>';
echo $i;

 
?>

Comments

Popular posts from this blog

how send mail using Swift mailer | switmailer send mail tutorial

how send mail using Swift mailer | switmailer send mail tutorial  <?php /* step 1 include Swift mailer file ;  */ include("vendor/swiftmailer/swiftmailer/lib/swift_required.php"); /* step 2 create your user details */ $senderEmail="saddam1234321@gmail.com"; $senderPassword="****Your password****"; $senderName="Saddam huassin"; /* step 3 set SMTP host  for sending mail  */ $user = Swift_SmtpTransport::newInstance('smtp.gmail.com','587','tls'); /* step 4 set your user details  */ $user->setUsername($senderEmail); $user->setPassword($senderPassword); /* step 5 create swift  mailer instance with a variable */ $mailer = Swift_Mailer::newInstance($user); /* step 6 Create a message */ $message = Swift_Message::newInstance('Wonderful Subject')   ->setFrom(array($senderEmail => $senderName))   ->setTo(array($senderEmail))   ->setBody('Here is the message itsel...

how install Swift mailer in localhost | swift mailer installation | composer install swift mailer

how install Swift mailer in localhost | swift mailer installation | composer install swift mailer Step 1:- open cmd  Step 2;- copy this command " composer required swiftmailer/swiftmailer @stable " . Step 3;- paste in cmd and press enter. Step 4;- after few second swift mailer ready to use .................................