Converting huge xls(having multiple tabs) to csv Post: 302588887

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

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.

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

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

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

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

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

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

9. Emergency UNIX and Linux Support

Dealing with XLS file with multiple tabs

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

LEARN ABOUT DEBIAN

gsf

GSF(1)								       GNOME								    GSF(1)

NAME

       gsf - archiving utility using the G Structured File library

SYNOPSIS

       gsf [OPTION...] SUBCOMMAND ARCHIVE...

DESCRIPTION

       This manual page briefly documents the gsf command.

       gsf  is	a simple archive utility, somewhat similar to tar(1). It operates on files following one of the structured file formats understood
       by the G Structured File library, for example, Microsoft Excel(TM) files.

OPTIONS

   Options
       -?, --help
	      Show help options

       -v, --version
	      Display gsf's version

   Subcommands
       cat    Output one or more files in archive

       dump   Dump one or more files in archive as formatted hexadecimal

       help   List subcommands

       list   List files in archive

       props  Archive list of property names

EXAMPLES

       To list the content structure of a Microsoft Excel(TM) file arrays.xls:

       gsf list arrays.xls

       To dump Workbook, an individual data stream in arrays.xls:

       gsf dump arrays.xls Workbook

AUTHORS

       gsf's primary authors are Morten Welinder <terra@gnome.org> and Jody Goldberg <jody@gnome.org>.

       The initial version of this manpage was written by J.H.M. Dassen (Ray) <jdassen@debian.org>.

SEE ALSO

       gnumeric(1)

       The Gnumeric homepage <http://www.gnome.org/projects/gnumeric/>

       The GNOME project page <http://www.gnome.org/>

gsf								 29 November 2009							    GSF(1)