Friday, November 18, 2016
Hello,
-- I am using rubyXL version 3.3.16. I and trying to interact with a .xlsm document to perform data read/write.
There is also a macro within the worksheet which I need to run at the end. Is there a way I could run the excel macros using rubyXL version 3.3.16 ?
Below is my code to access the excel and the worksheet:
require 'rubyXL'
workbook = RubyXL::Parser.parse("<abc.xlsm>")
myWorksheet = workbook[0]
Please help on how to run any existing macros in the workbook.
Thanks!
John
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/083a7a54-3343-44ed-aabf-b048678750c7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment