mysql data to excel [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 12 years ago.

Improve this question

here is my code..but excel sheet is unexpected.here is my excel file

        mysql_connect("localhost", "root", "");
        mysql_select_db("personel");

        header( "Content-Type: application/vnd.ms-excel" ); 
        header( "Content-disposition: attachment; filename=TumPersonel.xls" );
        header("CONTENT-TYPE: text/html; charset=utf-8"); 

        if(isset($_POST["aktar"])){
        echo mb_convert_encoding('Personel Adı Soyadı'."\t". 'Firma Adı'."\t".'İstihdamı'."\t".'Fiili Çalıştığı Kuruluş'."\t".'Fiili Ünvanı'."\t". 'Kadrosunun Bulunduğu Kuruluş'."\t". 'Kadro Ünvanı'."\t". 'İşe Başladığı Tarih'."\t".'Sicil No'."\t". 'Mezuniyet'."\t". 'Mezun Olduğu Okul'."\t". 'Mezun Olduğu Bölüm/Branş'."\t".'TC Kimlik No'."\t".'Cinsiyet'."\t".'Doğum Tarihi'."\t".'Doğum Yeri'."\t".'Baba Adı'."\t".'Anne Adı'."\t". 'Medeni Hali'."\t". 'Çocuk Sayısı'."\t". 'Kan Grubu'."\t". 'E-Mail'."\t". 'Telefon'."\t". 'Adres'."\t". 'İlçe'."\t". "\n","windows-1254","utf-8");

        $sql=mysql_query("SELECT * FROM workers ORDER by ID");

        while($row=mysql_fetch_assoc($sql)){
            echo mb_convert_encoding( $row['username']. "\t" .$row['firma']. "\t" .$row['istihdam']. "\t" .$row['firm']. "\t" .$row['funvan']. "\t". $row['kkurulus']. "\t" .$row['kunvan']. "\t" .$row['tarih']. "\t" .$row['sicilno']. "\t" .$row['mezun']. "\t" .$row['mezuno']. "\t" .$row['mezunb']. "\t" .$row['tcno']. "\t" .$row['cins']. "\t" .$row['dtarih']. "\t" .$row['dyer']. "\t" .$row['badi']. "\t" .$row['aadi']. "\t" .$row['medeni']. "\t" .$row['csayisi']. "\t" .$row['kgrup']. "\t" .$row['email']. "\t" .$row['tel']. "\t" .$row['adres']. "\t" .$row['ilce']."\n","windows-1254","utf-8");
            }
        }

You're sending the mimetype for an Excel file, and following it with tab-separated values. This won't work. If you want to create an Excel file look at PHPExcel, or send comma-separated values. — user1864610
– user1864610, Commented Nov 18, 2013 at 7:25

M Gaidhane · Accepted Answer · 2013-11-18 09:18:04Z

3

try out with

$filename = d:/download/excelFileName.xls //filename with folder path where you want to save excel file

$getExcelData = 'SELECT column1, column2, column3 from workers INTO OUTFILE "'.$filename.'" FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n"' //mysql query;

$getResult = mysql_query($getExcelData _csv); //after execution of this query your excel file will created on d:/dowload folder by name excelFileName.xls
its work for me
refer http://dev.mysql.com/doc/refman/5.1/en/load-data.html

edited Nov 18, 2013 at 9:18

answered Nov 18, 2013 at 7:54

M Gaidhane

5318 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

umut Over a year ago

i couldn't integrated it to my code..sorry i'm bad on that

M Gaidhane Over a year ago

if your problem will not solve then reply i ll try my best

M Gaidhane Over a year ago

i have updated my answer, have a look

umut Over a year ago

thanks for your answer.i'm gonna try then turn back to you

umut Over a year ago

i have to use isset function for call excel but i couldn't again :((

|

Peter Kalef ' DidiSoft · Accepted Answer · 2013-11-18 07:22:27Z

1

Can you try to remove this line:

header("CONTENT-TYPE: text/html; charset=utf-8");

answered Nov 18, 2013 at 7:22

Peter Kalef ' DidiSoft

1,52417 silver badges22 bronze badges

1 Comment

Ashalynd Over a year ago

It is not relevant here.

Collectives™ on Stack Overflow

mysql data to excel [closed]

2 Answers 2

7 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

1 Comment

Linked

Related