How can I skip the saving process after import Excel to datagridview?

[TheAries]

I try to import an Excel file with multiple sheets, I have the code to choose a specific sheet. After the selected sheet imported successfully, it will prompt a save dialog as below. So, how can I skip the saving process?

void ChooseFile()
{
OFD1.Title = "Get Excel File";
OFD1.FileName = "";
OFD1.Filter = "Excel File|*.xlsx;*.xls";

if(OFD1.ShowDialog() == DialogResult.OK)
{
FileName = OFD1.FileName;
app = new Excel.Application();
workbook = app.Workbooks.Open(FileName);
if(FileName.Trim() != "")
if(workbook.Sheets.Count == 1)
ExcelToGrid();
else
ChooseSheet();
}
}

Code to choose a file



public void ChooseSheet()
{
for(int SheetNo = 1; SheetNo <= workbook.Sheets.Count; SheetNo++)
cboSheet.Items.Add("Sheet" + SheetNo);
}

Code to choose a sheet




public void ExcelToGrid(string SheetNo)
{
app = new Excel.Application();
workbook = app.Workbooks.Open(FileName);
worksheet = workbook.Worksheets[SheetNo];


dgvAddByGroup.Rows.Clear();
dgvAddByGroup.Columns.Clear();
dgvAddByGroup.Columns.Add("dgvSelect", "Select");

int RowNo, ColNo, RowCounter = 0, ColCounter = 0, CellCounter = 0;

for(ColNo = 1; ColNo <= worksheet.Columns.Count; ColNo++)
if(!string.IsNullOrEmpty(Convert.ToString(worksheet.Cells["1", ColNo].value)))
{
dgvAddByGroup.Columns.Add("dgv" + Convert.ToString(worksheet.Cells["1", ColNo].value), Convert.ToString(worksheet.Cells["1", ColNo].value));
ColCounter = 0;
}
else
if(ColCounter == 0)
{
dgvAddByGroup.Columns.Add("", "");
ColCounter = 1;
}
else if(ColCounter == 1)
{
dgvAddByGroup.Columns.RemoveAt(ColNo - 2);
ColCounter = 0;
break;
}

for(RowNo = 1; RowNo <= worksheet.Rows.Count; RowNo++)
{
CellCounter = 0;
dgvAddByGroup.Rows.Add();
dgvAddByGroup.Rows[RowNo - 1].Cells[0].Value = false;
for(ColNo = 1; ColNo <= dgvAddByGroup.Columns.Count; ColNo++)
{
if(!string.IsNullOrEmpty(Convert.ToString(worksheet.Cells[RowNo, ColNo].value)))
{
dgvAddByGroup.Rows[RowNo - 1].Cells[ColNo - 1].Value = Convert.ToString(worksheet.Cells[RowNo, ColNo].value);
CellCounter += 1;
}
else if(string.IsNullOrEmpty(Convert.ToString(worksheet.Cells[RowNo, ColNo].value)))
CellCounter += 0;
}
if(CellCounter == 0)
{
if(RowCounter == 0)
RowCounter = 1;
else if(RowCounter == 1)
{
dgvAddByGroup.Rows.RemoveAt(RowNo - 1);
dgvAddByGroup.Rows.RemoveAt(RowNo - 2);
RowCounter = 0;
break;
}
}
else
{
RowCounter = 0;
}
}
workbook.Close();
app.Quit();
}


Code to import Excel file






Image for Excel file






Image for my result

Continue reading...