10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hey Guys ,
Recently working on a requirement , i had to deal with XLS file with multiple tabs and the requirement was as below :
1. Convert one XLS file with multiple tabs to multiple CSV files.
-- As i was working on MAC , so it was quite easy through APPLESCRIPT to deal with this.But... (2 Replies)
Discussion started by: himanshu sood
2 Replies
2. Shell Programming and Scripting
HI All,
I have a .xls file , in which I have multiple worksheets , I need to remove all the worksheets except the worksheet by name CDR_LOAD_STATS, how can I do this in unix.
Please guide me.
Regards,
Deepti (7 Replies)
Discussion started by: gaur.deepti
7 Replies
3. Shell Programming and Scripting
Hi,
My requirement is to convert the xls to csv file with utf-8 conversion.
Is there any way please suggest me.
Thanks,
Raja (4 Replies)
Discussion started by: cnraja
4 Replies
4. UNIX for Advanced & Expert Users
Hi All,
I wrote a script to extract data from Oracle DB and place it in a text file , and I have coverted .txt file into comma seperated .csv file and I sent it to my mail box .
I can get .xls file in my inbox.I am getting all data in same column and in different rows , without column... (1 Reply)
Discussion started by: krthkmuthu
1 Replies
5. AIX
Hi All,
I have a java program running in AIX machine which gives me the output in form of .CSV but my clients wants output in the form of .xls
When I gave the command mv <filename.csv> <filename.xls>
The contents of this .xls file is not exactly in seprate columns as in CSV, the contents... (1 Reply)
Discussion started by: chetu777
1 Replies
6. Shell Programming and Scripting
Hi Folks,
I've to convert manually couple of *.xls files to *.csv files everyday :(
so i was just wondering if anyone could just help me with a shell script or awk script to automate the process :)
PS : Problem is that i cannot use any third party software for the conversion.
Thanking... (1 Reply)
Discussion started by: chaturvedi
1 Replies
7. Shell Programming and Scripting
I need to convert an excel file into a text file
and an excel file into a CSV file..
any code to do that is appreciated
thanks (6 Replies)
Discussion started by: bandar007
6 Replies
8. Shell Programming and Scripting
Hi,
I have a file coming in xxx.txt(csv format) i do some work on it and i need to send out as a .xls format. Is there any way there is some code i can use in my script to convert this?
I'm struggling on this.
Thanks (11 Replies)
Discussion started by: Pablo_beezo
11 Replies
9. UNIX for Advanced & Expert Users
Hello,
I've been tasked with sending 3 types of data (file size, row count, and file name) to a csv file every month for various vendors. I have been asked to put this in one csv or xls file with each vendor being a different tab (or worksheet). Until now, we have been finding and emailing... (4 Replies)
Discussion started by: tekster757
4 Replies
10. Shell Programming and Scripting
Can we convert an xls file into csv format in Unix
Thanks
Suresh (1 Reply)
Discussion started by: sureshg_sampat
1 Replies
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)