// 쿠팡
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;
}
}
}
