Hi I am writing a script which has multiple awk statements and each statement gives me a numeric count as an output.
I want those output to be stored in different cells of a csv file.
say 12 awk statements give 12 output and i want them in diffrenet cells of csv file.
Thank you guys..!!
Did you try anything?
awk -F , 'BEGIN{count1=0;count2=0;print "Number of empty lines in each file"} NR==FNR{if(NF==0) count1++;f1=FILENAME} NR!=FNR{if(NF==0) count2++;f2=FILENAME}
END{printf "%s,%s,\n%s,%s\n\n",f1,f2,count1,count2}' u.txt u1.txt > summary.csv
here output is written to separate cells but i wanted them to be written to specific cells say sheet2!A15
anyways i am writing Macro for nw.. 
I don't think it's possible in the text file (not a csv, anyway - maybe if you were writing ODF or similar).
You might be able to do something on the Excel end with the text import wizard (or just write a macro, as you say).
1 .csv file will be imported into 1 sheet. It is not designed to address cells in other sheets, nor to address random cells. If you want an entry into A15, you need to do it like
,,,,,,,,,,,,,data