public bool ExportExcel(DataTable myDataTable, string saveFileName)
        {
            try
            {
                if (saveFileName.IndexOf(":") < 0) return false; //被点了取消

                Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
                object missing = System.Reflection.Missing.Value;

                if (xlApp == null)
                {
                    MessageBox.Show("无法创建Excel对象，可能您的机子未安装Excel");
                    return false;
                }
                Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;
                Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
                Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];            //取得sheet1
                Microsoft.Office.Interop.Excel.Range range;
                range = worksheet.Columns;
                range.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;              //水平对齐设置 
                range.VerticalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;                //垂直对齐设置
                range.ColumnWidth = 15;
                #region 写入字段
                worksheet.Cells[1, 1] = "钻石号";
       //.....
                worksheet.Cells[1, 21] = "类型外键";
                #endregion
                //写入数值
                for (int r = 0; r < myDataTable.Rows.Count; r++)
                {
                    worksheet.Cells[r + 2, 1] = myDataTable.Rows[r]["DiamNumber"];          //钻石号
//....
                    worksheet.Cells[r + 2, 21] = myDataTable.Rows[r]["PcID"];                //类型外键
                }
                worksheet.SaveAs(saveFileName, missing, missing, missing, missing, missing, missing, missing, missing, missing);
                workbook.Close(missing, missing, missing);
                xlApp.Quit();
                GC.Collect();
                GC.WaitForPendingFinalizers();
                return true;
            }
            catch (Exception ex)
            {
                return false;
            }
        }