Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if($_POST)
- {
- $aData=$_POST['txt'];
- $sType='2007 XLSX';
- error_reporting(E_ALL);
- date_default_timezone_set('Europe/London');
- require_once 'Classes/PHPExcel.php';
- $objPHPExcel = new PHPExcel();
- $objPHPExcel->getProperties()->setCreator("Nasgor")
- ->setLastModifiedBy("Gunawan")
- ->setTitle("Office Test Document")
- ->setSubject("Office $sType Test Document")
- ->setDescription("Test document for Office $sType, generated using PHP classes.")
- ->setKeywords("office $sType openxml php")
- ->setCategory("Test result file");
- foreach($aData as $posY=>$aData2)
- {
- for($i=1;$i<6;$i++){ //count($aData2)
- $pos=chr(64+$i).($posY+1);
- $aData2[$i]?$dt=addslashes($aData2[$i]):$dt='';
- $objPHPExcel->setActiveSheetIndex(0)
- ->setCellValue($pos,$dt );
- }
- }
- $objPHPExcel->getActiveSheet()->setTitle('Testing');
- $writeAs='Excel2007';
- $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, $writeAs);
- $objWriter->save('tmp/003data.xlsx');
- header('location:?stat=open');
- die();
- }
- if($_GET['stat']=='open')
- {
- header('Content-type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet') ;
- $fName='tmp/003data.xlsx';
- header('Content-Disposition: attachment; filename="003.xlsx"');
- $f=file_get_contents($fName);
- echo $f;
- die();
- }
- ?><form method="post" enctype='multipart/form-data'>
- <table border=1>
- <tr><th> </th><th>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH></TR>
- <?php
- for($i=0;$i<5;$i++)
- {
- $s.='<tr><td>'.++$n."</td>";
- for($j=1;$j<6;$j++)
- {
- $s.="<td><input type=text
- name='txt[$i][$j]' size=6 />";
- }
- $s.="<tr>\\n";
- }
- echo $s;
- ?>
- </table>
- <br><input name=stat type=submit value='input' />
- </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement