java解析excel货币格式,格式化Excel单元格（货币）

这个对我有用 . 我有excel测试应用程序，将货币格式化为2位小数，逗号为千位分隔符 . 下面是在Excel文件上写入数据的控制台应用程序 .

确保您引用了Microsoft.Office.Interop.Excel dll

using System.Collections.Generic;

using Excel = Microsoft.Office.Interop.Excel;

namespace ConsoleApplication2

{

class Program

{

static void Main(string[] args)

{

var bankAccounts = new List {

new Account { ID = 345678, Balance = 541.27},

new Account {ID = 1230221,Balance = -1237.44},

new Account {ID = 346777,Balance = 3532574},

new Account {ID = 235788,Balance = 1500.033333}

};

DisplayInExcel(bankAccounts);

}

static void DisplayInExcel(IEnumerable accounts)

{

var excelApp = new Excel.Application { Visible = true };

excelApp.Workbooks.Add();

Exce