Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Dealing with XLS file with multiple tabs
Homework and Emergencies Emergency UNIX and Linux Support Dealing with XLS file with multiple tabs Post 302898283 by mjf on Monday 21st of April 2014 06:37:21 AM
Old 04-21-2014
himanshu,
One solution would be to write a VBA/macro in Excel or Open Office itself to perform the actions in your requirement. XLS files are binary, not text, files so writing scripts to read and process XLS files will not work unless you first convert them to text/csv files (or you use API's such as in Open Office or ActiveX - Windows to interact with them).
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to delete multiple space or tabs from a read only file

Hi, Actually I am want to cut the three fields of "file-nr" file. $ cat /proc/sys/fs/file-nr 638 219 52270 I want to assign these value to diffrent varibales as follow:- a=638 b=219 c=52270 I tried to use cut command for this purpose and also tried to squeeze all sapces... (6 Replies)
Discussion started by: bisla.yogender
6 Replies

2. 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

3. Shell Programming and Scripting

Converting huge xls(having multiple tabs) to csv

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

4. Shell Programming and Scripting

dealing with dates in a text file

hi guys im trying to write a bash script that grabs expired domain names it leaves me with the following outpiut in a text file Im hoping to try to normalise all the dates to the format displayed in the first 2 lines and remove the times so the file looks unfirom can any one give me a... (9 Replies)
Discussion started by: dunryc
9 Replies

5. Shell Programming and Scripting

Dealing with multiple files

Korn Shell I have hundreds of small files like below created every day. A midnight cron job moves them to the location /u04/temp/logs But sometimes I have to manually move these files based a certain dates or time. I have two basic requirements 1.Using mv command I want to move all .dat... (2 Replies)
Discussion started by: kraljic
2 Replies

6. UNIX and Linux Applications

Firefox Warning message for closing with multiple tabs not working

Can anyone explain why firefox warning message for closing with multiple tabs not working. The checkbox for warning when you have multiple tabs is checked so I don't understand why its not working. (0 Replies)
Discussion started by: cokedude
0 Replies

7. 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

8. Shell Programming and Scripting

Script to launch a KDE Konsole window with multiple tabs

Gents, I found this script to to launch a KDE Konsole window with multiple tabs.. #!/bin/bash # # Create my standard konsole windows. if ]; then profile=Shell fi sessions=( sh1 $profile 'clear; bash' sh1 $profile 'clear; bash' su1 $profile 'clear; su'... (1 Reply)
Discussion started by: jiam912
1 Replies

9. 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

10. UNIX for Beginners Questions & Answers

How to check string contain multiple tabs or spaces?

str contains tabs and multiple spaces str="hello world. How are you?" I want to check string start with hello world, and my code is: if ]world"* ]]; then echo "found" else echo "not found" fi Not work Other solution may work is to replace all tabs and... (4 Replies)
Discussion started by: cmdcmd
4 Replies

LEARN ABOUT DEBIAN

gbgoffice

GBGOFFICE(1)						      General Commands Manual						      GBGOFFICE(1)

NAME

       gbgoffice - GTK BG Office assistant

SYNOPSIS

       gbgoffice [OPTIONS]...

DESCRIPTION

       gbgoffice - GTK BG Office assistant

OPTIONS

       -d, --dump-data-dir
	      Dumps direcotry where shared files are instaled.

       -l, --language=[bg/en]
	      Sets language to Bulgarian or English.

       -h, --help
	      Display help message.

       -v, --version
	      Display the version of the program.

FILES

       ~/.gbgoffice
	      Per user configuration file.

ENVIRONMENT

       LANG   Specify language which will be used (Bulgarian or English)

BUGS

       Trayicon may not work with all window managers.

LICENSE

       This   program	is distributed under the terms of the GNU General Public License as published by the Free Software Foundation. See COPYING
       or COPYING.BULGARIAN for details.

SEE ALSO

       kbgoffice(1), cbgoffice(1)

       official webpage - http://gbgoffice.info

AUTHORS

       Miroslav Yordanov <mironcho at linux-bg dot org>

								   February 2005						      GBGOFFICE(1)
All times are GMT -4. The time now is 11:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy