PHP processes Excel file csv-PHP Tutorial-php.cn

PHP processes Excel file csv

WBOY

Release： 2016-07-29 09:15:26

Original

847 people have browsed it

csv file format

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

Copy after login

?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>

Copy after login

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>

Copy after login

?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>

Copy after login

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.