私人笔记--C#导出Excel-创新互联

在承德等地区，都构建了全面的区域性战略布局，加强发展的系统性、市场前瞻性、产品创新能力，以专注、极致的服务理念，为客户提供成都网站制作、网站设计、外贸网站建设网站设计制作按需设计,公司网站建设,企业网站建设,高端网站设计,成都全网营销推广,外贸营销网站建设,承德网站建设费用合理。>

using System.IO;
         
///    /// Get the save file full name
/// 
   ///    /// If the file exist, then delete the file.
///    /// save file full name, If null then open dialog to select and input save file name   /// file Suffix,ex:"xls"   /// file filter defination ,ex:"EXCEL(*.xls)|*.xls"   /// except or cancel dialog return empty string, else return save file full namepublic static string GetSaveFileName(string fileName,string fileSuffix,string fileFilter)
{
string saveFileNameString = string.Empty;
try
    {
if(fileName == null || fileName.Trim() == "")
        {
//声明保存对话框            SaveFileDiaLog dlg = new SaveFileDialog();
//默认文件后缀            dlg.DefaultExt = fileSuffix;
//文件后缀列表            dlg.Filter = fileFilter;
//默认路径是系统当前路径            dlg.InitialDirectory = Directory.GetCurrentDirectory();
//打开保存对话框 if (dlg.ShowDialog() == DialogResult.Cancel) return "";
//返回文件路径            saveFileNameString = dlg.FileName;
        }
else
            saveFileNameString= fileName;

if (saveFileNameString.Trim() == "")
return "";
//验证以fileNameString命名的文件是否存在，如果存在删除它        FileInfo file = new FileInfo (saveFileNameString);
if(file.Exists)
        {
try
            {
                file.Delete();
            }
catch (Exception error)
            {
                AppMessageBox.ShowErrorNoTranslate(error.Message);
return "";
            }
        }
return saveFileNameString;
    }
catch
    {
return "";
    }
}       


public void CreateToExcel(string fileName)
{
string fileNameString = GetSaveFileName(fileName, "xls", "EXCEL(*.xls)|*.xls");
//验证strFileName 是否为空或无效  if (fileNameString.Trim() == "")
return;

//定义表格内数据的行数和列数
    Microsoft.Office.Interop.Excel.Application objExcel= null;

    Workbook objWorkbook= null;//excel 工作簿    Worksheet objsheet = null; //excel sheet页  try
    {
//声明对象        objExcel = new Microsoft.Office.Interop.Excel.Application();
        CultureInfo oldCulture= System.Threading.Thread.CurrentThread.CurrentCulture;
        CultureInfo newCulture= new CultureInfo(objExcel.LanguageSettings.get_languageID(Microsoft.Office.Core.MsoAppLanguageID.msoLanfuageIDUI));
        System.Threading.Thread.CurrentThread.CurrentCulture= new newCulture;
//声明excel工作簿        objWorkbook = objExcel.Workbooks.Add(Missing.Value);
//声明sheet页        objsheet = (Worksheet)objWorkbook.ActiveSheet;     
//页面设置        objsheet.PageSetup.PagerSize = XlPagerSize.xlPagerA4; //设置A4格式        objsheet.PageSetup.BottomMargin = 0.5 / 0.035;
        objsheet.PageSetup.TopMargin= 2 / 0.035;
        objsheet.PageSetup.LeftMargin= 0.1 / 0.035;
        objsheet.PageSetup.RightMargin= 0.05 / 0.035;

        objsheet.PageSetup.Zoom= 90;
        objsheet.PageSetup.CenterHorizontally= true;

string position = string.Empty;
//设置EXCEL是否可见        objExcel.Visible = false;
        Microsoft.Office.Interop.Excel.Range excelRange= null;

double[] colWidth = new double[] { 3.63, 8, 13.15, 5, 14.38, 5, 11.5, 8.38, 11.5, 5, 20 };
string[] tableHeadTitle = new string[] { "A", "B", "C", "D", "E", "F", "G", "H", "I" };
    
    
//向Excel中写入表格的表头

//设置列水平居中和列的宽度   for (int i = 1; i <= 11; i++)
        {
            excelRange= objExcel.get_Range(objExcel.Cells[1,i],objExcel.Cells[50000,i]);
            excelRange.HorizontalAlignment= XlHAlign.xlHAlignCenter;
            excelRange.ColumnWidth= colWidth[i-1];
            excelRange.Font.Size= 11;
        }

//写入标头   for (int i = 1; i <= 3; i++)
        {
            ((Microsoft.Office.Interop.Excel.Range)objExcel.Cells[1,i]).Borders.Weight = 2;
            objExcel.Cells[1,i] = tableHeadTitle[i - 1];
        }

//合并4、5格，并填入列名：d        excelRange = objExcel.get_Range(objExcel.Cells[1,4], objExcel.Cells[1,5]);
        excelRange.Merge(Missing.Value);
        excelRange.Borders.Weight= 2;
        excelRange.set_Value(System.Reflection.Missing.Value,"d");

        ......

        System.Threading.Thread.CurrentThread.CurrentCulture= oldCulture;
//设置EXCEL是否可见        objExcel.Visible = true;
//保存文件
    }
catch (Exception error)
    {
       AppMessageBox.ShowExceptionNoTranslate(error.Message);
return;
    }
finally
    {
//关闭Excel应用        GC.Collect();
    }
}

本文题目：私人笔记--C#导出Excel-创新互联
网址分享：http://cxhlcq.com/article/jcpjc.html

私人笔记--C#导出Excel-创新互联

其他资讯

网站制作

企业服务

网站建设

服务器托管