It describes how to create a macro, to save all tabs as csv.
---------- Post updated at 02:22 AM ---------- Previous update was at 01:51 AM ----------
Quote:
Originally Posted by joshiamit
Thanks for this useful post but I have very limited privilege to access tools that's the main reason I am looking for any unix script base solution if possible
How much privilege do you have? If you have a directory with write access and basic build tools (automake), you can download the source tarball, install the catdoc to the local dir, and use it.
e.g.:
I have +wx access to ~/mystuff. Then:
Code:
wget http://fossies.org/unix/misc/old/catdoc-0.94.2.tar.gz
tar xvzf catdoc-0.94.2.tar.gz
cd catdoc-0.94.2
mkdir build && ./configure --disable-wordview --with-install-root=${PWD}/build
make && make install
Then create a file ~/.catdocrc and put some config paths in there:
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)
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)
Hi All,
Please give me the solution to the following ASAP.
1) Converting the .xls into .csv
Script i tried,
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... (4 Replies)
Hi list,
This is probably something really simple, but I am not particularly familiar with Python so I thought I would ask as I know that python has an excel module.
I have an excel document with multiple tabs of data and graphs.
One of the tabs is just data which I require to have dumped to... (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)
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)
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... (6 Replies)
HI,
I have multiple files per dept in folder
for eg : In a folder
File1_Dept100.xls
File2_Dept100.xls
File3_Dept100.xls
File1_Dept200.xls
File2_Dept200.xls
File3_Dept200.xls
Output should be :
Dept100.xls which has File1, File2, File3 in different tabs
Dept200.xls which has... (1 Reply)
Discussion started by: venkyzrocks
1 Replies
LEARN ABOUT DEBIAN
pg_buildext
PG_BUILDEXT(1) Debian PostgreSQL infrastructure PG_BUILDEXT(1)NAME
pg_buildext - Build and install a PostgreSQL extension
SYNOPSIS
pg_buildext action srcdir target opts
DESCRIPTION
pg_buildext is a script that will build a PostgreSQL extension in a VPATH way. It supports the configure, build, install, and clean
actions, and will choose to build for the intersection of versions known in debian/pgversions (versions supported by the package) and in
/usr/share/postgresql-common/supported-versions (versions supported in this release).
OPTIONS
action
One of configure, build, install, or clean.
srcdir
Where to find the extension sources, including the debian subdirectory. (Usually $(CURDIR).) If not specified, defaults to the current
directory.
target
The target directory where to build the sources, it will get created for you if it does not exist. If the target contains a %v sign, it
will get replaced by the specific version of PostgreSQL being built against. (Usually build-%v.)
opts
%v signs in opts will get replaced as in target.
configure
Options to pass to the configure script. (Most PostgreSQL extensions do not have a configure script.)
build
Custom CFLAGS options to use for the build.
install
Package name to install for. Make will be called with DESTDIR="srcdir/debian/package".
clean
clean does not take extra options.
USAGE
As pg_buildext invokes make for the build, install, and clean actions, invocations from debian/rules (which is a makefile) should be
prefixed with + so the sub-makes can talk with the make jobserver.
EXAMPLE
build-stamp:
+pg_buildext configure $(CURDIR) build-%v "--libdir=/usr/lib/postgresql/%v/lib --datadir=/usr/share/postgresql-%v-plsh"
+pg_buildext build $(CURDIR) build-%v
install: build
+pg_buildext install $(CURDIR) build-%v postgresql-%v-plsh
clean:
+pg_buildext clean $(CURDIR) build-%v
AUTHOR
Dimitri Fontaine <dim@tapoueh.org>, with extensions by Christoph Berg <myon@debian.org>.
Debian 2012-10-08 PG_BUILDEXT(1)