Hi,
I am running a script, the output of which is needed to be filled in .xls file. I am doing this manually now, i mean I am writing the output of the script to Excel file manually. How to redirect the output of the script to .xls file? Please help me out!!!
Thanks much,
Scriptlearner. (6 Replies)
Hi
I have spool file which is pipe delimated and i want to convert it into xls .
Is any tool or method availabe in UNIX for this kind of conversion (2 Replies)
Hi All,
This is my first mail to the group.I would like to generate an attachment in xls format which contains accented characters that are supported by UTF-8 format. However, I am not able to get them as i wished. Can anyone help me in this regard.I would like to know the mail format for... (0 Replies)
Hi,
I have a file coming in xxx.txt(csv format) i do some work on it and i need to send out as a .xls format. Is there any way there is some code i can use in my script to convert this?
I'm struggling on this.
Thanks (11 Replies)
Hi,
How to extract the data from Oracle database and sent the output data to mails using mailx command with .xls attachement?
Here i know how to connect the database using unix shell script and
how to use the mailx command in UNIX script
But i don't know how to use the .xls format file (i... (1 Reply)
Hi,
I am using the sybase database server though unix platform and try to retrieve some data by the help of select statement, and my main issue is i want to redirect all the the data i.e. retrieve from the select statement to a .xls file with the same column name and the outputs. How can i do... (5 Replies)
Hi All,
Can any one help me to get the shell/perl scripts for the below requirements.
1: To get the clearcase checkin's information between two lables
generate a formatted Xls output
and to find the added changed and removed files and versions between
the ClearCase baselines.
2... (2 Replies)
Hi Folks,
I have written a perl script that reads data from excel sheet(.xls) using Spreadsheet::ParseExcel module. But the problem is this module doesn't work for excel sheets with extension .xlsx.
I have gone through Spreadsheet::XLSX module with which we can read from .xlsx file directly.... (1 Reply)
Dear Friends,
I am in urgent need for awk/sed/sh script for converting a specific data format (.txt) to .xls.
The input is as follows:
>gi|1234|ref|
Query = 1 - 65, Target = 1677 - 1733
Score = 8.38, E = 0.6529, P = 0.0001513, GC = 46
fd sdfsdfsdfsdf
fsdfdsfdfdfdfdfdf... (6 Replies)
Discussion started by: Amit1
6 Replies
LEARN ABOUT DEBIAN
chartex
CHARTEX(1p) User Contributed Perl Documentation CHARTEX(1p)NAME
chartex - A utility to extract charts from an Excel file for insertion into a Spreadsheet::WriteExcel file.
DESCRIPTION
This program is used for extracting one or more charts from an Excel file in binary format. The charts can then be included in a
"Spreadsheet::WriteExcel" file.
See the "add_chart_ext()" section of the Spreadsheet::WriteExcel documentation for more details.
SYNOPSIS
chartex [--chartname --help --man] file.xls
Options:
--chartname -c The root name for the extracted charts,
defaults to "chart".
OPTIONS --chartname or -c
This sets the root name for the extracted charts, defaults to "chart". For example:
$ chartex file.xls
Extracting "Chart1" to chart01.bin
$ chartex -c mychart file.xls
Extracting "Chart1" to mychart01.bin
--help or -h
Print a brief help message and exits.
--man or -m
Prints the manual page and exits.
AUTHOR
John McNamara jmcnamara@cpan.org
VERSION
Version 0.02.
COPYRIGHT
X MMV, John McNamara.
All Rights Reserved. This program is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.
perl v5.10.1 2009-11-29 CHARTEX(1p)