wordpress export csv yerine export xls nasıl yapabilirim.

<?php

( 'ABSPATH')) exit;

class Expoert_CSV{

/**
* Download csv file
* @param String $filename
* @return file
*/
public function download_send_headers( $filename ) {
// disable caching
$now = gmdate("D, d M Y H:i:s");
header("Expires: Tue, 03 Jul 2001 06:00:00 GMT");
header("Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate");
header("Last-Modified: {$now} GMT");
header('Content-Encoding: UTF-8');
// force download
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");

// disposition / encoding on response body
header("Content-Disposition: attachment;filename={$filename}");
header("Content-Transfer-Encoding: binary");

}
/**
* Convert array to csv format
* @param array &$array
* @return file csv format
*/
public function array2csv(array &$array, $df){

if (count($array) == 0) {
return null;
}

$array_keys = array_keys($array);
$heading = array();
$unwanted = array('cfdb7_', 'your-');

foreach ( $array_keys as $aKeys ) {
$tmp = str_replace( $unwanted, '', $aKeys );
$heading[] = ucfirst( $tmp );
}
fputcsv( $df, $heading );

foreach ( $array['form_id'] as $line => $form_id ) {
$line_values = array();
foreach($array_keys as $array_key ) {
$val = isset( $array[ $array_key ][ $line ] ) ? $array[ $array_key ][ $line ] : '';
$line_values[ $array_key ] = $val;
}
fputcsv($df, $line_values);
}
}
/**
* Download file
* @return csv file
*/
public function download_csv_file(){

global $wpdb;
$cfdb = apply_filters( 'cfdb7_database', $wpdb );
$table_name = $cfdb->prefix.'db7_forms';

if( isset($_REQUEST['csv']) && isset( $_REQUEST['nonce'] ) ){

$nonce = $_REQUEST['nonce'];
if ( ! wp_verify_nonce( $nonce, 'dnonce')) {

wp_die( 'Not Valid.. Download nonce..!! ' );
}
$fid = (int)$_REQUEST['fid'];
$heading_row = $cfdb->get_results("SELECT form_id, form_value, form_date FROM $table_name
WHERE form_post_id = '$fid' ORDER BY form_id DESC LIMIT 1",OBJECT);

$heading_row = reset( $heading_row );
$heading_row = unserialize( $heading_row->form_value );
$heading_key = array_keys( $heading_row );
$rm_underscore = apply_filters('cfdb7_remove_underscore_data', true);


$total_rows = $cfdb->get_var("SELECT COUNT(*) FROM $table_name WHERE form_post_id = '$fid' ");
$per_query = 1000;
$total_query = ( $total_rows / $per_query );

$this->download_send_headers( "cfdb7-" . date("Y-m-d") . ".csv" );
$df = fopen("php://output", 'w');
ob_start();

for( $p = 0; $p <= $total_query; $p++ ){

$offset = $p * $per_query;
$results = $cfdb->get_results("SELECT form_id, form_value, form_date FROM $table_name
WHERE form_post_id = '$fid' ORDER BY form_id DESC LIMIT $offset, $per_query",OBJECT);

$data = array();
$i = 0;
foreach ($results as $result) :

$i++;
$data['form_id'][$i] = $result->form_id;
$data['form_date'][$i] = $result->form_date;
$resultTmp = unserialize( $result->form_value );
$upload_dir = wp_upload_dir();
$cfdb7_dir_url = $upload_dir['baseurl'].'/cfdb7_uploads';

foreach ($resultTmp as $key => $value):
$matches = array();

if ( ! in_array( $key, $heading_key ) ) continue;
if( $rm_underscore ) preg_match('/^_.*$/m', $key, $matches);
if( ! empty($matches[0]) ) continue;

if (strpos($key, 'cfdb7_file') !== false ){
$data[$key][$i] = $cfdb7_dir_url.'/'.$value;
continue;
}
if ( is_array($value) ){

$data[$key][$i] = implode(', ', $value);
continue;
}

$data[$key][$i] = str_replace( array('&quot;',''','/','\')
, array('"',"'",'/','\\'), $value );

endforeach;

endforeach;

echo $this->array2csv( $data, $df );

}
echo ob_get_clean();
fclose( $df );
die();
}
}
}