Breaking News: Grepper is joining You.com. Read the official announcement!

export to excel in php

Add Answer

Old-fashioned Otter answered on February 22, 2022 Popularity 10/10 Helpfulness 4/10

answer export to excel in php

related create excel file using php]

related html to excel php

export to excel in php

Comment

$queryexport = ("
SELECT username,password,fullname FROM ecustomer_users
WHERE fk_customer='".$fk_customer."'
");

$row = mysql_fetch_assoc($queryexport);

$result = mysql_query($queryexport);
$header = '';

for ($i = 0; $i < $count; $i++){
   $header .= mysql_field_name($result, $i)."\t";
   }

while($row = mysql_fetch_row($result)){
   $line = '';
   foreach($row as $value){
          if(!isset($value) || $value == ""){
                 $value = "\t";
          }else{
                 $value = str_replace('"', '""', $value);
                 $value = '"' . $value . '"' . "\t";
                 }
          $line .= $value;
          }
   $data .= trim($line)."\n";
   $data = str_replace("\r", "", $data);

if ($data == "") {
   $data = "\nno matching records found\n";
   }
}
header("Content-type: application/vnd.ms-excel; name='excel'");
header("Content-Disposition: attachment; filename=exportfile.xls");
header("Pragma: no-cache");
header("Expires: 0");

// output data
echo $header."\n".$data;

mysql_close($conn);`

Popularity 10/10 Helpfulness 4/10 Language php

Source: stackoverflow.com

Tags: export-to-excel php

Link to this answer
Share Copy Link

Contributed on Feb 22 2022

Old-fashioned Otter

0 Answers Avg Quality 2/10

Closely Related Answers

create excel file using php]

Comment

$books = [
    ['ISBN', 'title', 'author', 'publisher', 'ctry' ],
    [618260307, 'The Hobbit', 'J. R. R. Tolkien', 'Houghton Mifflin', 'USA'],
    [908606664, 'Slinky Malinki', 'Lynley Dodd', 'Mallinson Rendel', 'NZ']
];
$xlsx = SimpleXLSXGen::fromArray( $books );
$xlsx->saveAs('books.xlsx');
//  $xlsx->downloadAs('books.xlsx');
//git repo given below

Popularity 10/10 Helpfulness 4/10 Language php

Source: github.com

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Mar 23 2022

uzii

0 Answers Avg Quality 2/10

html to excel php

Comment

// Load PHPExcel library
require_once 'PHPExcel/PHPExcel.php';

// Create a new PHPExcel object
$objPHPExcel = new PHPExcel();

// Load HTML data from a file or any other source
$htmlData = "<table>
                <tr>
                    <th>Name</th>
                    <th>Age</th>
                    <th>Location</th>
                </tr>
                <tr>
                    <td>John Doe</td>
                    <td>25</td>
                    <td>New York</td>
                </tr>
                <tr>
                    <td>Jane Smith</td>
                    <td>30</td>
                    <td>London</td>
                </tr>
            </table>";

// Load HTML data into PHPExcel object
$objPHPExcel->getActiveSheet()->loadHTML($htmlData);

// Set the file format and extension
$objPHPExcel->getActiveSheet()->setTitle('HTML to Excel');
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'HTML to Excel');

// Save the Excel file
$file = 'output.xlsx';
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save($file);

echo "HTML data has been converted to Excel format and saved as $file";

Popularity 8/10 Helpfulness 4/10 Language php

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 11 2023

YOU.com

0 Answers Avg Quality 2/10

export to excel in php

Contents

More Related Answers

export to excel in php

Closely Related Answers

create excel file using php]

html to excel php

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.