CSV导入导出代码,CSharp代码库,德仔网

代码语言
代码分类
【CSharp】 CSV导入导出
作者:Dezai.CN / 发布于2012/8/17/ 601
CSV导入导出
<div>导入代码，从csv文件得到datatable</div>
<div> /// <summary>
 /// Get Data From Csv File 
 /// (Through StreamReader)
 /// </summary>
 /// <returns></returns>
 private bool GetData(Stream inputStream, out string errMessage, out DataTable dtFile)
 {
 errMessage = String.Empty;
 dtFile = new DataTable();</div>
<div>
 //this.FileUploadImport.PostedFile.InputStream.CanSeek;
 //StreamReader sr = new StreamReader(this.FileUploadImport.PostedFile.InputStream); //update by hwx 11/12/2010
 StreamReader sr = new StreamReader(inputStream);
 int iColumnCount = 19;//the column count in the file
 int iRow = 1;// the row number is being read
 int iColumn = 0;// the column number is being read
 string strStandardTitle = string.Empty; // the title as it is</div>
<div> //read title row
 string strTitle = sr.ReadLine();</div>
<div> //string[] strRowTitle = strTitle.Split(new char[] { ',' });
 string[] strRowTitle = new string[iColumnCount];
 string strCharTitle;
 int iCellNumberTitle = 0;
 bool blnQuoteTitle = false;
 for (int i = 0; i < strTitle.Length; i++)
 {
 strCharTitle = strTitle.Substring(i, 1);
 if (strCharTitle == ",")// "," is the seperation symbol of csv file,
 {
 if (!blnQuoteTitle)
 {
 iCellNumberTitle++;// out of the "" range, "," is the seperation symbol
 if (iCellNumberTitle >= iColumnCount)// too many column in this line
 {
 break;
 }
 }
 else
 {
 strRowTitle[iCellNumberTitle] += strCharTitle;
 }
 }
 else if (strCharTitle == "\"")// "\"" is the transfer symbol of csv file,
 {
 blnQuoteTitle = !blnQuoteTitle;
 if (blnQuoteTitle && i > 0 && strTitle.Substring(i - 1, 1) == "\"")//in the "" range and there is an transfer symbol before
 {
 strRowTitle[iCellNumberTitle] += strCharTitle;
 }
 }
 else
 {
 strRowTitle[iCellNumberTitle] += strCharTitle;
 }
 }
 //read the content
 if (strRowTitle.Length == iColumnCount)
 {
 foreach (string strCell in strRowTitle)
 {
 iColumn++;
 if (strCell.Trim() != string.Empty)
 {
 dtFile.Columns.Add(strCell);//add new column with name to the data table</div>
<div> }
 else //file error:blank title
 {</div>
<div> errMessage += "The cell " + iColumn.ToString() + " is blank in the header row.\r\n";
 }
 }
 if (dtFile.Columns.Count == iColumnCount)//make sure that no blank header or error header
 {
 //read content row
 string strLine;
 while (!sr.EndOfStream)
 {
 iRow++;
 iColumn = 0;
 DataRow dr = dtFile.NewRow();
 strLine = sr.ReadLine();</div>
<div> //read csv file line by line
 string[] strRow = new string[iColumnCount];
 string strChar;
 int iCellNumber = 0;
 bool blnQuote = false;//whether in the "" range
 for (int i = 0; i < strLine.Length; i++)
 {
 strChar = strLine.Substring(i, 1);
 if (strChar == ",")// "," is the seperation symbol of csv file,
 {
 if (!blnQuote)
 {
 iCellNumber++;// out of the "" range, "," is the seperation symbol
 if (iCellNumber >= iColumnCount)// too many column in this line
 {
 break;
 }
 }
 else
 {
 strRow[iCellNumber] += strChar;
 }
 }
 else if (strChar == "\"")// "\"" is the transfer symbol of csv file,
 {
 blnQuote = !blnQuote;
 if (blnQuote && i > 0 && strLine.Substring(i - 1, 1) == "\"")//in the "" range and there is an transfer symbol before
 {
 strRow[iCellNumber] += strChar;
 }
 }
 else
 {
 strRow[iCellNumber] += strChar;
 }
 }
 if (iCellNumber + 1 == iColumnCount)
 {
 foreach (string strCell in strRow)
 {
 iColumn++;
 if (strCell != null && strCell.Trim() != string.Empty)
 {
 dr[strRowTitle[iColumn - 1]] = strCell.Trim();
 }
 else//file error:blank cell
 {
 dr[strRowTitle[iColumn - 1]] = String.Empty;
 //errMessage += "The column \"" + strRowTitle[iColumn - 1] + "\" is blank in row " + iRow.ToString() + ".\r\n";
 }
 }
 }
 else// file error:the column count of current row do not equal to title's
 {
 errMessage += "There are more or less cells than title row in the row " + iRow.ToString() + ".\r\n";
 }
 dtFile.Rows.Add(dr);
 }
 }
 }
 else //file error:the count of columns in the file don't equal it should be
 {
 errMessage += "There are an incorrect number of columns in the header row compared to the template file.\r\n";
 }
 sr.Close();
 sr.Dispose();</div>
<div> errMessage = errMessage.Replace("\r\n", "");
 return errMessage == String.Empty ? true : false;
 }
<div>
 /// <summary>
 /// Get dataset from csv file.
 /// </summary>
 /// <param name="filepath"></param>
 /// <param name="filename"></param>
 /// <returns>Data Set</returns>
 private DataSet GetDatasetFromCsv(string filepath, string filename)
 {
 string strconn = @"driver={microsoft text driver (*.txt; *.csv)};dbq=";
 strconn += filepath; //filepath, for example: c:\
 strconn += ";extensions=asc,csv,tab,txt;";
 OdbcConnection objconn = new OdbcConnection(strconn);
 DataSet dscsv = new DataSet();
 try
 {
 string strsql = "select * from " + filename; //filename, for example: 1.csv
 OdbcDataAdapter odbccsvdataadapter = new OdbcDataAdapter(strsql, objconn);</div>
<div> odbccsvdataadapter.Fill(dscsv);
 return dscsv;
 }
 catch (Exception ex)
 {
 throw ex;
 }
 }
试试其它关键字
　CSV导入导出　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)