Export data to excel in PHP

Sir source code dawnload nahi ho Raha hai 🤒 sirf dawnload... or dawnload pending.... ase hi likh k a Raha hai

Working fine on localhost but not downloading on server. Can You please suggest me?

Html pdf file ko excel m export kese kre

ms word min kesy download karin

<?php
include("conect.php");
$sql="SELECT *from Record";
$result=mysqli_query($conn,$sql);

$html= '<table>
<tr>
<th>Sr no</th>
<th>SR No</th>
<th>Student, Name</th>
<th>Father,name</th>
<th>Mother,s Name</th>
<th>Class</th>
<th>Date of Birth</th>
<th>Gender</th>
<th>Mobil No</th>
</tr>';

$i=0;
while($row=mysqli_fetch_assoc($result))
{
$html.='<tr>
<td>'.++$i.'</td>
<td>'.$row['sr'].'</td>
<td>'.$row['name'].'</td>
<td>'.$row['father'].'</td>
<td>'.$row['mother'].'</td>
<td>'.$row['class'].'</td>
<td>'.$row['dob'].'</td>
<td>'.$row['gender'].'</td>
<td>'.$row['mobile'].'</td>
</tr>';
}
$html.='</table>';
header("Content-Type: application/xls");
header("Content-Diposition: attachment;filename=student.xls");
echo $html;

?>
Sir same yeh code likhne par bhi exce me export nahi ho raha h

hi sir wordpress me excel kese download karenge admin menu custom table data ka. please help

You are greate boss

You are greate boss

I have benefited a lot from you. Many problems have been solved.

I have benefited a lot from you. Many problems have been solved.

I have benefited a lot from you. Many problems have been solved.

Thanks

Your are big Supper Man for me.

I love you Vishal bro

You are greate boss

Thanks for sharing this.

the file format and extension of don't match. the file could be corrupted or unsafe

How to solve this problem
Also your download xls file same error is showing

धन्यवाद

Thank you sir
lot of thanks

Fatal error: Uncaught Error: mysqli object is already closed in C:\xampppp\htdocs\demo\export.php:4 Stack trace: #0 C:\xampppp\htdocs\demo\export.php(4): mysqli_query(Object(mysqli), 'SELECT * FROM e...') #1 {main} thrown in C:\xampppp\htdocs\demo\export.php on line 4

I am getting this error in the export.php file pls tell me how to resolve this.

is there any way to to insert data into excel sheet in a particular format

Thanks vishal

Kindly help me to export data in excel in server side error but local working properly

Hello sir how to make invoice in pdf

How to merge two cell in this

Awesome..bro..

Thanks.. Your Explanation helped me out with something I was stuck for hours..

I did this. thanks brother!

can you convert this code to pdo php?

How Can we do the same with ajax request.actually i have to show only selected data which is selected by user in excel

sir this method works but if our data rows exceed more than 10 so its not work any solution for exporting big data

nice 🔥

Sir I have questions if I want to download multiple report in singal file with multiple sheets. Please help

Excellent Brother,
Please also make a video on export using libraries

How can I freeze a column or row like for this case? Do you know?

Thanks Vishal, you really solved my long-overdue work problem with this. Though I still am not quite able to generate pdf file via the code. thanks for this one.

sir selected data kese excel me dwnload karain

When I downloaded the excel, the gridlines are hidden by default. Doesn't happen like this when I open other files. What should I change?

How can I send this file on mail without download?

Thank you Sir very helpful

Sir colour full column me kese download kare

Thank you vishalji. Your videos are really really helpful.

Great way to explain.

Sir I LOVE U

Kya hum JavaScript se html table ko .xlsx me download Kar Sakte hai ?
Mobile me xls file ko kaise open Kar Sakte hai ?

Sir...if column has number valu start with 0 then it removes 0.. Example: if data is 017257, then I get 17257. How can I get original value?

Sir If I have too much data in table then how to download that data and simultaneously clear half data from table ?

very useful video you explain it in very short video whci i like it

How can i use this code in wordpress php custom page ? please help as soon as possible...Thanks

sir student table k sath agr kisi r table sy b data ly k r ak excel file ma kesy show karwayn gy