打开csv文件到写字板后,我不希望在标题部分的sr后面有双空格,也不希望在No后面有空格


After opening csv file into wordpad ,i don't want double space in head section after Sr. And don't want space after No

当我将数据导出为csv文件并使用写字板打开文件时,myfield Sr. No。看起来像。不。我不想在sr后面加两倍的空格也不想在No后面加空格。代码如下:

    $filename = "file.csv";
    $fp = fopen('php://output', 'w');           
    $array = array('Sr. No.','Name','DOB','Address');
    $header = str_replace('',' ', $array);
    header('Content-type: application/csv');
    header('Content-Disposition: attachment; filename='.$filename);
    fputcsv($fp, $header,',',' ');
    $query = "select * from registratin";
    $result = mssql_query($query);
    $i = 1;
    while($row = mssql_fetch_row($result)) {
      $row = array_merge(array($i), $row);
      fputcsv($fp, $row);
      $i++;
    }

如果您不希望您的标题行符合CSV的规则,那么只需使用fwrite()而不是fputcsv()来编写一行

$headerLine = 'Sr. No,Name,DOB,Address';
fwrite($fp, $headerLine);