Csv/CsvWriter.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Collections;


namespace ComLib.CsvParse
{
    /// <summary>
    /// Class to write out data into a csv format.
    /// </summary>
    public class CsvWriter : IDisposable
    {
        #region Private data
        private string _filename = string.Empty;
        private List<List<object>> _data;
        private List<string> _columns;
        private bool _hasColumns;
        private bool _hasData;
        private CsvWriterConfig _config;
        private StreamWriter _writer;
        #endregion


        /// <param name="fileName">The file name to write the csv data to.</param>
        /// <param name="data">The csv data.</param>
        /// <param name="delimeter">The delimeter to use.</param>
        /// <param name="columns">The header columns.</param>
        /// <param name="firstRowInDataAreColumns"></param>
        /// <param name="quoteChar">Quote character to use.</param>
        /// <param name="append">Append to file</param>
        /// <param name="newLine">New line to use.</param>
        /// <param name="quoteAll">Whether or not to quote all the values.</param>        
        public CsvWriter(string fileName, List<List<object>> data, string delimeter, List<string> columns, bool firstRowInDataAreColumns, bool quoteAll, string quoteChar, string newLine, bool append)
        {
            Init(fileName, data, delimeter, columns, firstRowInDataAreColumns, quoteAll, quoteChar, newLine, append);
        }
        
        
        /// <summary>
        /// 
        /// </summary>
        /// <param name="fileName">The file name to write the csv data to.</param>
        /// <param name="data">The csv data.</param>
        /// <param name="delimeter">The delimeter to use.</param>
        /// <param name="columns">The header columns.</param>
        /// <param name="firstRowInDataAreColumns"></param>
        /// <param name="quoteAll">Whether or not to quote all the values.</param>  
        /// <param name="append">Whether or not to append to csv file.</param>
        /// <param name="quoteChar">The quote char to use to enclose data.</param>
        /// <param name="newLine">New line to use.</param>
        public void Init(string fileName, List<List<object>> data, string delimeter, List<string> columns, bool firstRowInDataAreColumns, bool quoteAll, string quoteChar, string newLine, bool append)
        {
            _filename = fileName;
            _columns = columns;
            _data = data;
            _hasData = _data != null && _data.Count > 0;