Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Merging the content of 2 cells in XLS using UNIX command Post 302866737 by RudiC on Tuesday 22nd of October 2013 03:50:00 PM
Old 10-22-2013
Samples?
XLS in *nix impossible, except for perl-module.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

UNIX files to XLS

People, I am wondering if there is a Software(Filter) that can convert my UNix text file (delimeted text file) to Excel, for my business users to launch and see. Thanx Zia (4 Replies)
Discussion started by: rahzia
4 Replies

2. UNIX for Dummies Questions & Answers

WINDOWS to UNIX : xls to csv

Hi, I need to ftp a .xls file from WINDOWS to UNIX. When I do it, the file coversion doesn't happen(??) or UNIX doesn't recognixe this format I know not. But there will be junk values in the ftp'd file. Note: The ftp will be done by a script and I don't think we could place a WINDOWS script on... (5 Replies)
Discussion started by: preethgideon
5 Replies

3. Shell Programming and Scripting

UNIX -> send data as excel in seperate cells

Hi I have a data file in UNIX as follows. I need to send this file in Mail as excel format. but the problem i face is i get the data all in single cells per row. what can i do to get the data in seperate cells. File -> attachment.xls data data data data data1 data1 ... (1 Reply)
Discussion started by: vj8436
1 Replies

4. Shell Programming and Scripting

Merge two cells in excel via UNIX?

Hi UNIX Gods! Is it possible to merge two cells in .csv file using unix commands? Imagine that this is my present csv file opened via excel: Gate Reports| | fatal alerts | 200 | is is possible to make it look like this using unix? Gate Reports | fatal... (1 Reply)
Discussion started by: 4dirk1
1 Replies

5. Shell Programming and Scripting

Removing worksheets from xls using unix.

HI All, I have a .xls file , in which I have multiple worksheets , I need to remove all the worksheets except the worksheet by name CDR_LOAD_STATS, how can I do this in unix. Please guide me. Regards, Deepti (7 Replies)
Discussion started by: gaur.deepti
7 Replies

6. Shell Programming and Scripting

Expand cells in .xls file created in unix

Hi Guys, I am creating a comma separated file by quering the table and routing it to a file with an extension .xls. I am using the mailx command to send the .xls file to windows mail box. The file is coming as a excel attachment, but the cells are not expanded. Is there a way by which... (4 Replies)
Discussion started by: mac4rfree
4 Replies

7. Shell Programming and Scripting

Content merging at a specific location in a file

Hi, This is a bit lengthy problem, i will try to keep explaining it simple. I have got a file say file1 that contains the following in it, ------------------------------------------------------------------------ r201463 | ngupta@gmail.com | 2012-06-19 22:02:20 +0530 (Tue, 19 Jun 2012) |... (3 Replies)
Discussion started by: Kashyap
3 Replies

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

9. UNIX for Advanced & Expert Users

Converting xls file to xlsx on UNIX script / command line.

Hi All, Am needing advise on how to convert xls file to xlsx format on Solaris unix command line or scripting. I tried searching online but it looks like I need to either use Perl packages of Excel or Python packages or some other 3rd party tool. Problem is to install any of these will require... (2 Replies)
Discussion started by: arvindshukla81
2 Replies

10. Shell Programming and Scripting

Split a content in a file with specific interval base on the delimited values using UNIX command

Hi All, we have a requirement to split a content in a text file every 5 rows and write in a new file . conditions: if 5th line falls between center of the statement . it should look upto after ";" files are below format: 1 UPDATE TABLE TEST1 SET VALUE ='AFDASDFAS' 2 WHERE... (3 Replies)
Discussion started by: KK230689
3 Replies
pods::SDL::Mixer::Samples(3pm)				User Contributed Perl Documentation			    pods::SDL::Mixer::Samples(3pm)

NAME
SDL::Mixer::Samples - functions for loading sound samples CATEGORY
Mixer METHODS
get_num_chunk_decoders my $num_decoders = SDL::Mixer::Samples::get_num_chunk_decoders(); Returns the number of available decoders. get_chunk_decoder my $decoder = SDL::Mixer::Samples::get_chunk_decoder( $num_decoder ); Returns the decoder for the given id. load_WAV my $mix_chunk = SDL::Mixer::Samples::load_WAV( $file ); "load_WAV" reads a file and passes it to SDL::Mixer::Samples::load_WAV_RW. SO this is a quick way to load a file into a chunk. Example: my $chunk = SDL::Mixer::Samples::load_WAV('sample.wav'); SDL::Mixer::Channels::play_channel(-1, $chunk, -1); SDL::delay(2000); load_WAV_RW my $mix_chunk = SDL::Mixer::Samples::load_WAV_RW( $rwops, $free ); "load_WAV_RW" is a macro that loads a sound sample from a a block of memory. It supports WAVE-, MOD-, MIDI-, OGG- and MP3 files (sometimes depends on compilation options). It accepts two arguments, the first being a RWops object from which to read and the second being a flag to free the source memory after loading is complete or not. Returns a Mix_Chunk containing the whole sample on success, or "undef" on error. Note: Do not reuse the RWops-object for another call to this function! Example: my $rwops = SDL::RWOps->new_file('sample.wav', 'r'); my $chunk = SDL::Mixer::Samples::load_WAV_RW($rwops, 0); SDL::Mixer::Channels::play_channel(-1, $chunk, -1); SDL::delay(2000); quick_load_WAV SDL::Mixer::Samples::quick_load_WAV( $buf ); to be documented. quick_load_RAW SDL::Mixer::Samples::quick_load_RAW( $buf, $len ); to be documented. volume_chunk my $volume_before = SDL::Mixer::Samples::volume_chunk( $chunk, $new_volume ); "volume_chunk" let you set and get the volume of a chunk. When a chunk is created is volume is "MIX_MAX_VOLUME" (128). If you pass "-1" as $new_volume you just get its volume without changing it. AUTHORS
See "AUTHORS" in SDL. perl v5.14.2 2012-05-28 pods::SDL::Mixer::Samples(3pm)
All times are GMT -4. The time now is 03:59 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy