try
{
//将数字格式化为金额(要格式化的单元格内的值必须为数值型)
// xlsheet.get_Range(xlsheet.Cells[2, 1], xlsheet.Cells[10, 8]).set_NumberFormat("¥#,##0.00"); xlsheet.Export( classPath+@"\" +xuehao + ".xls", SheetExportActionEnum.ssExportActionNone, SheetExportFormat.ssExportXMLSpreadsheet); }
catch
{
this.msg.Visible = true;
msg.Text = "导出失败!";
}
我想让生成的excle文件导出到用户电脑上可是不知道怎么才能导到客户端电脑上,它只能导到服务器电脑上,求大家给个解决办法,让它导出到客户电脑上,其它的方法也可以,不过在下水平不高,所以力求简单详细
我是新人手上的分不多,大家别介意啊
{
//将数字格式化为金额(要格式化的单元格内的值必须为数值型)
// xlsheet.get_Range(xlsheet.Cells[2, 1], xlsheet.Cells[10, 8]).set_NumberFormat("¥#,##0.00"); xlsheet.Export( classPath+@"\" +xuehao + ".xls", SheetExportActionEnum.ssExportActionNone, SheetExportFormat.ssExportXMLSpreadsheet); }
catch
{
this.msg.Visible = true;
msg.Text = "导出失败!";
}
我想让生成的excle文件导出到用户电脑上可是不知道怎么才能导到客户端电脑上,它只能导到服务器电脑上,求大家给个解决办法,让它导出到客户电脑上,其它的方法也可以,不过在下水平不高,所以力求简单详细
我是新人手上的分不多,大家别介意啊
private void Export(string FileType, string FileName)
{
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.ContentType = FileType;
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
GridView1.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
} /// 此方法必重写,否则会出错
public override void VerifyRenderingInServerForm(Control control)
{
}
只是保存到服务器上了,所以下面楼主这里改成download的下载代码即可
转到下载页面download.aspx即可:
protected void Page_Load(object sender, EventArgs e)
{
//string fileName = Request.QueryString["ID"];
string fileName = "Test.csv";
string path = Server.MapPath("");
path += @"\Attachment\" + fileName;
FileInfo file = new FileInfo(path);
Response.Clear();
Response.Charset = "utf-8";
Response.Buffer = true;
this.EnableViewState = false;
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AddHeader("Content-Disposition", "attachment;filename=" + fileName);
Response.AddHeader("Content-Length", file.Length.ToString());
Response.ContentType = "application/octet-stream";
Response.WriteFile(file.FullName);
Response.End();
Response.Close();
}
所以说不要这部分代码,直接替换为下载代码,让用户自己保存到哪里!