c# - CSV write data in same line -
i generating csv code:
public actionresult methodname() { list<modelname> m = new list<modelname>(); stringbuilder sb = new stringbuilder(); foreach (modelname s in m) { sb.append(s.fname).trim(); sb.append(","); sb.append(s.sname).trim(); sb.append(","); /* uncertainty want 1 */ sb.appendline(); } byte[] bytes = encoding.utf8.getbytes(sb.tostring()); homecoming file(bytes, "text/comma-separated-values", "filename.csv"); }
the info getting looks when press f12 fname ,sname ,address, zipcode ,somethingelse
want here have .csv file first column contains fname, sec column sname, 3rd column address etc... yes have not placed address in code easy 1 time know why these info in different lines update fname sname
try this:
foreach (modelname s in m) { sb.append(s.fname.tostring().replace("\n","")); sb.append(","); sb.append(s.sname.tostring().replace("\n","")); sb.append(","); /* uncertainty want 1 */ sb.appendline(); }
c# csv
No comments:
Post a Comment