// 쿠팡 private void Excel_Set1() { if (cmbO_Sub_Company.EditValue.ToString() == "0") { MessageAgent.MessageShow(MessageType.Warning, " 온라인몰을 선택하세요!"); return; } efwGridControl2.DataSource = null; gridView2.RefreshData(); //OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.DefaultExt = "xlsx"; openFileDialog1.FileName = "기초재고.xlsx"; openFileDialog1.Filter = "Excel97 - 2003 통합문서|*.xlsx"; openFileDialog1.Title = "엑셀데이터 가져오기"; if (openFileDialog1.ShowDialog() == DialogResult.OK) { try { Cursor = Cursors.WaitCursor; if (openFileDialog1.FileName != string.Empty) { string fileName = openFileDialog1.FileName; //if (fileName.IndexOf("기초재고.xlsx") < 0) //{ // MessageAgent.MessageShow(MessageType.Error, "엑셀파일명에 문제가 있습니다. 파일명을 확인하세요."); // return; //} this.efwGridControl1.DataSource = ExcelDataBaseHelper.OpenFile2(fileName); //this.efwGridControl1.DataSource = ExcelDataBaseHelper.OpenFile(fileName); this.efwGridControl1.MyGridView.BestFitColumns(); lblCnt.Text = string.Format("{0:#,###}", gridView1.DataRowCount.ToString()); } } catch (Exception ex) { MessageBox.Show("엑셀 파일 드라이버가 잘못되었거나 엑셀파일이 문제가 있습니다." + "\r\n" + ex.ToString()); } finally { Cursor = Cursors.Default; } } }
private void efwSimpleButton1_Click(object sender, EventArgs e) { efwGridControl1.DataSource = null; gridView1.RefreshData(); //OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.DefaultExt = "xlsx"; openFileDialog1.FileName = "메모.xlsx"; openFileDialog1.Filter = "Excel97 - 2003 통합문서|*.xlsx"; openFileDialog1.Title = "엑셀데이터 가져오기"; if (openFileDialog1.ShowDialog() == DialogResult.OK) { try { Cursor = Cursors.WaitCursor; if (openFileDialog1.FileName != string.Empty) { string fileName = openFileDialog1.FileName; //if (fileName.IndexOf("기초재고.xlsx") < 0) //{ // MessageAgent.MessageShow(MessageType.Error, "엑셀파일명에 문제가 있습니다. 파일명을 확인하세요."); // return; //} this.efwGridControl1.DataSource = ExcelDataBaseHelper.OpenFile2(fileName); //this.efwGridControl1.DataSource = ExcelDataBaseHelper.OpenFile(fileName); this.efwGridControl1.MyGridView.BestFitColumns(); lblCnt.Text = string.Format("{0:#,###}", gridView1.DataRowCount.ToString()); } } catch (Exception ex) { MessageBox.Show("엑셀 파일 드라이버가 잘못되었거나 엑셀파일이 문제가 있습니다." + "\r\n" + ex.ToString()); } finally { Cursor = Cursors.Default; } } }
// 옥션/지마켓 private void Excel_Set5() { efwGridControl5.DataSource = null; gridView3.RefreshData(); //OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.DefaultExt = "xls"; openFileDialog1.FileName = "*.xls"; openFileDialog1.Filter = "Excel97 - 2003 통합문서|*.xlsx"; openFileDialog1.Title = "엑셀데이터 가져오기"; if (openFileDialog1.ShowDialog() == DialogResult.OK) { try { Cursor = Cursors.WaitCursor; if (openFileDialog1.FileName != string.Empty) { string fileName = openFileDialog1.FileName; this.efwGridControl5.DataSource = ExcelDataBaseHelper.OpenFile2(fileName); this.efwGridControl5.MyGridView.BestFitColumns(); lblCnt.Text = string.Format("{0:#,###}", gridView4.DataRowCount.ToString()); } } catch (Exception ex) { MessageBox.Show("엑셀 파일 드라이버가 잘못되었거나 엑셀파일이 문제가 있습니다." + "\r\n" + ex.ToString()); } finally { Cursor = Cursors.Default; } } }