Guest User

Untitled

a guest
Nov 15th, 2017
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.35 KB | None | 0 0
  1. private void ToCsV(DataGridView dGV, string filename)
  2.  
  3. {
  4.  
  5. string stOutput = "";
  6.  
  7. // Export titles:
  8.  
  9. string sHeaders = "";
  10.  
  11.  
  12.  
  13. for (int j = 0; j < dGV.Columns.Count; j++)
  14.  
  15. sHeaders = sHeaders.ToString() + Convert.ToString(dGV.Columns[j].HeaderText) + "\t";
  16.  
  17. stOutput += sHeaders + "\r\n";
  18.  
  19. // Export data.
  20.  
  21.  
  22. StringBuilder sbOutput = new StringBuilder();
  23.  
  24. for (int j = 0; j < dGV.Columns.Count; j++)
  25. sbOutput.AppendLine(Convert.ToString(dGV.Columns[j].HeaderText) + "\t");
  26.  
  27. for (int i = 0; i < dGV.RowCount - 1; i++)
  28. {
  29.  
  30. for (int j = 1; j < dGV.Rows[i].Cells.Count; j++)
  31. sbOutput.Append(Convert.ToString(dGV.Rows[i].Cells[j].Value) + "\t");
  32. sbOutput.AppendLine();
  33. }
  34. Encoding utf16 = Encoding.GetEncoding(1254);
  35. byte[] output = utf16.GetBytes(sbOutput.ToString());
  36.  
  37.  
  38.  
  39.  
  40. FileStream fs = new FileStream(filename, FileMode.Create);
  41.  
  42. BinaryWriter bw = new BinaryWriter(fs);
  43.  
  44. bw.Write(output, 0, output.Length); //write the encoded file
  45.  
  46. bw.Flush();
  47.  
  48. bw.Close();
  49.  
  50. fs.Close();
  51.  
  52. }
Advertisement
Add Comment
Please, Sign In to add comment