rubyXL icon indicating copy to clipboard operation
rubyXL copied to clipboard

xlsm format not working

Open bouaik opened this issue 3 years ago • 8 comments

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")

bouaik avatar Aug 11 '22 12:08 bouaik

Could you generate an xlsx and then convert that to xlsm?

harsh183 avatar Aug 18 '22 16:08 harsh183

convert it directly in excel you mean ??

bouaik avatar Aug 22 '22 13:08 bouaik

Yeah, like can you generate an xlsx file using rubyXL and then convert to xlsm using an external tool?

harsh183 avatar Aug 26 '22 18:08 harsh183