csharp: datagridview Convert csv file
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 | /// <summary> /// 保存文件 /// 涂聚文 /// 2014-08-29 /// Geovin Du /// </summary> /// <param name="dGV"></param> /// <param name="filename"></param> public static void DataGridViewToCsV(DataGridView dGV, string filename) { string stOutput = "" ; // Export titles: string sHeaders = "" ; for ( int j = 0; j < dGV.Columns.Count; j++) sHeaders = sHeaders.ToString() + Convert.ToString(dGV.Columns[j].HeaderText) + ", " ; stOutput += sHeaders + "\r\n" ; // Export data. for ( int i = 0; i < dGV.RowCount - 1; i++) { string stLine = "" ; for ( int j = 0; j < dGV.Rows[i].Cells.Count; j++) stLine = stLine.ToString() + Convert.ToString(dGV.Rows[i].Cells[j].Value) + ", " ; stOutput += stLine + "\r\n" ; } UTF8Encoding utf8 = new UTF8Encoding(); string file = "1.csv" ; SaveFileDialog saveFileDialog1 = new SaveFileDialog(); saveFileDialog1.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); //Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); saveFileDialog1.CreatePrompt = true ; saveFileDialog1.OverwritePrompt = true ; saveFileDialog1.Title = "Save text Files" ; //saveFileDialog1.CheckFileExists = true; //saveFileDialog1.CheckPathExists = true; saveFileDialog1.DefaultExt = "csv" ; saveFileDialog1.Filter = "csv files (*.csv)|*.csv|All files (*.*)|*.*" ; saveFileDialog1.FilterIndex = 1; saveFileDialog1.RestoreDirectory = true ; System.IO.Stream fileStream; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { //FileStream fs = new FileStream(filename, FileMode.Create); file = saveFileDialog1.FileName; fileStream = saveFileDialog1.OpenFile(); MemoryStream userInput = new MemoryStream(); byte [] output = Encoding.Default.GetBytes(stOutput); //fileStream.Read(output, 0, (int)output.Length); fileStream.Write(output, 0, output.Length); fileStream.Close(); } } /// <summary> /// 保存文件 /// 涂聚文 /// 2014-08-28 /// Geovin Du /// </summary> /// <param name="dGV"></param> /// <param name="filename"></param> public static void DataGridViewToCsVDu(DataGridView dGV, string filename) { string stOutput = "" ; // Export titles: string sHeaders = "" ; for ( int j = 0; j < dGV.Columns.Count; j++) sHeaders = sHeaders.ToString() + Convert.ToString(dGV.Columns[j].HeaderText) + ", " ; stOutput += sHeaders + "\r\n" ; // Export data. for ( int i = 0; i < dGV.RowCount - 1; i++) { string stLine = "" ; for ( int j = 0; j < dGV.Rows[i].Cells.Count; j++) stLine = stLine.ToString() + Convert.ToString(dGV.Rows[i].Cells[j].Value) + ", " ; stOutput += stLine + "\r\n" ; } UTF8Encoding utf8 = new UTF8Encoding(); //Encoding utf16 = Encoding.GetEncoding(1200);//unicode encoding byte [] output = Encoding.Default.GetBytes(stOutput); FileStream fs = new FileStream(filename, FileMode.Create); BinaryWriter bw = new BinaryWriter(fs, Encoding.Default); bw.Write(output, 0, output.Length); //write the encoded file bw.Flush(); bw.Close(); fs.Close(); } |
哲学管理(学)人生, 文学艺术生活, 自动(计算机学)物理(学)工作, 生物(学)化学逆境, 历史(学)测绘(学)时间, 经济(学)数学金钱(理财), 心理(学)医学情绪, 诗词美容情感, 美学建筑(学)家园, 解构建构(分析)整合学习, 智商情商(IQ、EQ)运筹(学)生存.---Geovin Du(涂聚文)
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步