Hello,
I am trying to send an email with the below attachment in .xls file format by default its opening everything in a single column in the email. How to display the column in a separate column in excel instead everything together.
Code:
2017/01/01 a 10
2017/01/01 b 20
2017/01/01 c 40
2017/01/01 a 60
2017/01/01 b 50
2017/01/01 c 40
Moderator's Comments:
Please use CODE tags as required by forum rules!
Last edited by RudiC; 04-13-2017 at 06:34 PM..
Reason: Added CODE tags.
I am running a perl script that generates an excel doc and then emails it as an attachment. I can generate the excel file fine. I can scp it from the box and open it with no problems. When I send it over email, the file does open properly. The file in email is only 288 B, but on the server it is... (1 Reply)
Hi,
I need your help in sedning sql queries output to different excel sheets.
My requirement is like this:
Query1: Select name from table1 where status = 'Complete'
Query2: Select name from table1 where status = 'Failed'
Query3: Select name from table1 where status = 'Ignored'
... (4 Replies)
I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd.
The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4".
This is what I use to change the format:
sed -i '' -e... (2 Replies)
Hi All,
I have created a Unix Shell script whch creates a *.csv file and export it to Excel.
The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example :
if the Amount has the value as 3000000 User wants to be in 3,000,000 format.
This Amount format... (2 Replies)
This is my first time writing a script and Im having some trouble,
Im trying to use the top command to monitor processes and the amount of CPU usage they require, my aim is to get an email if a process takes over a certain percentage of CPU usage
I tried grep
Obviosly that hasnt worked,
Any... (8 Replies)
Hi,
I am trying to send email with attachment using mailx command. I am using the folowing command:
uuencode XX_HWSW_BUYERWISE_88963631_1.xls XX_HWSW_BUYERWISE_88963631_1.xls | mailx -s "Test Mail as Attachment" oracleams@xyz.com
I get the email in the inbox. However, when I try to open the... (5 Replies)
Hi,
I want to format Excel sheet through Unix script.
Format would mean bolding the data in the cell, adding clor to it etc.
Please help me if it is possible through Unix scripting?
Thanks,
Durga (2 Replies)
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Hi
I have a script running in lunix machine which emails log file content to my outlook.
Here is the actual log file result:
Image-1
In-Master:25028
ReplicaDn Consumer Supplier Delay
dc=xxx,dc=com lmjker0110:12345 ... (4 Replies)
Hie,
I need to attach an .xlsx file as an attachment to a mail. I have used the mail option but i dont think there is anything for attachment. Can you show me how else can i do it? I am not allowed to install mutt since it is a workplace and they have their restrictions. And its a Bash Shell (2 Replies)
Discussion started by: barryallen
2 Replies
LEARN ABOUT DEBIAN
amc-mailing
AMC-MAILING(1) Auto Multiple Choice AMC-MAILING(1)NAME
AMC-mailing - mail PDF annotated completed answer sheets to students
SYNOPSIS
auto-multiple-choice mailing [--xmlargs args.xml] --projet project-dir --students-list students-list.csv [--list-encoding encoding]
--email-column col --sender sender-email --subject subject --text email-body [--debug file.log]
[transport arguments...]
DESCRIPTION
The command AMC-mailing.pl sends by email the PDF annotated completed answer sheets to the students. Email addresses are taken from the
students list file.
--projet project-dir
Gives the project directory.
--students-list students-list.csv
sets the students list file name.
--list-encoding encoding
selects an encoding for file students-list.csv (default is utf-8).
--email-column col
sets the name of the column containing the email addresses of the students in the students list file.
--sender sender-email
sets the sender email.
--subject subject
sets the subject of the emails to send.
--text email-body
sets the body text of the emails to send.
--transport transport
sets the transport to use. transport may be sendmail or SMTP.
--debug file.log
gives a file to fill with debugging information.
TRANSPORT ARGUMENTS
Depending on the value used for argument transport, the following arguments can be added:
Transport sendmail
--sendmail-path path
sets the path to the sendmail command (defaults to /usr/sbin/sendmail).
Transport SMTP
--smtp-host host
sets the SMTP hostname (defaults to smtp).
--smtp-port port
sets the port to use (default value is 25).
ARGUMENTS IN A XML FILE
To avoid encoding problems, one can place some arguments in a XML file and use the --xmlargs file.xml argument as the first command
argument. Here is an exemple of such a file:
<?xml version="1.0" encoding="UTF-8"?>
<arguments>
<arg>--sender</arg><arg>Bienvenue <paamc@passoire.fr></arg>
<arg>--text</arg><arg>Voila votre copie corrigee</arg>
<arg>--subject</arg><arg>QCM</arg>
</arguments>
AUTHORS
Alexis Bienvenue <paamc@passoire.fr>
Main author
Jean Berard
Translation from French
Georges Khaznadar
Translation from French
COPYRIGHT
Copyright (C) 2008-2012 Alexis Bienvenue
This document can be used according to the terms of the GNU General Public License, version 2 or later.
Auto Multiple Choice 1.1.1 06/19/2012 AMC-MAILING(1)
04-13-2017
