本文将带您了解关于php实现的读取CSV文件函数示例的新内容，同时我们还将为您解释php读取csv文件的相关知识，另外，我们还将为您提供关于C#写入(覆盖形式)数据到CSV文件和读取CSV文件、fge
本文将带您了解关于php实现的读取CSV文件函数示例的新内容，同时我们还将为您解释php 读取csv文件的相关知识，另外，我们还将为您提供关于C#写入(覆盖形式)数据到CSV文件 和 读取CSV文件、fgetcsv函数不能读取csv文件中文字符串的解决方法_PHP教程、java读取csv文件和写csv示例分享、java读取csv文件示例分享(java解析csv文件)的实用信息。
本文目录一览：- php实现的读取CSV文件函数示例（php 读取csv文件）
- C#写入(覆盖形式)数据到CSV文件 和 读取CSV文件
- fgetcsv函数不能读取csv文件中文字符串的解决方法_PHP教程
- java读取csv文件和写csv示例分享
- java读取csv文件示例分享(java解析csv文件)
php实现的读取CSV文件函数示例（php 读取csv文件）
本文实例讲述了PHP实现的读取CSV文件函数。分享给大家供大家参考，具体如下：
更多关于PHP相关内容感兴趣的读者可查看本站专题：《》、《》、《》、《》、《》、《》、《》、《》、《》、《》及《PHP常见数据库操作技巧汇总》
希望本文所述对大家PHP程序设计有所帮助。
C#写入(覆盖形式)数据到CSV文件 和 读取CSV文件
/// <summary>
/// 写入数据到CSV文件，覆盖形式
/// </summary>
/// <param name="csvPath">要写入的字符串表示的CSV文件</param>
/// <param name="LineDataList">要写入CSV文件的数据，以string[]类型List表示的行集数据</param>
public static void OpCsv(string csvPath, List<string[]> LineDataList)
{
using (FileStream fs = new FileStream(csvPath.Trim(), FileMode.OpenOrCreate, FileAccess.ReadWrite))
{
using (StreamWriter sw = new StreamWriter(fs, Encoding.Default))
{
StringBuilder sb_csvStr = new StringBuilder();
for (int i = 0; i < LineDataList.Count; i++)//<--row
{
sb_csvStr.Clear();
for (int j = 0; j < LineDataList[i].Length; j++)//<--col
{
sb_csvStr.Append(string.Format("{0},", LineDataList[i][j].ToString()));
}
sw.WriteLine(sb_csvStr.ToString().Substring(0, sb_csvStr.ToString().Length - 1));
}
fs.Flush();
}
}
}
/// <summary>
/// 读取csv文件
/// </summary>
/// <param name="csvPath">string 标识的 csv文件路径</param>
/// <returns>返回的读取的 csv 文件的行集合</returns>
public static string[] ReadCsv(string csvPath)
{
string[] csvLineList = File.ReadAllLines(csvPath, Encoding.Default);
return csvLineList;
}
fgetcsv函数不能读取csv文件中文字符串的解决方法_PHP教程
读取数据函数：
<span function</span> getData(<span $file</span><span ) {
</span><span $arr</span> = <span array</span><span ();
</span><span if</span>((<span $handle</span> = <span fopen</span>(<span $file</span>,"r")) !== <span FALSE</span><span ) {
</span><span while</span>((<span $data</span> = <span fgetcsv</span>(<span $handle</span>)) !== <span FALSE</span><span ) {
</span><span $tmp</span> = <span array</span><span ();
</span><span foreach</span>(<span $data</span> <span as</span> <span $key</span>=><span $v</span><span ) {
</span><span $tmp</span>[] = mb_convert_encoding(<span $v</span>,"UTF-8","gbk"); <span /*</span><span 要将gbk码转为utf-8，否则会出现乱码</span><span */</span><span
}
</span><span $arr</span>[] = <span $tmp</span><span ;
}
}
</span><span return</span> <span $arr</span><span ;
}</span>发现读取的中文字符串为空....
解决方法：将fgetcsv函数换成自定义的_fgetcsv函数
<span function</span> _fgetcsv(&<span $handle</span>, <span $length</span> = <span null</span>, <span $d</span> = '','', <span $e</span> = ''"''<span ) {
</span><span $d</span> = <span preg_quote</span>(<span $d</span><span );
</span><span $e</span> = <span preg_quote</span>(<span $e</span><span );
</span><span $_line</span> = ""<span ;
</span><span $eof</span>=<span false</span><span ;
</span><span while</span> (<span $eof</span> != <span true</span><span ) {
</span><span $_line</span> .= (<span empty</span> (<span $length</span>) ? <span fgets</span>(<span $handle</span>) : <span fgets</span>(<span $handle</span>, <span $length</span><span ));
</span><span $itemcnt</span> = <span preg_match_all</span>(''/'' . <span $e</span> . ''/'', <span $_line</span>, <span $dummy</span><span );
</span><span if</span> (<span $itemcnt</span> % 2 == 0<span )
</span><span $eof</span> = <span true</span><span ;
}
</span><span $_csv_line</span> = <span preg_replace</span>(''/(?: |[ ])?$/'', <span $d</span>, <span trim</span>(<span $_line</span><span ));
</span><span $_csv_pattern</span> = ''/('' . <span $e</span> . ''[^'' . <span $e</span> . '']*(?:'' . <span $e</span> . <span $e</span> . ''[^'' . <span $e</span> . '']*)*'' . <span $e</span> . ''|[^'' . <span $d</span> . '']*)'' . <span $d</span> . ''/''<span ;
</span><span preg_match_all</span>(<span $_csv_pattern</span>, <span $_csv_line</span>, <span $_csv_matches</span><span );
</span><span $_csv_data</span> = <span $_csv_matches</span>[1<span ];
</span><span for</span> (<span $_csv_i</span> = 0; <span $_csv_i</span> < <span count</span>(<span $_csv_data</span>); <span $_csv_i</span>++<span ) {
</span><span $_csv_data</span>[<span $_csv_i</span>] = <span preg_replace</span>(''/^'' . <span $e</span> . ''(.*)'' . <span $e</span> . ''$/s'', ''$1'' , <span $_csv_data</span>[<span $_csv_i</span><span ]);
</span><span $_csv_data</span>[<span $_csv_i</span>] = <span str_replace</span>(<span $e</span> . <span $e</span>, <span $e</span>, <span $_csv_data</span>[<span $_csv_i</span><span ]);
}
</span><span return</span> <span empty</span> (<span $_line</span>) ? <span false</span> : <span $_csv_data</span><span ;
}</span>参考：
http://bbs.csdn.net/topics/390040230
立即学习“PHP免费学习笔记（深入）”；
http://hi.baidu.com/maojianlw/item/d3ee390e820cfbcb75cd3c5c
http://phpexcel.codeplex.com/（操作excel的库：phpexcel）
java读取csv文件和写csv示例分享
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.io.InputStreamReader;
public class csv{
public static void main(String[] args) throws IOException {
File outfile = new File("D://new_car.csv");//存储到新文件的路径
try {
InputStreamReader isr = new InputStreamReader(new FileInputStream("D://car.csv"));//待处理数据的文件路径
BufferedReader reader = new BufferedReader(isr);
BufferedWriter bw = new BufferedWriter(new FileWriter(outfile));
String line = null;
while((line=reader.readLine())!=null){
String item[] = line.split(",");
/*
*信息处理块
*/
bw.newLine();//新起一行
bw.write(""+","+"");//写到新文件中
}
bw.close();
} catch (FileNotFoundException e) {
// Todo Auto-generated catch block
e.printstacktrace();
}
}
}
