04-07-2008
I am sending the file as e-mail attachment. I can combine them together and send as .xls file or .csv that opens in Excel. But putting it together in different tab, is the point that I am getting stuck.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a text file like
----------------------
aaa|bbb|ccc|ddd|eee
fff|gggg|hhhhhh|kkkk
--------------------
I have a script which will transfer(thourgh FTP) this text file to windows system.
But I want to covert it into excel or CSF then upload into windows system..
thanks (9 Replies)
Discussion started by: srikanthus2002
9 Replies
2. UNIX for Advanced & Expert Users
I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner.
I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
2 Replies
3. Shell Programming and Scripting
Hi
I have a excel file in unix machine and have to convert it into a .csv file.I have to do this from a unix script.How do we do this?
Thanks
Abhinav (3 Replies)
Discussion started by: akashtcs
3 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
I have to convert the excel file which will be placed in the Unix box to a CSV file using a shell script.
Please Advise.
Thanks & Regards,
Kumar66 (1 Reply)
Discussion started by: kumar66
1 Replies
5. Shell Programming and Scripting
Hi all,
Please help me out
How to write a shell script which converts abc.csv file into abc.xls
example file abc.csv
AP_RQ_ID,TXN_IER,AP_RS_RESP_CD,TXN_CNT,TOTAL_AMT
60000002,ACTIVATION,00,490,14657.52
60000002,ACTIVATION,08,1,100
This needs to be converted into excel format using a... (3 Replies)
Discussion started by: dudd9
3 Replies
6. Shell Programming and Scripting
Hi,
I am trying to attach and email a csv file in the form of an excel sheet.
And I have been successful in doing this.
But after some days I realised that some fields in the csv file are also having commas because of which this field is getting splitted in columns in the excel sheet.
... (5 Replies)
Discussion started by: girish1428
5 Replies
7. Shell Programming and Scripting
Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given
Name Domain Contact Phone Email Location
----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
Discussion started by: sreenath1037
7 Replies
8. Shell Programming and Scripting
Hi,
I have to print a excel file in solaris server. I am using lexmark printer with post script printer driver . But the problem is when i am using " lp -d <printer name> <somefile name.xls>" command it is not printing correctly. but for pdf file using the same command it printing correctly.
... (2 Replies)
Discussion started by: Sambuddha
2 Replies
9. Shell Programming and Scripting
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... (8 Replies)
Discussion started by: landossa
8 Replies
10. 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
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)