From: Daniel Danopia <danopia@...>
Date: 2009-10-09T19:45:09+09:00
Subject: Re: write a file

On Oct 8, 4:07 pm, Li Chen <chen_...@yahoo.com> wrote:
> data_all=[
>         (1..10).to_a,
>         (1..10).to_a,
>         (1..10).to_a,
>          (1..10).to_a
>          ]# a 2D array
>
> File.open('test3.txt','w') do |a_f|
>        data_all.each do |row |
>               row.each {|e| a_f.print e ;   a_f.print "\t"}
>               a_f.puts
>        end
>
> end

I would do something more along the lines of this:

File.open('test.txt', 'w') do |file|
    data_all.each do |row|
        file.puts row.join("\t")
    end
end

On Oct 8, 10:09 pm, botp <botp...@gmail.com> wrote:
> you may want to look at fastercsv.
>
> kind regards -botp

This is tab-separated, but if Excel is the ultimate goal, I guess that
CSV would work. Fortunately, I don't use Excel, so I don't know much
along those lines.