03-20-2006
Quote:
Originally Posted by Pavankk
I have some text data generated by a perl script and want to put it into an excel sheet. Is there a perl script that can do this for me, i.e, convert text data to excel?
dunno about a perl script but you can output the file in a comma-delimited format, name the file anything with a ".csv" extension and open it up in excel ... all you need to do then is to fix the column/cell widths ... have fun!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi to all the tycoons of Shell programming!!
I am getting a csv report out of a query and the report is delimited with '|' symbol. I would like to convert this csv report into an xls column wise.. Let me show u an example as below
Say a.csv looks like below
Number|Description|Cycle|Date... (6 Replies)
Discussion started by: ganga.dharan
6 Replies
2. Shell Programming and Scripting
Hi Folks!!
I would like to convert each and every output of my query to the excel column wise. Let me give you an example
The first attachment (cr.jpg) is the one which i am getting out of a query and the fields are delimited with a '|' (pipe) symbol. I would like to convert each field into a... (4 Replies)
Discussion started by: ganga.dharan
4 Replies
3. Shell Programming and Scripting
i have this file which has the following contents:
,-0.3000 ,-0.3000 ,-0.3000
,-0.9000 ,-0.9000 ,-0.9000
i would like to get this:
-0.3-0.9-0.3-0.9-0.3-0.9
so far i am trying:
awk '{for(i=1; i<=NF; i++) {printf("%f\n",$i)}}' test1 > test2
any help... (4 Replies)
Discussion started by: npatwardhan
4 Replies
4. UNIX for Advanced & Expert Users
Hello All,
I have a sql report with 50 columns and 1000 rows result in a file ( txt / csv). is there is any way that we can move them to excel in KSH.
Thanks,
Sateesh (7 Replies)
Discussion started by: kotasateesh
7 Replies
5. Shell Programming and Scripting
Hi all,
I need to find a way to convert excel file into csv or a text file in linux command. The reason is I have hundreds of files to convert. Another complication is the I need to delete the first 5 lines of the excel file before conversion.
so for instance
input.xls
description of... (6 Replies)
Discussion started by: johnkim0806
6 Replies
6. Shell Programming and Scripting
Dear Users , Need to convert delimited text files in UNix server to an Excel file and move the excel file to Windows environment. Am trying to automate the whole process. Can anyone share the ideas,if they have done similar ones before...Thanks -Meera (1 Reply)
Discussion started by: meerakrish
1 Replies
7. Shell Programming and Scripting
:cool:Hi, Iam new to this Scripts and forum too. Plz excuse if may i ask silly questions now and further..
Prob: i need to convert txt files data into excel sheet. Suppose if i have hour-wise data in txt file1 and file2 like
file1 file2
00: 140 00: 235
01: 160 01:415... (1 Reply)
Discussion started by: mrudula
1 Replies
8. Shell Programming and Scripting
Hi Everyone,
I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet.
Example input:
IpAdress:InstanceName:Port:ServerName
10.255.255.1:abc:2232:xyz_abc
Output should be an excel sheet like below:
Column... (8 Replies)
Discussion started by: akabhinav18
8 Replies
9. UNIX for Beginners Questions & Answers
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!! (4 Replies)
Discussion started by: frisso
4 Replies
10. Shell Programming and Scripting
Hello,
I have an excel sheet (.xlsx), with 11 worksheets. I need to run my bash scripts on the 1st worksheet and write the output to the 2nd worksheet.
I am currently manually converting the worksheet into a tab delimited to run the script and then pasting it back to excel.
Is there a way to do... (2 Replies)
Discussion started by: nans
2 Replies
LEARN ABOUT DEBIAN
build-lives-rfx-plugin
build-lives-rfx-plugin(1) General Commands Manual build-lives-rfx-plugin(1)
NAME
build-lives-rfx-plugin - builds rendered effects for LiVES
SYNOPSIS
build-lives-rfx-plugin script_name [plugin_dir] -get section file
DESCRIPTION
This perl script is used by LiVES to compile an RFX (rendered effect) plugin for LiVES. It is generally called from build-lives-rfx-plugin-
multi for a script which has a language code representing LiVES-perl. The script_name must be the full (absolute) path to the plugin
script, and plugin_dir can be used to specify the output directory where the compiled plugin should be generated. If plugin_dir is not
defined then /tmp is assumed.
The second variant with -get is used to print out a script section from a plugin script to stdout. It is generally only used internally by
LiVES.
Return values The script returns the following values
0 - success 1 - the value of a trigger was greater than the number of parameters 2 - a value could not be read from the script file 3 - the
language code of the plugin script was not equivalent to LiVES-perl 4 - the API version level of the plugin script was invalid 5 - the
<define> section was missing from the plugin script
SEE ALSO
build-lives-rfx-plugin-multi(1), lives(1)
AUTHOR
Gabriel Finch a.k.a Salsaman (salsaman@xs4all.nl)
May 9 2010 build-lives-rfx-plugin(1)