private void ToCsV(DataGridView dGV, string filename) { string stOutput = ""; // Export titles: string sHeaders = ""; for (int j = 0; j < dataGridView4.Columns.Count; j++) sHeaders = sHeaders.ToString() + Convert.ToString(dataGridView4.Columns[j].HeaderText) + "\t"; stOutput += sHeaders + "\r\n"; // Export data. for (int i = 0; i < dataGridView4.RowCount; i++) { string stLine = ""; for (int j = 0; j < dataGridView4.Rows[i].Cells.Count; j++) stLine = stLine.ToString() + Convert.ToString(dataGridView4.Rows[i].Cells[j].Value) + "\t"; stOutput += stLine + "\r\n"; } Encoding utf16 = Encoding.GetEncoding(1254); byte[] output = utf16.GetBytes(stOutput); FileStream fs = new FileStream(filename, FileMode.Create); BinaryWriter bw = new BinaryWriter(fs); bw.Write(output, 0, output.Length); //write the encoded file bw.Flush(); bw.Close(); fs.Close(); } private void button6_Click(object sender, EventArgs e) { string months = dateTimePicker1.Value.ToString("MMMM"); string Years = dateTimePicker1.Value.ToString("yyyy"); ToCsV(dataGridView1, @"D:\"+months+""+" "+""+Years+".xls") }
Debug.WriteLine( sHeaders );
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)