如何使用axlsx gem - Ruby on Rails将Excel单元格格式化为货币

gem 'axlsx'

require 'axlsx'

def generate_excel_with_currency_format
  p = Axlsx::Package.new
  wb = p.workbook
  styles = wb.styles
  currency_format = styles.add_style(format_code: "[$¥-zh-CN]#,##0.00")
  
  # 假设你有一个名为Sheet1的工作表
  wb.add_worksheet(name: 'Sheet1') do |sheet|
    sheet.add_row ['商品', '价格']
    
    # 设置特定单元格的格式
    sheet.add_row ['手机', 9999], style: [nil, currency_format]
    sheet.add_row ['电视', 4999], style: [nil, currency_format]
  end
  
  p.serialize('path/to/your/excel/file.xlsx')
end

generate_excel_with_currency_format