I want to export excel data file with php format

Asked By christian soky 0 points N/A Posted on - 01/26/2013

Hi,

I have made a file on excel. But I have to use this file in PHP. Is there any possible way to convert excel file into PHP. Please inform me how to export excel with php. I want some simple & fast software that can export the data and can apply simple formatting.

• Status: Open
• Question Views: 642
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: PHP

Answered By Riley weaver 10 points N/A #184176

I want to export excel data file with php format

Hi there,

I hope you already know much about PHP programming language, so that I am not explaining so much about PHP code here. But if you think that you need help understanding the whole thing from the beginning, please just ask me. Now in below I am giving some instruction and code follow the instruction and copy the code to connect excel file with PHP code.

1.   Go to start menu, click on control panel and in search write ODBC.

2.   You will get a box, in that setup a system DNS.

3.   Suppose you gave that a name, called “excelsheet”.

4.   Now just copy this below code to connect to the excel file.

$conn=odbc_connect('excelSheet','','');
$query="SELECT * FROM sheet1"; 
$result=odbc_exec($conn,$query);
while (odbc_fetch_row($result))
{
  $field1=odbc_result($result,1);
}
odbc_close($conn); 

Best regards,

Riley Weaver.

About Riley weaver

Questions
2

Answers
228

Best Answers
103

• Vote Up 0 Vote Down

• Posted on - 01/27/2013
• Question Category: PHP