如何更改默认格式(Excel中的常规) [英] How to change default format(General in Excel)

问题描述

大家好，


我有asp.net代码可以将数据导出到excel.我的代码是

Hi All,


I have asp.net code to export data to excel. The code that I have is

protected void ExportToExcel() {
        Response.Clear();
        Response.Buffer = true;
        Response.ContentType = "application/vnd.ms-excel";
        Response.AddHeader("content-disposition", "attachment;filename=MyFiles.xls");
        Response.Charset = "";
        this.EnableViewState = false;

        System.IO.StringWriter sw = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);

        gvFiles.RenderControl(htw);

        Response.Write(sw.ToString());
        Response.End();
    }

我在数据表中有这样的数据

I have data like this in data Table

Numbers
12345,67898
45678,23456
67890,54326,56734
90877,45455,67896

当我使用上述代码将数据表导出为ex​​cel时，导出为ex​​cel后，格式默认更改为常规".

When I export the data table to excel by using the above code the format is changed to by default General after exporting to excel the data is

1,234,456,789
45,678,234,56
6,789,0543,46

在使用Response对象导出数据时，如何在Excel中将格式设置为Text.

How set the format to Text,in Excel while exporting data using Response object.

Help me through C# code.

推荐答案

我们需要使用Microsoft.Office.Interop.Excel命名空间在数据表中应用单元格格式.

We need to apply the cell formatting in the data table using Microsoft.Office.Interop.Excel namespace.

如果您使用的是Excel 2007或更高版本，一种方法是使用Open XML写入excel文件.例如，请参阅:读取和写入Open XML文件(MS Office 2007) [

If you''re using Excel 2007 or above, one way is to write the excel file using Open XML. For example, see: Read and write Open XML files (MS Office 2007)[^]

这篇关于如何更改默认格式(Excel中的常规)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！