长数字正常导入Excel
例子程序如下： string data1 = "000000001"; long data2 = 123456789123456789; System.IO.StringWriter sw = new System.IO.StringWriter(); sw.WriteLine("原数字1/t转换后数字1/t原数字2/t转换数字2"); for (int i = 0; i < 10; i++) { //sw.WriteLine(data1 + "/t" + "=/"" + data1 + "/"/t" + data2 + "/t" + "=/"" + data2.ToString() + "/""); sw.WriteLine( "=/"" + data1 + "/""); } sw.Close(); Response.Buffer = true; Response.Charset = ""; Response.AppendHeader("Content-Disposition", "attachment;filename=aa.xls"); Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。 Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文 Response.Write(sw); Response.End();
http://www.qdacc.net/ 奇货可居网
会计理论与实务经验互动交流学习平台
