02-29-2012
Hi chihung,
Thanks for your reply. However it looks like you are reading from a CSV file.
What I am trying to achieve is open a Microsoft Excel file and export one of the tabs of the MS Excel file to a CSV file.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi!
I'm using SunOS 5.7 w/ Bash 2.01.
Currently, I'm working on a script that will make it possible to find textfiles which match certain criteria. While I write this message, I had some brainfarts, found the answer myself :D and the question I had in mind is now no longer the question I... (3 Replies)
Discussion started by: indo1144
3 Replies
2. UNIX for Advanced & Expert Users
I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner.
I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
2 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I was wondering if anybody could help me with this. I have two .csv file that I need to put it in an excel file in two different tabs using Shell Script.
Thanks in advance.
JP (7 Replies)
Discussion started by: JPalt
7 Replies
4. Shell Programming and Scripting
Hi,
i would convert the following XML file :
<?xml version="1.0" encoding="UTF-8" ?>
<files xmlns="http://www.lotus.com/dxl/console">
<filedata notesversion="6" odsversion="43" logged="yes" backup="no" id="C12577E6:004B0DA3" iid="C12577E6:004B0DA8" link="1" dboptions="0,524288,0,0">
... (24 Replies)
Discussion started by: Nicol
24 Replies
5. Shell Programming and Scripting
Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given
Name Domain Contact Phone Email Location
----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
Discussion started by: sreenath1037
7 Replies
6. Shell Programming and Scripting
Dear Members,
I am using the attached script to convert a input file delimited by '|' to excel.
However, while processing the attribute change_reason, the whole content of the text under change_reason is not displayed completely in the cell in excel. It is truncated after only first few words.... (1 Reply)
Discussion started by: Yoodit
1 Replies
7. Shell Programming and Scripting
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)
Discussion started by: joshiamit
5 Replies
8. Shell Programming and Scripting
Hi I have a dat file which has "n" number of columns. The file is delimited. The number of columns keep varying as the file is generated out of DB queries. Could you please help me in writing a script which will generate a XLS or CSV file out of the dat file. (5 Replies)
Discussion started by: Vee
5 Replies
9. Shell Programming and Scripting
I am using xls2csv to convert a xls file into a regular .csv file. However, while using the command as
xls2csv fromfile.xls > tofile.csv
I am getting the following error.
fromfile.xls is not OLE file or Error
I also tried to specify the comma as delimiter but did not help...
xls2csv -c\,... (7 Replies)
Discussion started by: dhruuv369
7 Replies
10. Shell Programming and Scripting
Hi,
Anyone can help I am just converting the excel file to csv using python, I can get the conversion output but the date not display exactly.
test.xlsx date format
167 1588 risks/SCS JP CAMPANA & CIE.pdf SCS JP CAMPANA & CIE 2 1 1 0 2015-03-16 16:56:25
167 1146 risks/AirBNB... (1 Reply)
Discussion started by: fspalero
1 Replies
LEARN ABOUT DEBIAN
dh_pycentral
DH_PYCENTRAL(1) Debhelper DH_PYCENTRAL(1)
NAME
dh_pycentral - use the python-central framework to handle Python modules and extensions
SYNOPSIS
dh_pycentral [debhelper options] [-n] [-Xitem] [-V version] [module dirs ...]
DESCRIPTION
dh_pycentral is a debhelper program that will scan your package, detect public Python modules and move them in /usr/share/pycentral so that
python-central can byte-compile those for all supported Python versions. Extensions are kept into the original installation location.
Moving the files to the pycentral location and adding symbolic links to /usr/lib/pythonX.Y/*-packages can be done by setting the
environment varibale DH_PYCENTRAL to a string containing the string include-links.
Moving the files to the pycentral location can be disabled by setting the environment varibale DH_PYCENTRAL to a string containing the
string nomove.
The functionality to shorten the time of unavailabilty of files during unpack and configure has been removed (symlinking files in the
preinst and not removing the symlinked files on upgrade) in version 0.6.9.
You must have filled the XS-Python-Version header to indicate the set of python versions that are going to be supported. dh_pycentral
expects the XB-Python-Version for each binary package it is supposed to work on.
dh_pycentral will also generate substitution variables: the ${python:Provides} variable will contain versioned provides of the package (if
the package's name starts with "python-"). A python-foo package could provide "python2.3-foo" and "python2.4-foo" at the same time. Python
extensions have to provide those whereas it's only option for pure python modules.
The ${python:Versions} variable should be used to provide the required XB-Python-Version field listing the python versions supported by the
package.
OPTIONS
module dirs
If your package installs python modules in non-standard directories, you can make dh_pycentral check those directories by passing their
names on the command line. By default, it will check /usr/lib/$PACKAGE, /usr/share/$PACKAGE, /usr/lib/games/$PACKAGE,
/usr/share/games/$PACKAGE, /usr/lib/python?.?/site-packages and /usr/lib/python?.?/dist-packages.
Note: only /usr/lib/python?.?/site-packages and the extra names on the command line are searched for binary (.so) modules.
-V version
If the .py files your package ships are meant to be used by a specific pythonX.Y version, you can use this option to specify the
desired version, such as 2.3. Do not use if you ship modules in /usr/lib/site-python.
With the new policy, this option is mostly deprecated. Use the XS-Python-Field to indicate that you're using a specific python version.
-n, --noscripts
Do not modify postinst/postrm scripts.
-Xitem, --exclude=item
Exclude files that contain "item" anywhere in their filename from being taken into account to generate the python dependency. You may
use this option multiple times to build up a list of things to exclude.
CONFORMS TO
Python policy, version 0.4.1 (2006-06-20)
SEE ALSO
debhelper(7)
This program is a part of python-central but is made to work with debhelper.
AUTHORS
Raphael Hertzog <hertzog@debian.org>
Also includes bits of the old dh_python written by Josselin Mouette <joss@debian.org> who used many ideas from Brendan O'Dea
<bod@debian.org>.
2011-04-14 DH_PYCENTRAL(1)