Sorry, I thought the solution is to replace " by """" in CSV. But that seems to not be the solution as the excel also shows """". I think I might have to go to some excel forums as this seems to be an excel problem ?
---------- Post updated at 04:00 PM ---------- Previous update was at 03:44 PM ----------
Hi,
Can anyone tell the option to change the file type in unix.
i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format.
Thanks in advance,
Milton. (1 Reply)
Hi does anybody know how to convert xls to csv undex linux.
I need only data (that is log from test, dont need any macro and so on) from xls.
Any idea how to do that? Perl? shell? Could you give me any example?
Thanks in advance for answer.
Gracjan (4 Replies)
Ok, every morning at my office we send out excel sheets to Economy people with statistics for yesterdays trading.
All the trading run's in Redhat or Solaris environments.
We run a script on a Redhat server whitch generates the stats in CSV format.
After we download we open it in Excel and... (3 Replies)
I would like to know if have one way with read table from oracle converter in CSV o TXT and After converter in XLS or spreedsheet
Thanks so much
JAvier (3 Replies)
Hello
I have a script which converts log to csv.
Now I need to have xls.
Is there any easy way/command which can convert csv to xls?:confused:
preferably just using bash and not perl,... is it possible? (1 Reply)
Discussion started by: frhling
1 Replies
LEARN ABOUT DEBIAN
ifpps
ifpps(8) netsniff-ng-toolkit ifpps(8)NAME
ifpps - fetch and format kernel network statistics
SYNOPSIS
ifpps -d|--dev <netdev> [-t|--interval <sec>][-p|--promisc][-c|--term]
[-C|--csv][-H|--csv-tablehead][-l|--loop][-v|--version][-h|--help]
DESCRIPTION
A tiny tool to provide top-like reliable networking statistics. ifpps reads out the 'real' kernel statistics, so it does not give
erroneous statistics on high I/O load.
OPTIONS
ifpps --dev eth0
Fetch eth0 interface statistics.
ifpps --dev eth0 --interval 60 --csv
Output eth0 interface statistics every minute in CSV format.
OPTIONS
-h|--help
Print help text and lists all options.
-v|--version
Print version.
-d|--dev <netdev>
Device to fetch statistics for i.e., eth0.
-p|--promisc
Put the device in promiscuous mode
-t|--interval <time>
Refresh time in sec (default 1 sec)
-c|--term
Output to terminal
-C|--csv
Output in CSV format. E.g. post-processing with Gnuplot et al.
-H|--csv-tablehead
Print CSV table head.
-l|--loop
Loop terminal output.
AUTHOR
Written by Daniel Borkmann <daniel@netsniff-ng.org>
DOCUMENTATION
Documentation by Emmanuel Roullit <emmanuel@netsniff-ng.org>
BUGS
Please report bugs to <bugs@netsniff-ng.org>
2012-06-29 ifpps(8)