使用 C# 格式化整个 Excel 列 [英] Format Entire Excel Column Using C#

问题描述

我有 F 列要格式化为货币，因此添加 $ 符号和逗号.我尝试在源中对其进行格式化为时已晚，因此在将所有数据写入 Excel 后，我将通过 C# 对其进行格式化.我知道您可以使用此语法将一列更改为日期 - 货币的适当语法是什么?

I have column F that I want to format as money so add $ sign and commas. It's to late for me to attempt to format it in the Source so I was going to format it via C# after all data has been written to Excel. I know you can use this syntax to change a column to a date - what would be the appropriate syntax for money?

range.EntireColumn.NumberFormat = "MM/DD/YYYY";

range.EntireColumn.NumberFormat = "MM/DD/YYYY";

推荐答案

抱歉我在这个问题上的愚蠢...其实很简单

Sorry for my stupidity on this one...it's actually quiet simple

range3.EntireColumn.NumberFormat = "$#,##0.00";

range3.EntireColumn.NumberFormat = "$#,##0.00";

这篇关于使用 C# 格式化整个 Excel 列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！