CODEWITHSUNDEEP
javaexcelcsv
user727272
user727272

Reputation: 475

Excel to csv conversion in java. Problems with currency representation

while converting from excel to csv using the jxl api, I face a problem which is any currency amount greater than 999 is being split into two columns.

i.e $100,000 is split into 100 and 000.

does anyone have a reliable java code that can convert excel to csv without any problems,

regards,

nithen

Upvotes: 0

Views: 865

Answers (1)

Alex
Alex

Reputation: 35098

Enclose the column into quotes otherwise the , is treated as a column seperator

"$100,000"

Upvotes: 1

Related Questions