不使用模板导出Excel(C#版本)
不多说,直接上干货!
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Services; using System.IO; using System.Web.Services.Protocols; using Paims.Server.Business; using Paims.Server.Business.Common; using Paims.Server.UI; using Paims.Server.UI.HttpExtension; using System.Xml; using System.Xml.Linq; using System.Text; using System.Data; using System.Data.Linq; using System.Data.Common; using System.Data.OleDb; using Paims.Website.Service.WordHelpers; using Microsoft.Office.Interop.Excel; using System.Windows.Forms; using System.Web.UI; using System.Web.UI.HtmlControls; using MIS.Common.Exceptions; namespace Paims.WebSite.Service.Export { /// <summary> /// ExportExpertWebService 的摘要说明 /// </summary> [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem(false)] // 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务,请取消对下行的注释。 // [System.Web.Script.Services.ScriptService] public class ExportExpertWebService : WebServiceBase { [WebMethod] public string Exportexpert() { Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application(); object missing = System.Reflection.Missing.Value; object Visible = false; object ReadOnly = false; Microsoft.Office.Interop.Excel._Workbook myWorkbook; //工作薄实例声明 Microsoft.Office.Interop.Excel._Worksheet myWorksheet; //工作表实例声明 excel.Application.Workbooks.Add(true); //不存在相同文件,则建立一个新的文件 myWorkbook = excel.ActiveWorkbook; //工作薄赋值为excel中的已激活工作薄 myWorksheet = (Microsoft.Office.Interop.Excel._Worksheet)myWorkbook.ActiveSheet; //工作表赋值为工作簿中已激活的工作表 string[] IDStrings = {"123","234","123","234","123","234","123","234"}; //获取数据库中的行数,并将其保存到excel中 for (int i = 0; i < 7; i++) { myWorksheet.Cells[i + 2, 1] = IDStrings[i].ToString(); } myWorksheet.Name = "sheetTest"; //给工作表取名字 //将工作簿另存为 myWorkbook.SaveAs(@"D:\test5.xlsx", missing, missing, missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing , missing, missing); myWorkbook.Close(null, null, null); //关闭工作簿 excel.Quit(); //退出excel excel = null; //赋值为NULL } } }