PHP processes Excel file csv

csv file format

<code><span>"数据１"</span>，<span>"数据２"</span>，<span>"数据３"</span><span>"数据４"</span>，<span>"数据５"</span>，<span>"数据６"</span></code>

?Save a two-dimensional array as a csv file fputcsv()

<code><span>$csv_arr</span> = (
    <span>array</span>(<span>1</span>,<span>2</span>,<span>3</span>,<span>4</span>),
    <span>array</span>(<span>5</span>,<span>6</span>,<span>7</span>,<span>8</span>),
    <span>array</span>(<span>12</span>,<span>34</span>,<span>56</span>,<span>78</span>)
);
<span>$fh</span> = fopen(<span>'test.csv'</span>,<span>'w'</span>) <span>or</span><span>die</span>(<span>"can't open file test.csv"</span>)；
<span>foreach</span>(<span>$csv_arr</span><span>as</span><span>$csv_arr_line</span>){
    <span>if</span>(fputcsv(<span>$fh</span>,<span>$csv_arr_line</span>) === <span>false</span>){
        <span>die</span>(‘can not write test.csv !’)；
    }
}
fclose(<span>$fh</span>) <span>or</span><span>die</span>(<span>"can not close test.csv !"</span>);</code>

Want to output data in csv format php://output

<code><span>$csv_arr</span> = (
    <span>array</span>(<span>1</span>,<span>2</span>,<span>3</span>,<span>4</span>),
    <span>array</span>(<span>5</span>,<span>6</span>,<span>7</span>,<span>8</span>),
    <span>array</span>(<span>12</span>,<span>34</span>,<span>56</span>,<span>78</span>)
);
<span>$fh</span> = fopen(<span>'php://output'</span>,<span>'w'</span>);
<span>foreach</span>(<span>$csv_arr</span><span>as</span><span>$csv_arr_line</span>){
    <span>if</span>(fputcsv(<span>$fh</span>,<span>$csv_arr_line</span>) === <span>false</span>){
        <span>die</span>(‘can not write csv line !’)；
    }
}
fclose(<span>$fh</span>);</code>

?Want to save data in csv format into a string ob buffer

<code><span>$csv_arr</span> = (
    <span>array</span>(<span>1</span>,<span>2</span>,<span>3</span>,<span>4</span>),
    <span>array</span>(<span>5</span>,<span>6</span>,<span>7</span>,<span>8</span>),
    <span>array</span>(<span>12</span>,<span>34</span>,<span>56</span>,<span>78</span>)
);
ob_start();
<span>$fh</span> = fopen(<span>'test.csv'</span>,<span>'w'</span>) <span>or</span><span>die</span>(<span>"can't open php://output"</span>)；
<span>foreach</span>(<span>$csv_arr</span><span>as</span><span>$csv_arr_line</span>){
    <span>if</span>(fputcsv(<span>$fh</span>,<span>$csv_arr_line</span>) === <span>false</span>){
        <span>die</span>(‘can not write csv line !’)；
    }
}
fclose(<span>$fh</span>) <span>or</span><span>die</span>(<span>"can not close php://output !"</span>);
<span>$output</span> = ob_get_contents();
ob_end_clean();</code>

Copyright statement: Knowledge comes from the people, and is used by the people! Reprinting is welcome. Please attach a link to this article at the beginning. The article will be updated from time to time!

The above introduces how to use PHP to process Excel files csv, including the content. I hope it will be helpful to friends who are interested in PHP tutorials.