3

How can I convert the array/json into an Excel file (Office Open XML)?

$result = mysql_query($query);
$rows = Array();
while($row = mysql_fetch_assoc($result)) {
    array_push($rows, $row);
}
echo json_encode(Array(
    "data" => $rows
));
Improve this question
1
  • 1
    There's not a magical convert_to_excel() function, but I believe there are a few libraries for this. Very worst case, the standard for Excel's file format has been published by MS. Commented Jun 26, 2012 at 9:15
Related questions
21
Excel to PHP array, possible and how?
11
Export an Array of Arrays to Excel in php
4
convert excel cell containing json into csv
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.