Export data to excel in PHP

[@hemantsharma7433]

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

[@emadkhan1002]

Maaaan, you have every answers of my questions!!... Thanks for such a channel maaan!!... ❤️❤️😍😍😍

[@devadaths2646]

Sooper .. You are my Master ....

[@highway_resident06]

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.

[@sizeiv7694]

Thank you for the information, it really helped even without understanding the words you were saying but i could really follow how you were doing things :). You earned my subscription :D

[@priyanksagar4391]

Thank you vishalji. Your videos are really really helpful.

[@karanpreetsingh8733]

Thank you Sir very helpful

[@piyushnagwani6017]

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

[@nidhibaisla8234]

Very nice explanation ...sir ..be continue..

[@ProgrammingwithVishal]

Thank you, I will

[@jamalrazakhan4409]

sir agar ham xls ke place par pdf like to content pdf main download ho jayega

[@dmndulan9363]

I did this. thanks brother!

[@ivandez1811]

I didn't understand any single word you said but thanks my indian friend, hello from venezuela

[@shaktisinhjadeja9853]

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

[@sohils2012]

Thanks for sharing this.

[@ayushprajapati9251]

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

[@kameshvalodara6469]

Just Superb Sir!!👌

[@ProgrammingwithVishal]

Thanks Kamesh

[@MaazDev1]

Amazing bro. Your way of explanation is very impressive and simple. Please start a series on doing real-life projects like management systems in core php :)

[@ProgrammingwithVishal]

Sure Man. Will do

[@zaatriabdelhakim476]

thank you so much Bro, It works :) :)

[@ProgrammingwithVishal]

Welcome

[@msmediascreenentertainment1951]

vishal bahee great

[@ProgrammingwithVishal]

Thanks

[@vijayyalakshmi]

Thank you sir lot of thanks

[@laughwithcomedy]

Awesome..bro..

[@Aigle_Libre]

Thank you very much...

[@ProgrammingwithVishal]

Welcome

[@sikanderirfan7693]

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

[@saketkhare27]

Great way to explain.

[@niravpatel6558]

Thanks vishal

[@bossoftwareandtechnologies8731]

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

[@rahulmishra490]

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

[@myadvise857]

Wow amazing

[@mdnoman1457]

How much data can be retrieved from database?

[@estebanpiccardo6765]

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

[@AyushGupta-ke9ik]

धन्यवाद

[@triptiupadhyay8135]

Thanks sir...

[@ProgrammingwithVishal]

Welcome

[@asad8710]

does this work for docx?

[@llBestBoyll]

nice 🔥

[@anushar9801]

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

[@myadvise857]

Good sir

[@rahulhuilgol5928]

Great tutorial!

[@ProgrammingwithVishal]

Thank you!

[@satishgupta-h8x]

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

[@ahmadiqbal4939]

Sir I LOVE U

[@shubhamsaste5219]

Thank you sir

[@Shashiranjan2211]

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

[@abdulsalphan]

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?

[@HemantKumar-zi4xr]

and sir ji agar ese csv me kre to kese hoga , jesa aapne kha tha extension change kro , to xls ki jgh csv likh diya hai excel file jeses open hui thi thik usi trh ms excel open hua file ka naam bhi export.csv dikha rha hai , mgr ek row me table ka complete content dikha rha hai like data show rha hia

[@ProgrammingwithVishal]

Never use csv. Agar data main kabhi bhi ' aaya toh file ke data ka alignment bigad jayega

[@VishalBajpaiYT]

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

[@bn_castillo]

can you convert this code to pdo php?

[@deepakagarwal940]

Sir ms word ki table se data fetch karna ho to kaise karenge

[@mumbaibhaijaan]

Sir image file upload karna rahega database mein to kaise karege with image type validation

[@millenniuminfotech]

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

[@mcson1987]

How about Macro Excel TEmplate using PHPspreadsheet without losing the VBA MAcro???

[@ProgrammingwithVishal]

For this use some third party excel library

[@bossoftwareandtechnologies8731]

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

[@anowarulhassan5117]

Sir export to VB script kaise kare and baadme kuch alag page ka form kaise submit kare wahi Vbscript ka data se?

[@UMESHSHARMA-mj7sm]

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

[@theAkarsh]

sir complete excel ke format mein lana ho to? jisme cells bhi dikhen jo file download ho ri hai usme display poora plain aara hai PLZ HELP SIR

[@ProgrammingwithVishal]

Check. kzbin.info/www/bejne/rXjUk3imrJlmjac

[@getsetalk]

Sir colour full column me kese download kare

[@AmitKumar-km4vv]

Laravel me export kese kerenge in excel es PR bhi ek video bnayie

[@dinesh____gangwar]

sir its working fine but i want to set the directory to download the excel file ,is there any way to set directory

[@m.rehmantyagi4196]

YOU NEED TO USE PHPEXCEL LIBRARY FOR THAT

[@talibsheikh2507]

Sir isme date function add karna ho to kese kare...please reply..

[@HemantKumar-zi4xr]

sir ji export to xls to chl rha hai ,mgr agr pdf kr rha hu to dono header me to file download to hoti h mg open kerta hu to exploer me file open hoti pr page nhi shwo error dikhata hai ek pop up show hota usem likha hota hai ----------> we can't open this file, something went wrong.

[@ProgrammingwithVishal]

PDF convert ke liye apko koi or third party use karni padegi. Please check kzbin.info/www/bejne/d2KqiGiYn7Ktntk

[@Khalilahmed-pn6wt]

amazing sir word ma karna ka liya kaya type kara ga

[@ProgrammingwithVishal]

Thanks. Word ke liye apko koi third party library use karni hogi

[@abdulsalphan]

How can I send this file on mail without download?

[@mdnumanahmed9938]

Are waah... Msttt ha... Agr doc ya pdf ma export krna ho to kya kre?

[@ProgrammingwithVishal]

Content-Type main change karo or Content-Disposition main file extension.

[@mdnumanahmed9938]

@@ProgrammingwithVishal Doc k lye file extension kya du?

[@rajabhishek4973]

Sir invoice pdf topic pe video banao please sir

[@ProgrammingwithVishal]

Will do in next video.

[@rajabhishek4973]

@@ProgrammingwithVishal thak you so much sir

[@rajveersinghranawat823]

Hello sir how to make invoice in pdf

[@akilljain]

Sir button khe click page export.php pe rhna chaiye but yeah vapis index page pe aa rha hai? Aur sir pdf convert karna ho toh... extension change kar de.. xls to pdf

[@ProgrammingwithVishal]

export.php pe redirect karke apke pass kuch show karne ke liye nahi hota isliye redirect kiya hua hai index page pe. PDF ke liye apko html to pdf ka library use karna padega koi. Like TCPDF

[@Desichannel2000]

Sir how can show image in excel page

[@hafizarman3784]

Sir isko image ke sath kaise export karna he please es par bhi ek video banaye

[@faizanfuturex9304]

sir downlod too hoo raha hai pr execl mai nhi php ka code download hoo raha hai

[@moonaliasnilaa6407]

sir,,, its downloaded as php file format sir....please help me

[@m.rehmantyagi4196]

CHACK YOUR FILE TYPE

[@aplusmarketingadvertising5722]

ms word min kesy download karin

[@bapi.swarnakar]

good

[@ProgrammingwithVishal]

Thanks

[@bapi.swarnakar]

@@ProgrammingwithVishal most welcome

[@ppcode_conflict8770]

How to merge two cell in this

[@techsupport_az]

Html pdf file ko excel m export kese kre

[@rajasthanjaipur1019]

Sir, unicode utf-8 hindi me kese export kare please guide.

[@ProgrammingwithVishal]

Check kzbin.info/www/bejne/en6ydZp3iMSnnNk

[@kishanlodhari81]

i have 3 table it is posible single row

[@ShahidHussain-ew2bl]

sir selected data kese excel me dwnload karain

[@umeshkumaryadav5794]

sir ye excel file mobile me open nhi ho raha hai

[@faizashkhan1799]

How to create database.php file

[@adilazad4308]

Sir date k hisab se data pic karke usko download option bnayen

[@krishnawaghmode2120]

ad network sites kaise ads ko views count or impression count kaise karate mysql database use karke please make video

[@ProgrammingwithVishal]

Sure

[@shraddhatapase9349]

How to store and mail these excel file

[@ProgrammingwithVishal]

Watch this kzbin.info/www/bejne/h5ObY5-nfsuWoac

[@VersionMismatched]

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?

[@cm-b-26-prathameshpawar68]

converting that data in string will not remove 0....(i think so)

[@dastgirakhtar9782]

nice

[@ImSagarMaradiya]

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

[@rajabhishek4973]

Sir google recaptcha php pe video banao sir

[@ProgrammingwithVishal]

Sure

[@priyaakter7746]

Nice Work thanks. How can i do it using ajax ?? please give me a suggestion for ajax. because i want to filter table data and then export...

[@ProgrammingwithVishal]

Priya with the help of ajax, just hit that export link, that's it.

[@mounikagunupudi674]

Sir, it's not working in Mobile phone.

[@Mr.Ahmad.0000]

Text file kaise export kare.

[@ProgrammingwithVishal]

mime type change kar do

[@saravananas8086]

It's showing pares error sir

[@ProgrammingwithVishal]

Please share error screenshot to my email id [e-mail]

[@darthsauron255]

I didn't understand a thing.

[@ProgrammingwithVishal]

What u don't understand specify that

[@dinesh____gangwar]

sir its working fine but i want to set the directory to download the excel file ,is there any way to set directory

[@m.rehmantyagi4196]

YOU NEED TO USE PHPEXCEL LIBRARY FOR THAT

[@talibsheikh2507]

Thanks sir...

[@dinesh____gangwar]

sir its working fine but i want to set the directory to download the excel file ,is there any way to set directory

[@ProgrammingwithVishal]

Check you path properly

[@dinesh____gangwar]

when im going to run this code its downloading order.php file in download folder even it is not downloading into given dir. path

[@dinesh____gangwar]

sir plz suggest me something to set the directory for downloading the file

[@dinesh____gangwar]

@@ProgrammingwithVishal and sir it is not working on online server . i just want to doanload the excel file in the same directory where my php file exist in the live server