Xls file generation

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Convert Excel File (xls) to tab delimited text file on AIX

Hi i have a problem in my job i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand cat xxx.xls > xxx.txt Do you have eny idea? PS: sorry for my english Thanks!!

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

3. Shell Programming and Scripting

Unzipping a file in Solaris - Issue with xls file

Hi, I have an excel file generated by system in windows. I am zipping it, transfering to unix and unzipping there. But i'm getting below output while unzipping. $ /usr/bin/unzip -a 123.zip -d . Archive: 123.zip inflating: ./123/Index.xls When i copy this unzipped xls file to...

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

How to Merge Two .xls files side by side into a single .xls

Hi all, please help me out in below requirement. I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side Ex: abc.xls bbc.xls Eno Ename Eno Ename 101 hello ...

7. Shell Programming and Scripting

How to Merge Two .xls files side by side into a single .xls

8. UNIX for Dummies Questions & Answers

renaming xls file

I am trying to move and rename an excel file by appending date to it but i am not getting the desired result mv SrcFiles/Sales.xls SrcFiles/SG_Archive/Sales_`date +%Y%m%d%H%M%S`.xls result:- Sales_Ym63HM desired result - Sales_200710171323.xls

9. Shell Programming and Scripting

From xls to csv file

Can we convert an xls file into csv format in Unix Thanks Suresh

10. Shell Programming and Scripting

copying the csv file into different worksheets of xls file

Hi, I have a script which will generate three csv files. i want to copy the contents of these csv files into a .XLS file but in different worksheets. Can a this be done in the same script? :confused: Can Perl come to my help in coping the csv files into different worksheets of .XLS file ?...

LEARN ABOUT DEBIAN

runxlrd

RUNXLRD(1)						      General Commands Manual							RUNXLRD(1)

NAME

       runxlrd - extract data from Microsoft Excel spreadsheet files

SYNOPSIS

       runxlrd [options] command [input-file-patterns]

DESCRIPTION

       This manual page documents briefly the runxlrd command.

       runxlrd offers a commandline interface to the Python xlrd module; it extracts data from Microsoft Excel spreadsheet files.

OPTIONS

       -h, --help
	      Show summary of options and exit.

       -l logfilename
	      Contains error messages.

       -v verbosity, --verbosity=verbosity
	      Level of information and diagnostics provided.

       -p pickleable, --pickleable=pickleable
	      1: ensure Book object is pickleable (default); 0: don't bother.

       -m mmap, --mmap=mmap
	      1: use mmap; 0: don't use mmap; -1: accept heuristic.

       -e encoding, --encoding=encoding
	      Encoding override.

       -f formatting, --formatting=formatting
	      0 (default): no fmt info 1: fmt info (all cells) 2: fmt info (margins trimmed).

       -g gc, --gc=gc
	      0: auto gc enabled; 1: auto gc disabled, manual collect after each file; 2: no gc.

       -s onesheet, --onesheet=onesheet
	      Restrict output to this sheet (name or index).

COMMANDS

       Valid commands are

       o dump

       o count_records

       o version

       o hdr

       o ov

       o show

       o 2rows

       o 3rows

       o bench

       o names

       o name_dump

       o labels

       o xfc

       o hotshot

       o profile

       See the xlrd API documentation for the meaning of these commands.

EXAMPLES

       To show the first, second and last rows of each sheet in each file, run
	      $ runxlrd 3rows *blah*.xls
       Run
	      $ runxlrd -e koi8_r 3rows myfile.xls
       to explicitly pass the needed codepage to xlrd, e.g. if the codepage record is missing, or if it exists but is wrong.

SEE ALSO

       The xlrd API documentation, shipped in the file xlrd.html.
       The xlrd website <http://www.lexicon.net/sjmachin/xlrd.htm>.

AUTHOR

       runxlrd was written by John Machin.

       This manual page was written by Joost van Baal <joostvb+debian@uvt.nl>, for the Debian project (but may be used by others).

xlrd 0.6.1a4							    2007-05-24								RUNXLRD(1)

Shell Programming and Scripting