导出到excel-如何导出十进制数字到excel工作表与千位分隔符和小数分隔符 [英] export to excel- how to export a decimal figure to excel sheet with thousand separators and decimal separators

问题描述

嗨朋友们，



我使用VS 2008，asp.net，c＃.net。

我有十进制格式的数字在网格中。

我想将一个十进制数字输出到带有千位分隔符和十进制分隔符的excel表格。

这些数字应该对齐。

例如12,12,34,567.89

此外，必须在导出的Excel工作单上执行in sum bulit excel公式，例如sum ..



Tx提前

george

Hi Friends,

I am using VS 2008 ,asp.net,c#.net.
I have numbers in decimal format in grid.
I want to export a decimal figure to excel sheet with thousand separators and decimal separators.
Those numbers should be aligned right.
for example 12,12,34,567.89
Also the in bulit excel formulas like sum .. must be performed on the exported excel sheet.

Tx in advance
george

推荐答案

您需要将格式详细信息添加到您希望它如上所述出现的单元格中。对于总和，您需要将 SUM（）公式添加到相关单元格。

You need to add formatting details to the cells where you want it to appear as described. For the sum you need to add the SUM() formula to the cell in question.

使用逗号分隔符分隔您的小数值并将此完整数据指向单元格并将单元格插入Excel工作表行

use comma seperator to seperate your decimal values and point this full data into cell and insert cell to row of excel sheet

这篇关于导出到excel-如何导出十进制数字到excel工作表与千位分隔符和小数分隔符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！