Hey guys, I''m trying to create a spreadsheet with Ruby using the spreadsheet gem. I''m able to create a new sheet and add data and everything but I''m wondering, is there any way to preserve macros and vb projects in an existing xls file then add data to it in a new sheet? Currently, I''m opening a spreadsheet with macros and vb projects, adding a new sheet to it with my created data...but when I open it, the VB projects, macros and conditional formatting is all lost. Any help would be greatly appreciated! Thanks! -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Spec Ex wrote:> Hey guys, > > I''m trying to create a spreadsheet with Ruby using the spreadsheet gem. > I''m able to create a new sheet and add data and everything but I''m > wondering, is there any way to preserve macros and vb projects in an > existing xls file then add data to it in a new sheet? Currently, I''m > opening a spreadsheet with macros and vb projects, adding a new sheet to > it with my created data...but when I open it, the VB projects, macros > and conditional formatting is all lost. > > Any help would be greatly appreciated! > > Thanks!Anyone? -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.