rubyXL
rubyXL copied to clipboard
xlsm format not working
I'm generating a xlsm format but office 365 excel can't open it
workbook = RubyXL::Workbook.new
worksheet = workbook.add_worksheet('Sheet2')
worksheet.add_cell(0, 0, 'Test') # Sets cell A1 to string "Test"
workbook.write("file.xlsm")
Could you generate an xlsx and then convert that to xlsm?
convert it directly in excel you mean ??
Yeah, like can you generate an xlsx file using rubyXL and then convert to xlsm using an external tool?