Ruby and Excel stuff

Discussion in 'Ruby' started by Assaf Peled, Feb 6, 2012.

  1. Assaf Peled

    Assaf Peled Guest

    Hi,

    I'm using the WIN32OLE extension to handle Excel files through Ruby.
    I can't seem to do the simple task of cell alignment to the left/
    center, when I use :

    sheet.columns(2).HorizontalAlignment = xlCenter (or xlLeft for that
    matter).

    Did anyone encountered that problem and knows how it can be solved ?

    Thanks a lot !
     
    Assaf Peled, Feb 6, 2012
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.