blocks|key|4488620|text|您需要在单元格上设置Numberformat。在底层XML中，需要设置的NumFmtId是1。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4488621|我看不到可以直接设置格式Id的方法，而是需要设置格式字符串。documentation+here列出了Id和格式字符串之间的(一些)映射。在您的情况下，看起来需要"0"|4488622|private+static+void+WriteExcelFile(string+path)
{
++++using+(var+package+=+new+ExcelPackage())
++++{
++++++++var+workbook+=+package.Workbook;
++++++++var+worksheet+=+workbook.Worksheets.Add("Sheet1");
++++++++var+cell+=+worksheet.Cells["A1"];

++++++++cell.Value+=+20150602125320;

++++++++cell.Style.Numberformat.Format+=+"0";

++++++++//DefaultColWidth+just+set+so+you+don't+end+up+with+#######
++++++++//this+is+not+required
++++++++worksheet.DefaultColWidth+=+20;
++++++++package.SaveAs(new+System.IO.FileInfo(path));
++++}
}|code-block|syntax|javascript|4488623|entityMap|0|LINK|mutability|MUTABLE|url|http://www.nudoq.org/#!/Packages/EPPlus/EPPlus/ExcelNumberFormatXml/P/NumFmtId^0|A|C|10|8|19|1|0|29|3|U|I|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|11|8|@$9|12|A|13|B|C]]|D|@$9|14|A|15|1|16]]|E|$]]|$1|H|3|I|5|J|7|17|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|18|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

You need to set the <code>Numberformat</code> on the cell. In the underlying XML the <code>NumFmtId</code> you need to set is <code>1</code>.

I can't see a way that you can set the format Id directly, instead you need to set the format string. The <a href="http://www.nudoq.org/#!/Packages/EPPlus/EPPlus/ExcelNumberFormatXml/P/NumFmtId" rel="nofollow">documentation here</a> lists (some of ) the mappings between the Id's and format strings. In your case it looks like you need <code>"0"</code>:

<pre><code>private static void WriteExcelFile(string path)
{
 using (var package = new ExcelPackage())
 {
 var workbook = package.Workbook;
 var worksheet = workbook.Worksheets.Add("Sheet1");
 var cell = worksheet.Cells["A1"];

 cell.Value = 20150602125320;

 cell.Style.Numberformat.Format = "0";

 //DefaultColWidth just set so you don't end up with #######
 //this is not required
 worksheet.DefaultColWidth = 20;
 package.SaveAs(new System.IO.FileInfo(path));
 }
}
</code></pre>

blocks|key|4489764|text|您必须设置格式字符串以匹配您要查找的内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4489765|[TestMethod]
public+void+Big_Number_Format()
{
++++//http://stackoverflow.com/questions/31124487/write-to-excel-without-scientifc-notation-using-epplus
++++var+existingFile+=+new+FileInfo(@"c:\temp\temp.xlsx");
++++if+(existingFile.Exists)
++++++++existingFile.Delete();

++++using+(var+package2+=+new+ExcelPackage(existingFile))
++++{
++++++++var+ws+=+package2.Workbook.Worksheets.Add("Sheet1");
++++++++ws.Cells[1,+1].Value+=+20150602125320;
++++++++ws.Cells[1,+2].Value+=+20150602125320;

++++++++ws.Cells[1,+1].Style.Numberformat.Format+=+"0";
++++++++ws.Cells[1,+2].Style.Numberformat.Format+=+"0.00";
++++++++package2.Save();
++++}
}|code-block|syntax|javascript|4489766|如果您想在excel中查看在功能区中看到的“内置”格式的常规列表，您可以在此处查看它们，但您无法在应用程序中直接访问它们，因为它们被标记为internal|offset|length|style|CODE|4489767|https://github.com/JanKallman/EPPlus/blob/master/EPPlus/Style/XmlAccess/ExcelNumberFormatXml.cs#L62|4489768|///+<summary>
///+Id+for+number+format
///+
///+Build+in+ID's
///+
///+0+++General+
///+1+++0+
///+2+++0.00+
///+3+++#,##0+
///+4+++#,##0.00+
///+9+++0%25+
///+10++0.00%25+
///+11++0.00E%2B00+
///+12++#+?/?+
///+13++#+??/??+
///+14++mm-dd-yy+
///+15++d-mmm-yy+
///+16++d-mmm+
///+17++mmm-yy+
///+18++h:mm+AM/PM+
///+19++h:mm:ss+AM/PM+
///+20++h:mm+
///+21++h:mm:ss+
///+22++m/d/yy+h:mm+
///+37++#,##0+;(#,##0)+
///+38++#,##0+;[Red](#,##0)+
///+39++#,##0.00;(#,##0.00)+
///+40++#,##0.00;[Red](#,##0.00)+
///+45++mm:ss+
///+46++[h]:mm:ss+
///+47++mmss.0+
///+48++##0.0E%2B0+
///+49++@
///+</summary>+|4489769|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1X|8|0|0|2R|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Z|8|@$I|10|J|11|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|12|8|@]|9|@$I|13|J|14|1|15]]|A|$]]|$1|O|3|P|5|D|7|16|8|@]|9|@]|A|$E|F]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|N]]]]

You have to set the format string to match what you are looking for:

<pre><code>[TestMethod]
public void Big_Number_Format()
{
 //http://stackoverflow.com/questions/31124487/write-to-excel-without-scientifc-notation-using-epplus
 var existingFile = new FileInfo(@"c:\temp\temp.xlsx");
 if (existingFile.Exists)
 existingFile.Delete();

 using (var package2 = new ExcelPackage(existingFile))
 {
 var ws = package2.Workbook.Worksheets.Add("Sheet1");
 ws.Cells[1, 1].Value = 20150602125320;
 ws.Cells[1, 2].Value = 20150602125320;

 ws.Cells[1, 1].Style.Numberformat.Format = "0";
 ws.Cells[1, 2].Style.Numberformat.Format = "0.00";
 package2.Save();
 }
}
</code></pre>

If you want to see the a general list of the "built in" formats you see in the ribbon in excel you can see them here but you cant access them direct in you app since they are marked as <code>internal</code>:

<a href="https://github.com/JanKallman/EPPlus/blob/master/EPPlus/Style/XmlAccess/ExcelNumberFormatXml.cs#L62" rel="nofollow noreferrer">https://github.com/JanKallman/EPPlus/blob/master/EPPlus/Style/XmlAccess/ExcelNumberFormatXml.cs#L62</a>

<pre><code>/// &lt;summary&gt;
/// Id for number format
/// 
/// Build in ID's
/// 
/// 0 General 
/// 1 0 
/// 2 0.00 
/// 3 #,##0 
/// 4 #,##0.00 
/// 9 0% 
/// 10 0.00% 
/// 11 0.00E+00 
/// 12 # ?/? 
/// 13 # ??/?? 
/// 14 mm-dd-yy 
/// 15 d-mmm-yy 
/// 16 d-mmm 
/// 17 mmm-yy 
/// 18 h:mm AM/PM 
/// 19 h:mm:ss AM/PM 
/// 20 h:mm 
/// 21 h:mm:ss 
/// 22 m/d/yy h:mm 
/// 37 #,##0 ;(#,##0) 
/// 38 #,##0 ;[Red](#,##0) 
/// 39 #,##0.00;(#,##0.00) 
/// 40 #,##0.00;[Red](#,##0.00) 
/// 45 mm:ss 
/// 46 [h]:mm:ss 
/// 47 mmss.0 
/// 48 ##0.0E+0 
/// 49 @
/// &lt;/summary&gt; 
</code></pre>

I have a very straightforward question. I have a C# application which does some data processing and then outputs to an excel file using EPPlus. The problem is that some of my numbers are very long, for example, a data value could be something like <code>20150602125320</code>, which turns into <code>2.01506E+13</code> in the excel sheet. I am trying to avoid this. Converting the value to string works but I need them as numbers for further operations within excel. Anyone know any way I can keep the data in its original form without the scientific notation? Thank you!

Write to Excel without scientifc notation using EPPlus

我有一个非常直接的问题。我有一个C#应用程序，它进行一些数据处理，然后使用EPPlus输出到excel文件。问题是我的一些数字很长，例如，一个数据值可能类似于20150602125320，它在excel工作表中转换为2.01506E+13。我正在努力避免这种情况。将值转换为字符串有效，但我需要它们作为数字，以便在exc...

问使用EPPlus在没有科学表示法的情况下写入Excel
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用EPPlus在没有科学表示法的情况下写入ExcelEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用EPPlus在没有科学表示法的情况下写入Excel
EN