Announcements
Hi All,
Can you please let me know, how i have to display amount with currency symbol in EXCEL.
my code
excelWorksheet.cells().item(k,18).value(salesUnitPrice);
is this possible here to pass currency symbol?
please give me more shd on this.
thanks!
Hi @rp@n,
Displaying the currency symbol in the same cell as the amount is related to the cell format; not the value. It should be possible to manage the format using the Excel API. You can try to find some information how to change cell format using the Excel API, you can record a macro in Excel and see what methods are being called or ask your question on the Excel community: techcommunity.microsoft.com/.../Excel_Cat
Hi @pr@n,
You need to use NumberFormat method on SysExcelRange class to apply the format you need. And to get range from row and column value you can use SysExcelWorksheetHelper.getWorksheetRange.
To get an understanding of what should you do in x to achieve something in Excel, you can open empty Excel, start Macro recording and do needed changes on the sheet in Excel (like change format). When you stop macro recording you will get code you want to apply in x (of course it VB, but it can be easily converted to X ).
Number format in your case could be
"[$Â¥-ja-JP]#,##0.00"
You can pass any values you want. But if you want to put currency symbol and amount in the same field, then you must combine these two into one string in x++, and then pass this string in your Excel cell.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 385 Super User 2026 Season 1
Subra 270
Martin Dráb 243 Most Valuable Professional
