Sponsored Content
Top Forums Shell Programming and Scripting Converting huge xls(having multiple tabs) to csv Post 302588899 by mirni on Tuesday 10th of January 2012 07:22:16 AM
Old 01-10-2012
That's too bad. Making sense of the MS Office format is not a trivial task...
Have you looked at this?
XLS to CSV [Archive] - FedoraForum.org

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:
Code:
cat >  ~/.catdocrc <<EOF
charset_path=${HOME}/mystuff/catdoc-0.94.2/build/usr/local/share/catdoc
map_path=${HOME}/mystuff/catdoc-0.94.2/build/usr/local/share/catdoc
source_charset=cp1252
target_charset=8859-1
unknown_char='?'
EOF

And you should be good to go:
Code:
~/mystuff/catdoc-0.94.2/build/usr/local/bin/xls2csv myfile.xls

This User Gave Thanks to mirni For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting tabs in to spaces.

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. Shell Programming and Scripting

Converting csv to xls

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)
Discussion started by: miltony
1 Replies

3. Shell Programming and Scripting

converting xls file to txt file and xls to csv

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

4. UNIX for Advanced & Expert Users

Converting .csv file into .xls file and send it to inbox

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. Shell Programming and Scripting

Converting .xls into .csv and find & Replace

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)
Discussion started by: velava
4 Replies

6. Shell Programming and Scripting

Converting specific Excel file tabs to CSV in Python

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)
Discussion started by: landossa
8 Replies

7. Shell Programming and Scripting

Script for converting to xls and to mail the same

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

8. UNIX for Advanced & Expert Users

Shell script for dealing with XLS file with multiple tabs/worksheets

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

9. Emergency UNIX and Linux Support

Dealing with XLS file with multiple tabs

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)
Discussion started by: himanshu sood
6 Replies

10. Shell Programming and Scripting

Merging Multiple XLS into Different tabs in xls/ xlsx

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
APT-BUILD(1)						      General Commands Manual						      APT-BUILD(1)

NAME
apt-build - Fetch sources and build packages optimized for your architecture. SYNOPSIS
apt-build [ options ] [ update ] [ upgrade ] [ world ] [ install pkg ] [ remove pkg ] [ info pkg ] DESCRIPTION
apt-build is an apt-get frontend to build and install architecture optimized packages. COMMANDS
update Retrieve new lists of packages upgrade Perform an upgrade world Rebuild your system install Build and install new packages source Download and extract source in the build directory info Info on a package which could be built remove Remove packages clean-build Erase built packages clean-sources Call debian/rules clean in source directories build-source Build source without installing them update-source Update sources and rebuild them if they are missing in the repository build-repository Rebuild the repository OPTIONS
--help Shows help --nowrapper Do not use the gcc wrapper --remove-builddep Remove build-dependencies installed by apt-build --no-source Don't download source --build-dir Specify build-dir --build-only Build package only --rebuild Rebuild a package --reinstall Build and install an already installed package --build-command <command> Use this command to build package --patch <file> Apply this patch before build (you can use this option one or several times) --patch-strip, -p <number> Prefix to strip on patch (0 = -p0, 1 = -p1 ...) --yes, -y Assume yes --purge Use purge instead of remove --noupdate Do not run 'apt-get update' before package installation --sources-list Specify sources.list file --apt-get Specify an alternative apt-get command --apt-cache Specify an alternative apt-cache command --force-yes Force yes --source Do not download source (sources are extracted already) --repository-dir Specify the repository directory --target-release Distribution to fetch packages from --config Specify an alternative configuration file --version, -v Show version BUGS
Many. AUTHOR
apt-build was written by Julien Danjou <acid@debian.org> with many contributors. 3rd Berkeley Distribution November 2003 APT-BUILD(1)
All times are GMT -4. The time now is 03:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy