C# Excel 다운로드

private void btnExcelDownload_Click(object sender, EventArgs e)
{
    if (grid1.Rows.Count <= 0)
        return;
 
    Excel.Application oXL;
    Excel._Workbook oWB;
    Excel._Worksheet oSheet;
    Excel.Range oRng;
 
    try
    {
        oXL = new Excel.Application();
        oXL.Visible = false;
 
        object Missing = System.Reflection.Missing.Value;
        oWB = (Excel._Workbook)(oXL.Workbooks.Add(Missing));
        oSheet = (Excel._Worksheet)oWB.ActiveSheet;
 
        /*
        //Add table headers going cell by cell.
        oSheet.Cells[1, 1] = "First Name";
        oSheet.Cells[1, 2] = "Last Name";
        oSheet.Cells[1, 3] = "Full Name";
        oSheet.Cells[1, 4] = "Salary";

        //Format A1:D1 as bold, vertical alignment = center.
        oSheet.get_Range("A1", "D1").Font.Bold = true;
        oSheet.get_Range("A1", "D1").VerticalAlignment = 
        Excel.XlVAlign.xlVAlignCenter;
        */
        // Create an array to multiple values at once.
 
        int iRows = grid1.Rows.Count + 1;
        int iCols = grid1.Columns.Count;
 
        string[,] saNames = new string[iRows, iCols];
 
        for (int iCol = 1; iCol < grid1.Columns.Count; iCol++)
        {
            saNames[0, iCol - 1] = grid1.DisplayLayout.Bands[0].Columns[iCol].Header.Caption.ToString();
        }
 
        for (int iRow = 0; iRow < grid1.Rows.Count; iRow++)
        {
            for (int iCol = 1; iCol < grid1.Columns.Count; iCol++)
            {
                saNames[iRow + 1, iCol - 1] = grid1.Rows[iRow].Cells[iCol].Value.ToString();
            }
        }
 
        string sHeaderColumn = DecToAlphabet(iCols);
        oSheet.get_Range("A1", sHeaderColumn + iRows.ToString()).Font.Size = 9;
        oSheet.get_Range("A1", sHeaderColumn + iRows.ToString()).Value2 = saNames;
 
        //oXL.Visible = true;
        //oXL.UserControl = true;
 
        SaveFileDialog saveFile = new SaveFileDialog();
        saveFile.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
        saveFile.Title = "Excel 저장위치 지정";
        saveFile.DefaultExt = "xlsx";
        saveFile.Filter = "xlsx files(*.xlsx)|*.xlsx|xls files(*.xls)|*.xls";
 
        saveFile.ShowDialog();
 
        if (saveFile.FileNames.Length > 0)
        {
            foreach (string filename in saveFile.FileNames)
            {
                string savePath = filename;
                if (Path.GetExtension(savePath) == ".xls")
                {
                    oWB.SaveAs(savePath, Excel.XlFileFormat.xlWorkbookNormal);
                }
                else if (Path.GetExtension(savePath) == ".xlsx")
                {
                    oWB.SaveAs(savePath, Excel.XlFileFormat.xlOpenXMLWorkbook);
                }
            }
        }
 
        oWB.Close();
        oXL.Quit();
 
        oXL = null;
        oWB = null;
        oSheet = null;
        oRng = null;
 
        //
    }
    catch (Exception ex)
    {
        //ex
    }
}