WPF Excel Export Microsoft.Office.Interop 성능향상(열 기준으로 복사)

Microsoft.Office.Interop을 사용하여 셀별로 복사하면 너무오래걸려 Row 일괄 복사하도록하여 성능향상 DataGrid -> DataView -> DataTable 로 변환하고 foreach 에서 DataRow 별로 일괄 붙이기. DataView Dview = (DataView)result_grid2.ItemsSource as DataView; DataTable Ex_table = Dview.Table; string excelRange1 = "A" + cellRowIndex;// 복사 시작범위 string excelRange2 = "BL" + cellRowIndex;// 복사 종료범위 worksheet.Range[excelRange1, excelRange2].Value2 = dr.Item..
WPF 2019. 8. 27. 09:22
WPF Datagrid Cell Value Change

데이터그리드 셀값 삭제하는방법이 어려워 셀값을 공백으로 붙여 넣었다. private void Paste_Cell(int col_index, int row_index) { DataGridColumn column1 = dataGrid1.ColumnFromDisplayIndex(col_index); column1.OnPastingCellClipboardContent(dataGrid1.Items[row_index], ""); }
WPF 2019. 6. 27. 21:13
WPF Textbox 항상 처음라인에 쓰기

if (list_box.LineCount > 1) { list_box.Text = list_box.Text.Insert(0, "[" + line_count.ToString() + "] " + lines); } else { list_box.AppendText("["+line_count.ToString()+"] "+lines); }
WPF 2019. 6. 26. 20:25
WPF Textbox 마지막라인 삭제

list_box.Text = list_box.Text.Remove(list_box.Text.LastIndexOf(Environment.NewLine));
WPF 2019. 6. 26. 20:24
WPF C# Serial EOF Check

String RF_text; private void SetText(string text) { if (RF_ID.Dispatcher.CheckAccess()) { RF_text = RF_text + text; byte[] StrByte = Encoding.UTF8.GetBytes(text); for (int i = 0; i < StrByte.Length; i++) { if (StrByte[i] == 0x03) //0x1A { RF_ID.Text = RF_text; SendSerial(true); RF_text = String.Empty; break; } } } else { SetTextCallBack d = new SetTextCallBack(SetText); RF_ID.Dispatcher.Invoke(d..
WPF 2019. 6. 24. 20:38
Combobox 로딩중 selected event 금지

if (!cmbBox.IsLoaded) return;
WPF 2019. 5. 14. 15:58
WPF DataGrid empty row at bottom remove

CanUserAddRows="false"
WPF 2019. 4. 24. 22:21
DataTable Sum Compute

DataTable table = dataSet.Tables["YourTableName"]; // Declare an object variable. object sumObject; sumObject = table.Compute("Sum(Amount)", string.Empty);
WPF 2019. 4. 24. 22:20
Chart

https://github.com/akiver/Modern-UI-Metro-Charts-WPF/blob/master/De.TorstenMandelkow.MetroChart.WPF/Themes/Generic.xaml akiver/Modern-UI-Metro-Charts-WPF Fork of Modern UI (Metro) Charts WPF https://modernuicharts.codeplex.com/ - akiver/Modern-UI-Metro-Charts-WPF github.com http://m.csharpstudy.com/WinForms/View?aspx=WinForms-chart.aspx&title=%EC%B0%A8%ED%8A%B8%20%EC%BB%A8%ED%8A%B8%EB%A1%A4%20%E..
WPF 2019. 4. 19. 19:14
WPF MetroChart sample

http://www.10qianwan.com/articledetail/42748.html WPF 圖表控件 MetroChart_.net_萬仟网 WPF 圖表控件 MetroChart 2018年01月08日 10:37 | 萬仟网IT编程 | 我要评论 Torsten Mandelkow MetroChart包括以下： ColumnChart（ClusteredColumnChart，StackedColumnChart，StackedColumnChart100Percent） 饼图（饼图和Dognut） BarChart（ClusteredBarChart，StackedBarChart，StackedBarChart100Percent） www.10qianwan.com
WPF 2019. 4. 11. 11:51
1 2 3 4 5