Export a text file from each row of a spreadsheet
Hi,
I'm sure this has been done before and is in other threads but I thought I'd ask. I have a series of rows that I need to export as individual text files i.e. one row would produce one text file. There are 7 columns with the first column being the file name. Columns 2 - 7 would be the input lines in the text file - and ideally there would be one line per column.
I.e. A B C D E F G
A1 0.1 0 0 -0.1 114 116
B1 0.1 0 0 -0.1 114 117
C1 0.1 0 0 -0.1 114 115
First text file would be named "A1" and would have the following text in it:
0.1
0
0
-0.1
114
116
Second file would be "B1" and so on ...
If anybody has some good ideas about this one it would be great to get some feedback.
Thanks,
Mike
|