Hi All,
Please give me the solution to the following ASAP.
1) Converting the .xls into .csv
Script i tried,
Code:
mv hello.xls hello.csv
The above given script converting the .xls file into .csv successfully. But after i run the below unix command I am no able to open the .csv file, its giving some "Unable to Read" Error message.
2) Script I tried to replace the commas by single space in the converted .csv file is,
Code:
tr ', ' ' ' < hello.csv > hello1.csv
When I am running the above scripts for the small files (file contains 10 records of data only) its working fine. But while trying to the big files its giving the error message as "Unable to read". Commands are running without any problem.
Plesae give me the proper solution to the above problem ASAP friends.
Thanks & Regards,
Velava.S
Last edited by pludi; 06-22-2010 at 03:34 AM..
Reason: code tags, please...
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 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)
find . -type f -name "*.sql" -print|xargs perl -i -pe 's/pattern/replaced/g'
this is simple logic to find and replace in multiple files & folders
Hope this helps.
Thanks
Zaheer (0 Replies)
HI,
Please find the text below. I receive a .csv file on server. I need the comma(,) in the second column to be replaced by a semi-colon( ; ).
How to do it. Please help.
Sample text:
"1","lastname1,firstname1","xxxxxx","19/10/2009","23/10/2009","0","N","Leave"... (2 Replies)
I think I know the answer to this :rolleyes: but thought I'd ask anyway. You never know.
Does anyone know of a program or utility that will run on any unix platform and convert Microsoft Excel files to ascii/plain text files that unix can understand ?
Thanks in advance.
Floyd (3 Replies)
hello
I have browsed for the similar requirement i found this
https://www.unix.com/shell-programming-scripting/40163-xls-csv-conversion.html
but my problem is i have multiple tabs in xls file having same metadata
I want to convert it into single csv file
any ways to do it pls... (5 Replies)
Hi All,
Random question, how would you convert a data file from a list like so:
12345
12346
12347
12348
12349
12350
... <snip 100+ lines> ...
to comma separated X columns across:
12345,12346,12347
12348,12349,12350
Why would you want to do this? The background to this is a... (2 Replies)
I have a flat file (template) where I want to replace variables based upon a value in another file (csv).
The variables in the template are named %VAR_X_z%
The values are in the csv file and X is field 0 of each line and y field 1 and up.
Example of the csv:
Badidas, 13.00, 12.00, 11.00,... (8 Replies)
i have installed CENTOS in VMware. I want the linux command to run in CENTOS.
The command is to select data's from Event table(our table name) convert into .xls and mail every 2hrs. Can you please help me in writing this script.
Thanks,
Shobana (1 Reply)
Discussion started by: shobana praveen
1 Replies
LEARN ABOUT DEBIAN
py_xls2html
py_xls2html(1) General Commands Manual py_xls2html(1)NAME
py_xls2html - convert an Excel xls file to a html formatted file
SYNOPSIS
py_xls2html input-file
DESCRIPTION
This manual page was written for the Debian distribution because the original program does not have a manual page.
py_xls2html takes an Excel xls file as an argument and converts it to a html formatted 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_xls2html 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_xls2csv(1)
October 12, 2006 py_xls2html(1)
06-22-2010
Converting .xls into .csv and find & Replace
