Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Perl : corrupted excelsheet while trying to open
Top Forums Shell Programming and Scripting Perl : corrupted excelsheet while trying to open Post 302787365 by scriptscript on Friday 29th of March 2013 09:37:29 AM
Old 03-29-2013
Perl : corrupted excelsheet while trying to open
Hi folks,

I am trying to send the mail with spreadsheet attachment in perl.I am able to send the mail with xlsx attachment as well but not able to open the xlsx sheet.While opening the sheet I am receiving the corrupted message.

Below is the code.

Code:
use MIME::Lite;
use Net::SMTP;

### Adjust sender, recipient and your SMTP mailhost
my $from_address = 'fromemailid';
my $to_address = 'toemailid';
my $mail_host = 'smtp_ip';

### Adjust subject and body message

my $message_body = "Here's the attachment file(s) you wanted";

### Adjust the filenames
my $my_file_path = "mypath";
my $your_file_xlsx = 'myfile.xlsx';


### Create the multipart container
$msg = MIME::Lite->new (
  From => $from_address,
  To => $to_address,
  Subject => $subject,
  Type =>'multipart/mixed'
) or die "Error creating multipart container: $!\n";

### Add the text message part

### Add the GIF file
$msg->attach (
   Type => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
#   Encoding => 'base64',
   Path => $my_file_path,
   Filename => $your_file_xlsx,
   Disposition => 'attachment'
) or die "Error occured\n";

### Send the Message
MIME::Lite->send('smtp', $mail_host, Timeout=>60);
$msg->send;

Could anyone please let me know what went wrong ?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with excelsheet generation

Hi All, i have around 50 queries in sybase. We have a requirement where we need to write a unix script, which execute the query one by one & generate the excel sheet & send it to user. I have completed half of the part, where i am executing query one by one & putting the result into a .txt... (4 Replies)
Discussion started by: Amit.Sagpariya
4 Replies

2. Shell Programming and Scripting

perl window.open without blocker

Hi Everyone, We know that when we open a popup window, if my IE, Yahoo tool bar enable the popup-blocker, then my window will be blocked. like my code. print <<EOD; <script language=JavaScript> var s = new String(window.location.href); if (s.match(/Start/)){ ... (3 Replies)
Discussion started by: jimmy_y
3 Replies

3. Shell Programming and Scripting

Corrupted Download with Net::FTP (perl)

Hello, I am trying to download several files from a remote FTP server using Net::FTP from within a perl script. The files download alright, except they appear to be corrupted. I know this because once after downloading, I use bzcat to pipe the files to a split command, and bzcat complains saying... (3 Replies)
Discussion started by: amcrisan
3 Replies

4. Shell Programming and Scripting

Perl open a remote shell

Hello , I am writing a script which takes the user name , password and hostname from the database and login to the server . I am only able to login to the server and my script logs out and only I can run few command if I provide those command in my script else I am not able to run those... (11 Replies)
Discussion started by: pratapsingh
11 Replies

5. Shell Programming and Scripting

Help !! perl open function

Help Please perl Gurus, I am trying to add ungrouped passengers in a group and I creating a script however it fails on first step only I tried all the options it returns following error. syntax error at junki line 4, near "open " Execution of junki aborted due to compilation errors. ... (2 Replies)
Discussion started by: dynamax
2 Replies

6. Shell Programming and Scripting

Perl - Grep open file more then once.

Hi, I am using File::Find to go through a very large tree. I am looking for all xml files and open only those that contain a tag <Updated>. I then want to capture the contents of two tags <Old> and <New>. My problem is, after I open the file and do the first grep for <Updated> (which does... (3 Replies)
Discussion started by: OldGaf
3 Replies

7. Shell Programming and Scripting

Unable to open a file in perl

Not able to open a file using this code why not? use strict; use warnings; my $file = "verInfo.txt"; unless(open FILE, $file) { # Die with error message # if we can't open it. die "\nUnable to open $file\n"; } my $line = <FILE>; print $line; close FILE; (7 Replies)
Discussion started by: srijith
7 Replies

8. Shell Programming and Scripting

open a webpage through perl script

Hi All Can anyone please help me how to open a webpage suppose(Google) with the help of perl script and refresh it after every 5 minutes. (0 Replies)
Discussion started by: parthmittal2007
0 Replies

9. Shell Programming and Scripting

PERL - issue with OPEN

Hi, I have a menu script written in PERL which calls some shell scripts and displays the return. I'm having a problem with OPEN. A section of the code is below: `./scriptlist.ksh 1`; open OUTPUT, "</home/$SCRIPTUSER/output"; { local $/ = undef; $_ =... (2 Replies)
Discussion started by: chris01010
2 Replies

10. Shell Programming and Scripting

Need to extract jil file details in a excelsheet

I am very new to shell scripting. I have a autosys jil file that looks like :-- /* ------------- JOB1 ------------------ */ insert_job: JOB1 job_type: b owner: cm@pelonmuck permission: gx,ge,wx,we,mx,me date_conditions: 1 days_of_week: mo,tu,we,th,fr,su start_time: "18:30"... (9 Replies)
Discussion started by: newbie_shell
9 Replies

LEARN ABOUT SUSE

calibre-smtp

CALIBRE-SMTP(1) 						      calibre							   CALIBRE-SMTP(1)

NAME

       calibre-smtp - part of calibre

SYNOPSIS

       calibre-smtp  [options] [from to text]

DESCRIPTION

       Send  mail using the SMTP protocol. calibre-smtp has two modes of operation. In the compose mode you specify from to and text and these are
       used to build and send an email message. In the filter mode, calibre-smtp reads a complete email message from STDIN and sends it.

       text is the body of the email message.  If text is not specified, a complete email message is read from STDIN.  from is the  email  address
       of the sender and to is the email address of the recipient. When a complete email is read from STDIN, from and to are only used in the SMTP
       negotiation, the message headers are not modified.

       Whenever you pass arguments to calibre-smtp that have spaces in them, enclose the arguments in quotation marks.

OPTIONS

       --version
	      show program's version number and exit

       -h, --help
	      show this help message and exit

       -l, --localhost
	      Host name of localhost. Used when connecting to SMTP server.

       -o, --outbox
	      Path to maildir folder to store failed email messages in.

       -f, --fork
	      Fork and deliver message in background. If you use this option, you should also use --outbox to handle delivery failures.

       -t, --timeout
	      Timeout for connection

       -v, --verbose
	      Be more verbose

   COMPOSE MAIL
       Options to compose an email. Ignored if text is not specified

       -a, --attachment
	      File to attach to the email

       -s, --subject
	      Subject of the email

   SMTP RELAY
       Options to use an SMTP relay server to send mail. calibre will try to send the email directly unless --relay is specified.

       -r, --relay
	      An SMTP relay server to use to send mail.

       --port Port to connect to on relay server. Default is to use 465 if encryption method is SSL and 25 otherwise.

       -u, --username
	      Username for relay

       -p, --password
	      Password for relay

       -e, --encryption-method
	      Encryption method to use when connecting to relay. Choices are TLS and SSL. Default is TLS.

SEE ALSO

       The User Manual is available at http://calibre-ebook.com/user_manual

       Created by Kovid Goyal <kovid@kovidgoyal.net>

calibre-smtp (calibre 0.6.53)					     July 2010							   CALIBRE-SMTP(1)
All times are GMT -4. The time now is 11:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy