09-05-2007
If you want to export a 'real' excel file, I think the better way is use perl script.
and remenber include the Spreadsheet:WriteExcel mod.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Please someone I need information on how to change a Unix form/document into a microsoft word document in order to be emailed to another company. Please help ASAP. Thankyou :confused: (8 Replies)
Discussion started by: Cheraunm
8 Replies
2. Shell Programming and Scripting
I'm looking for a sample of some code that will take the output from a file and generate an email that will include that text as an attachment. the script is in the borne shell. any help? (2 Replies)
Discussion started by: davels
2 Replies
3. Shell Programming and Scripting
Hello All,
This is a common question that I found lot of results in the forums.
I am trying to use uuencode to attach a file and send email. I have no issues sending email, but not able to attach any files using sendmail.
Is uuencode part of sendmail or does 'uuencode' utility need to be... (1 Reply)
Discussion started by: chiru_h
1 Replies
4. AIX
I am using the following command to send PDF attachment with a mail.
uuencode <attachment.pdf> <attachment.pdf>|mailx -s <subject> <mail_id> < <Message_file.txt>
This one send the message with attachment. I would like send PDF attachment with the mail
Can any one help with this issue ?
... (0 Replies)
Discussion started by: sunjup
0 Replies
5. Shell Programming and Scripting
i know its pretty repeated query, but i need to post it in this new thread coz i need it urgently
uuencode /var/tmp/chandra/emaillist.txt emaillist.txt | mail -s "message with encoded attachment"
am unable to send the attachment emaillist.txt present in the path /var/tmp/chandra/
Is... (11 Replies)
Discussion started by: cmaroju
11 Replies
6. UNIX for Dummies Questions & Answers
Hi,
Could anyone help me to find soultion for the issue to send email attachment as read only.
I can change the file permission in Linux and can send the email attachment from Linux. But my requirment is user can read the attachment but should not modified it . even user save the attachment... (4 Replies)
Discussion started by: calagar
4 Replies
7. UNIX for Advanced & Expert Users
hi..
Could somebody help me how to sent an attachment using sendmail command and the content is HTML format ?.
Below is my code to sent the email as HTML but i do not know how to sent the attachment, please help me
To: "BAHARIN HASAN"<baharin.hasan@gmail.com>
from: "DATAONE SDN... (4 Replies)
Discussion started by: bh_hensem
4 Replies
8. Shell Programming and Scripting
Hi All,
I want to send a file as an attachment through cron job.Is this possible using cronjob nd if it i, can you please let me know how to do this?
Thanks (2 Replies)
Discussion started by: NARESH1302
2 Replies
9. Shell Programming and Scripting
Hi All,
The below code is working fine for me.
mailx -s hello abc@xyz.com <<EOT
Hello !!!
How are you?
Regards
Rahul
EOT
But i am not able to send csv file with the mail .Getting just themail but not the attachment.
uuencode /path/s1.csv | mailx -s hello abc@xyz.com <<EOT... (9 Replies)
Discussion started by: rafa_fed2
9 Replies
10. UNIX for Dummies Questions & Answers
Good Day
Kindly assist:
I am creating an Alert that will notify supervisors of staff members who are due for probation report. I am using Operating System Script(Unix) as source.I have already developed the script.
Now the challenge is if there are 3 employee records then the alert... (2 Replies)
Discussion started by: nosi27
2 Replies
LEARN ABOUT DEBIAN
spreadsheet::xlsx
Spreadsheet::XLSX(3pm) User Contributed Perl Documentation Spreadsheet::XLSX(3pm)
NAME
Spreadsheet::XLSX - Perl extension for reading MS Excel 2007 files;
SYNOPSIS
use Text::Iconv;
my $converter = Text::Iconv -> new ("utf-8", "windows-1251");
# Text::Iconv is not really required.
# This can be any object with the convert method. Or nothing.
use Spreadsheet::XLSX;
my $excel = Spreadsheet::XLSX -> new ('test.xlsx', $converter);
foreach my $sheet (@{$excel -> {Worksheet}}) {
printf("Sheet: %s
", $sheet->{Name});
$sheet -> {MaxRow} ||= $sheet -> {MinRow};
foreach my $row ($sheet -> {MinRow} .. $sheet -> {MaxRow}) {
$sheet -> {MaxCol} ||= $sheet -> {MinCol};
foreach my $col ($sheet -> {MinCol} .. $sheet -> {MaxCol}) {
my $cell = $sheet -> {Cells} [$row] [$col];
if ($cell) {
printf("( %s , %s ) => %s
", $row, $col, $cell -> {Val});
}
}
}
}
DESCRIPTION
This module is a (quick and dirty) emulation of Spreadsheet::ParseExcel for Excel 2007 (.xlsx) file format. It supports styles and many of
Excel's quirks, but not all. It populates the classes from Spreadsheet::ParseExcel for interoperability; including Workbook, Worksheet,
and Cell.
SEE ALSO
Text::CSV_XS, Text::CSV_PP
http://search.cpan.org/~hmbrand/
A pure perl version is available on http://search.cpan.org/~makamaka/
Spreadsheet::ParseExcel
http://search.cpan.org/~kwitknr/
Spreadsheet::ReadSXC
http://search.cpan.org/~terhechte/
Spreadsheet::BasicRead
http://search.cpan.org/~gng/ for xlscat likewise functionality (Excel only)
Spreadsheet::ConvertAA
http://search.cpan.org/~nkh/ for an alternative set of cell2cr () / cr2cell () pair
Spreadsheet::Perl
http://search.cpan.org/~nkh/ offers a Pure Perl implementation of a spreadsheet engine. Users that want this format to be supported in
Spreadsheet::Read are hereby motivated to offer patches. It's not high on my todo-list.
xls2csv
http://search.cpan.org/~ken/ offers an alternative for my "xlscat -c", in the xls2csv tool, but this tool focusses on character encoding
transparency, and requires some other modules.
Spreadsheet::Read
http://search.cpan.org/~hmbrand/ read the data from a spreadsheet (interface module)
AUTHOR
Dmitry Ovsyanko, <do@eludia.ru<gt>, http://eludia.ru/wiki/
Patches by:
Steve Simms
Joerg Meltzer
Loreyna Yeung
Rob Polocz
Gregor Herrmann
H.Merijn Brand
endacoe
Pat Mariani
Sergey Pushkin
ACKNOWLEDGEMENTS
Thanks to TrackVia Inc. (http://www.trackvia.com) for paying for Rob Polocz working time.
COPYRIGHT AND LICENSE
Copyright (C) 2008 by Dmitry Ovsyanko
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or,
at your option, any later version of Perl 5 you may have available.
perl v5.10.1 2010-05-16 Spreadsheet::XLSX(3pm)