私人笔记--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 name public 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-创新互联
URL分享：http://mswzjz.cn/article/jcpjc.html