search

weshatheleopard / rubyXL

Ruby lib for reading/writing/modifying .xlsx and .xlsm files
MIT License
1.27k stars 253 forks source link

xlsm format not working #425

Open bouaik opened 2 years ago

bouaik commented 2 years ago

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")
harsh183 commented 2 years ago

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

bouaik commented 2 years ago

convert it directly in excel you mean ??

harsh183 commented 2 years ago

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