Execl 操作

至尊贱客 2011-12-10 03:50:34

请问在asp.net 中客户端导出真正的Execl 而不是代码生成的（可以用文本打开看到代码的那种）
（使用Execl组件的话希望提供组件在服务器中注册的方法）
或者说如何在服务器的指定目录下生成Execl 然后提供下载

另外服务器中没有安装Execl 也不允许安装

...全文

140 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

ajaxtop 2011-12-11

打赏
举报

也可以通过控件导出

ajaxtop 2011-12-11

打赏
举报

或者说如何在服务器的指定目录下生成Execl 然后提供下载

另外服务器中没有安装Execl 也不允许安装

这个肯定是不行的，不允许安装，那也得安装个插件

不安装怎么生成Excel
下面代码如下：





using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.IO;

using Excel;

using System.Reflection;

using whims.model;



public partial class ExcelReport : System.Web.UI.Page

{



    protected void Page_Load(object sender, EventArgs e)

    {

        string save_path = "", tick = "";

        ExcelOperate excelOperate = new ExcelOperate();

        string temp_path = Server.MapPath("~/xls_files");//生成的文件存放路径

        if (!Directory.Exists(temp_path))

        {

            Directory.CreateDirectory(temp_path);

        }



        try

        {

            DataView dv = Cache["ReportByNone"] as DataView;    //***

            //建立一个Excel.Application的新进程

            Excel.Application app = new Excel.Application();

            if (app == null)

            {

                return;

            }

            app.Visible = false;

            app.UserControl = true;

            Workbooks workbooks = app.Workbooks;

            _Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);

            Sheets sheets = workbook.Worksheets;

            _Worksheet worksheet = (_Worksheet)sheets.get_Item(1);

            if (worksheet == null)

            {

                return;

            }

            excelOperate.Merge(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 10]);//横向合并

            excelOperate.WriteRange(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 10], "询价单");

            excelOperate.SetBold(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1]); //黑体

            excelOperate.SetHAlignCenter(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1]);//居中



            excelOperate.SetFontSize(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1], 18);//字体大小

            excelOperate.SetRowHeight(worksheet, worksheet.Cells[1, 1], worksheet.Cells[1, 1], 35);//行高



            //公司

            worksheet.Cells[2, 1] = "买  方：";

            excelOperate.Merge(worksheet, worksheet.Cells[2, 2], worksheet.Cells[2, 3]);//横向合并

            excelOperate.WriteRange(worksheet, worksheet.Cells[2, 2], worksheet.Cells[2, 3], "陕西渭河重化工集团有限责任公司");

            //联系人

            Userinfo userinfo = Session["UserID"] as Userinfo;

            worksheet.Cells[3, 1] = "联系人：";

            excelOperate.Merge(worksheet, worksheet.Cells[3, 2], worksheet.Cells[3, 3]);//横向合并

            excelOperate.WriteRange(worksheet, worksheet.Cells[3, 2], worksheet.Cells[3, 3], userinfo.USERNAME);

            //电话

            worksheet.Cells[4, 1] = "电  话：";

            excelOperate.Merge(worksheet, worksheet.Cells[4, 2], worksheet.Cells[4, 3]);//横向合并

            excelOperate.WriteRange(worksheet, worksheet.Cells[4, 2], worksheet.Cells[4, 3], userinfo.TEL);



            //传真

            worksheet.Cells[4, 4] = "传真：";

            worksheet.Cells[4, 5] = userinfo.UCZ;



            worksheet.Cells[4, 9] = "打印日期：";

            worksheet.Cells[4, 10] = DateTime.Now.ToShortDateString();



            worksheet.Cells[5, 1] = "物资编码";

            worksheet.Cells[5, 2] = "物资名称";

            worksheet.Cells[5, 3] = "规格型号";

            worksheet.Cells[5, 4] = "材质";

            worksheet.Cells[5, 5] = "单位";

            worksheet.Cells[5, 6] = "要求日期";

            worksheet.Cells[5, 7] = "数量";

            worksheet.Cells[5, 8] = "单价";

            worksheet.Cells[5, 9] = "总金额";

            worksheet.Cells[5, 10] = "承诺日期";

            worksheet.Cells[5, 11] = "备注";



            worksheet.get_Range(worksheet.Cells[5, 1], worksheet.Cells[5, 11]).Borders.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Black);//黑色连续边框

            excelOperate.SetBold(worksheet, worksheet.Cells[5, 1], worksheet.Cells[5, 11]); //黑体

            excelOperate.SetHAlignCenter(worksheet, worksheet.Cells[5, 1], worksheet.Cells[5, 11]);//居中

            excelOperate.SetFontSize(worksheet, worksheet.Cells[5, 1], worksheet.Cells[5, 11], 12);//字体大小

            excelOperate.SetRowHeight(worksheet, worksheet.Cells[5, 1], worksheet.Cells[5, 11], 24);//行高



            int rowNum = dv.Count;

            for (int i = 0; i < rowNum; i++)

            {

                worksheet.Cells[6 + i, 1] = "'" + dv[i].Row[0].ToString();  //0物资编码

                worksheet.Cells[6 + i, 2] = dv[i].Row[1].ToString();       //1物资名称

                worksheet.Cells[6 + i, 3] = dv[i].Row[2].ToString();   //  2规格型号 3物资材质 4计量单位 5系统码 6数量 7交货日期

                worksheet.Cells[6 + i, 4] = dv[i].Row[3].ToString();    

                worksheet.Cells[6 + i, 5] = dv[i].Row[4].ToString();   

                worksheet.Cells[6 + i, 6] = Convert.ToDateTime(dv[i].Row[7].ToString()).ToShortDateString();   

                //y

                worksheet.Cells[6 + i, 7] = dv[i].Row[6].ToString();     //

            }

            excelOperate.SetColumnWidth(worksheet, "A", 12);

            excelOperate.SetColumnWidth(worksheet, "B", 14);

            excelOperate.SetColumnWidth(worksheet, "C", 20);

            excelOperate.SetColumnWidth(worksheet, "D",6);

            excelOperate.SetColumnWidth(worksheet, "E", 5);

            excelOperate.SetColumnWidth(worksheet, "F", 9);  //交货日期

            //Y

            excelOperate.SetColumnWidth(worksheet, "G", 5);  //数量

            excelOperate.SetColumnWidth(worksheet, "H", 5);

            excelOperate.SetColumnWidth(worksheet, "I", 15);

            excelOperate.SetColumnWidth(worksheet, "J", 9);



            worksheet.Name = "询价单工作区";

            tick = DateTime.Now.Ticks.ToString();

            save_path = temp_path + "\\" + tick + ".xls";

            workbook.SaveAs(save_path, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

            excelOperate.Dispose(worksheet, workbook, app);//关闭Excel进程

            Response.Write(save_path);

        }

        catch

        {

            Response.Write("Error");

        }

        finally

        {

            Response.End();

        }



    }





}