//リストビューをコピーするだけ private void button_copy_Click(object sender, EventArgs e) { if (listView_output.Items.Count == 0) return; StringBuilder sb = new StringBuilder(); //ヘッダー var header = new CsvList<string>(); foreach(int i in Enumerable.Range(0, listView_output.Columns.Count)) { header.Add(listView_output.Columns[i].Text); }; sb.AppendLine(string.Join("\t", header)); //アイテム foreach(int i in Enumerable.Range(0, listView_output.Items.Count)) { var row = new CsvList<string>(); var item = listView_output.Items[i]; foreach(int j in Enumerable.Range(0, item.SubItems.Count)) { row.Add(item.SubItems[j].Text); } sb.AppendLine(string.Join("\t", row)); } //クリップボードにコピー Clipboard.SetText(sb.ToString()); }
//コンバート用のテキストの作成 public static string MakeConvertText(IEnumerable<DropRecord> records, Dictionary<int, string> dropshipheader, Dictionary<int, string> dropitemheader) { StringBuilder sb = new StringBuilder(); CsvList<string> header = new CsvList<string>(); foreach (string x in DropRecord.LogConvertHeader) { header.Add(x); } sb.AppendLine(string.Join(",", header.ToArray())); //個々のデータ foreach (var x in records) { //--行の追加 sb.AppendLine(x.MakeLogConvertText(dropshipheader, dropitemheader)); } //帰り値 return sb.ToString(); }
/// <summary> /// CSVの行を作成 /// </summary> /// <returns>CSVの行テキスト</returns> public CsvList<string> ExportCSV() { var csv = new CsvList<string>(); csv.Add(this.api_id.ToString()); csv.Add(this.api_sortno.ToString()); csv.Add(this.api_name ?? ExCommon.NullString); csv.Add(ExCommon.ListToCsvString(this.api_type)); csv.Add(this.api_taik.ToString()); csv.Add(this.api_souk.ToString()); csv.Add(this.api_houg.ToString()); csv.Add(this.api_raig.ToString()); csv.Add(this.api_soku.ToString()); csv.Add(this.api_baku.ToString()); csv.Add(this.api_tyku.ToString()); csv.Add(this.api_tais.ToString()); csv.Add(this.api_atap.ToString()); csv.Add(this.api_houm.ToString()); csv.Add(this.api_raim.ToString()); csv.Add(this.api_houk.ToString()); csv.Add(this.api_raik.ToString()); csv.Add(this.api_bakk.ToString()); csv.Add(this.api_saku.ToString()); csv.Add(this.api_sakb.ToString()); csv.Add(this.api_luck.ToString()); csv.Add(this.api_leng.ToString()); csv.Add(this.api_rare.ToString()); csv.Add(ExCommon.ListToCsvString(this.api_broken)); csv.Add(this.api_info ?? ExCommon.NullString); csv.Add(this.api_usebull ?? ExCommon.NullString); csv.Add(this.api_cost.ToString()); csv.Add(this.api_distance.ToString()); csv.Add(this.TaiBaku.ToString()); csv.Add(this.Geigeki.ToString()); return csv; }