格式化一个Excel列（或单元）在C＃中的文本？ [英] Format an Excel column (or cell) as Text in C#?

问题描述

我失去了前导零，当我从一个DataTable复制值一个Excel工作表。这是因为可能Excel将值作为一个数字，而不是文字。

I am losing the leading zeros when I copy values from a datatable to an Excel sheet. That's because probably Excel treats the values as a number instead of text.

我创建了C＃的工作，我复制值，像这样：

I created the worksheet in C# and I am copying the values like so:

myWorksheet.Cells[i + 2, j] = dtCustomers.Rows[i][j - 1].ToString();

我如何格式化整列或每个单元为文本？一个相关的问题，如何投 myWorksheet.Cells [I + 2，J] 来显示智能感知的样式属性？

How do I format a whole column or each cell as Text? A related question, how to cast myWorksheet.Cells[i + 2, j] to show a style property in Intellisense?

推荐答案

下面是一些code到列A和C画幅中的取值preadsheetGear对于具有的API，它类似于到Excel .NET - 除了事实了S preadsheetGear经常更强类型。它不应该太难搞清楚如何转换这种与Excel / COM工作：

Below is some code to format columns A and C as text in SpreadsheetGear for .NET which has an API which is similar to Excel - except for the fact that SpreadsheetGear is frequently more strongly typed. It should not be too hard to figure out how to convert this to work with Excel / COM:

IWorkbook workbook = Factory.GetWorkbook();
IRange cells = workbook.Worksheets[0].Cells;
// Format column A as text.
cells["A:A"].NumberFormat = "@";
// Set A2 to text with a leading '0'.
cells["A2"].Value = "01234567890123456789";
// Format column C as text (SpreadsheetGear uses 0 based indexes - Excel uses 1 based indexes).
cells[0, 2].EntireColumn.NumberFormat = "@";
// Set C3 to text with a leading '0'.
cells[2, 2].Value = "01234567890123456789";
workbook.SaveAs(@"c:\tmp\TextFormat.xlsx", FileFormat.OpenXMLWorkbook);

免责声明：我自己对S preadsheetGear有限责任公司

Disclaimer: I own SpreadsheetGear LLC

这篇关于格式化一个Excel列（或单元）在C＃中的文本？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！