py_xls2csv(1) General Commands Manual py_xls2csv(1)NAME
py_xls2csv - convert an Excel xls file to a comma separated value csv file
SYNOPSIS
py_xls2csv input-file
DESCRIPTION
This manual page was written for the Debian distribution because the original program does not have a manual page.
py_xls2csv takes an Excel xls file as an argument and converts it to a comma separated value csv file. Output is sent to stdout.
Additional utility scripts can be found in the tools/ directory.
OPTIONS
This program does not take any command line options.
AUTHOR
pyexcelerator and py_xls2csv were written by Roman V. Kiseliov <roman@kiseliov.ru>.
This manual page was written by Kevin Coyner <kcoyner@debian.org> for the Debian system (but may be used by others). Permission is granted
to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 any later version published
by the Free Software Foundation.
On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.
SEE-ALSOpyexcelerator(1), py_xls2txt(1), py_xls2html(1)
October 12, 2006 py_xls2csv(1)
Check Out this Related Man Page
GRUB-CHOOSE-DEFAULT(8) System Manager's Manual GRUB-CHOOSE-DEFAULT(8)NAME
grub-choose-default -- control grub default through a GUI
SYNOPSIS
grub-choose-default [-r]
DESCRIPTION
This manual page documents briefly the grub-choose-default command.
This manual page was written for the Debian distribution because the original program does not have a manual page.
grub-choose-default lets you control what entry from the grub menu should be booted next time you start your computer.
OPTIONS -r If used, grub-choose-default will show the reboot option, which is disabled by default
AUTHOR
This manual page was written by Kjell Braden <fnord@pentabarf.de> for the Debian system (but may be used by others). Permission is granted
to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 or any later version published
by the Free Software Foundation.
The program itself is written by David Mohr <david@mcbf.net> Permission is granted to copy, distribute and/or modify this document under
the terms of the GNU General Public License, Version 2 or any later version published by the Free Software Foundation.
On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.
GRUB-CHOOSE-DEFAULT(8)
I am trying to check each line and based on first two digits, the comma needs to be place. I checked in the earlier post where the text is converted to csv with a tab delimited.
Here is the test file that needs to be changed to csv
11 051701
22 051701
330123405170105170112345... (13 Replies)
Hello, i am bit stuck with making script for automatic procedure.
Case:
Two files. One is flat file, other is csv file.
csv file has two column/fields with comma delimited data.
Here is what i need (explained way)
CSV file:
field1 | field2
"hello","byebye"
"hello2","byebye2"... (23 Replies)
Hi,
I was trying some split command to pull out values like "uid=abc,ou=INTERNAL,ou=PEOPLE" into a csv file. However because of erratic nature of occurrance of rows made me stopped. Could someone help me in this? and if someone has a one liner for this?
The text file contain pattern like this... (14 Replies)
Hi,
Suppose in some directory (/APPS/TEST) I have a file ABCTEST.csv. I want to write a IF condition in which I want to check if filename contains the string ABC then I will do certain operations .
I have a variable having value as /APPS/TEST/ABCTEST.csv
How Can I achieve this...please... (14 Replies)
Hello Expert,
I have a file in the following format:
SYNTAX_VERSION 5
MONITOR "NAME_TEMPLATES"
DESCRIPTION "Monitors for contents of error "
INTERVAL "1m"
MONPROG "script.sh NAME_TEMPLATES"
MAXTHRESHOLD
GEN_BELOW_RESET
SEVERITY Major
... (17 Replies)
Hi Guys,
I have text file which is tab/space separated but I want it to re-format into a comma separated and trim the spaces in between. Can someone spare me a perl or sed script that can do the job?
INPUT FILE:
500010245623 500 21-APR-11 05.58.21 PM ... (14 Replies)
Hi,
I have csv file with records as below. Now i have remove any comma in the filed value because that creates problem when i feed this file to an application.
for example below are two sample records, the second record have a comma in "Salesforce.com, Inc." field, now i have to remove this... (13 Replies)
Hi,
I am newbie in unix.
Could someone tell me how do I redirect my grep output to a csv/excel ?
I have used below command but the outputs are appearing in one column Not in different column.
grep -e cmd -e cmd1 test.txt | cut -f 5 | sort | uniq -c> op.csv
I do not understand how do I... (14 Replies)
Hello All,
I need to convert a csv file to pipeline delimiter file in UNIX. The data in file itself contains comma with double qouted qualifier apart from the comma separator. Let me know how to do it. Appreciate any help if awk can be used to do it.
Mentioned below is the sample record of... (14 Replies)
Hello,
I have some bitrate data in a csv which is in an odd format and is difficult to process in Excel when I have thousands of rows. Therefore, I was thinking of doing this in bash and using awk as the primary application except that due to its complication, I'm a little stuck.
... (24 Replies)
Hi Friends,
I want to convert a csv file into a ordinary .txt file. I am able to convert but I want the output to look as shown below in the .txt file
table findhost=
{
{"xyz","abc"},
{"rxz","mmz"},
{"vrr","nnz"},
}
default={"NONE"}
My current perl script
#!/usr/bin/env perl... (12 Replies)
Hall0 Team,
I need you help. I have a .csv file called Pax.csv. It has 13 fields
The fields that i am interested in is field 7, field 10(CallDuration),field 12 and field 13(TelkomAsif)
Field 12(Cost) is affected by what is on field 7(CallType)
if field7= VoIS Community Sharecall then Cost... (14 Replies)
Hi Team,
I have created a script to output DB Query data to a text file. It displays output as follows for 2 different queries appended to same file.
I want help to convert this data to xls format so that the output of first query is in 1 tab and the other in second tab. Please help.
... (14 Replies)
hi
i need to extract lines from multiple files to a csv file.
for example, i have these 3 files
file1.txt
date:29dec1980
caller:91245824255
called:8127766
file2.txt
date:11apr2014
caller:9155584558
called:8115478
file3.txt
date:25jun2015
caller:445225552
called:8117485 (30 Replies)
Hello,
Does anyone know of a way to convert an .xml file (ONIX) to something more workable, like a .csv (or even .xls) file? Ideally something on the command line would be ideal, but not absolutely necessary. I would be dealing with .xml files of 125 MB+.
I am using XQuartz in El Capitan.
... (17 Replies)