in reply to Re: Format iostat output into excel graphs to analyse disk io bottlenecks
in thread Format iostat output into excel graphs to analyse disk io bottlenecks

Using the following line: print "Content-type: application/vnd.ms-excel", "\n\n"; will force anything viewed in IE to open via Excel. It can be used like so:
#!/usr/bin/perl open TABBED_FILE,"your_tabbed_file.txt";# or die "cant open tabbed fil +e $!"; @data = <TABBED_FILE>; close TABBED_FILE; print "Content-type: application/vnd.ms-excel", "\n\n"; print "Col A\tCol B\Col C\n"; foreach $line(@data) { my ($thingA,$thingB,$thingC)=split(/\t/,$line); print "$thingA\t$thingB\t$thingC\n"; }
======================== JIC
  • Comment on Re: Re: Format iostat output into excel graphs to analyse disk io bottlenecks
  • Download Code