私人笔记--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://myzitong.com/article/jcpjc.html