12-18-2008
UNIX -> send data as excel in seperate cells
Hi
I have a data file in UNIX as follows. I need to send this file in Mail as excel format. but the problem i face is i get the data all in single cells per row. what can i do to get the data in seperate cells.
File -> attachment.xls
data data data data
data1 data1 data1 data1
data data data data
I use the following command
uuencode attachment.xls attachment.xls|mailx -s "Attachment"
vj8436@att.com
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a shell script which send email with an attachment in the form of an email. However, the when I open the attachment, all the data comes in one column. How do I format the data in the excel sheet while sending the email?
Thanks (8 Replies)
Discussion started by: bdebroy
8 Replies
2. UNIX for Advanced & Expert Users
I have 3 columns in an excel sheet.
c1 c2 c3
EIP_ACCOUNT SMALL_TS_01 select A.* from acc;
All the above 3 col shoud be passed a variable in the unix code.
1.How to read an excel file
2.How to pass these data as variable to the unic script (1 Reply)
Discussion started by: Anne Grace
1 Replies
3. Shell Programming and Scripting
Hi all
I have a shell script that uses a stored proc to generate output from some tables and send the same in an e-mail using mailx command. Now I need to convert the output to excel format and send e-mail. How can I achieve this. Please help me in this regard, as it's very urgent and I have been... (5 Replies)
Discussion started by: sanbabu
5 Replies
4. Shell Programming and Scripting
Hi,
I need to email a data in excel sheet from unix using shell scripting.I could able to generate the data file with tab delimiter with extension .xls could able to email it.
The problem is when a coulmn with 16 digit number is exported, it is showing in scientific format. Any help in... (1 Reply)
Discussion started by: sparan_peddu
1 Replies
5. Shell Programming and Scripting
Hi
I have 2 csv files which looks like the following and i have to compare the 2 CSVs and create a third file such that if the value of the 1st cell in A.CSV and the value of the first cell in the B.CSV are same, it should print "SAME" in the third file or else print NOT SAME. Likewise i need... (19 Replies)
Discussion started by: meva
19 Replies
6. Programming
Dear Folks,
Is there anyone know how to do the group and ungroup cells feature of MS Excel through java.
Please help.
Please find the attachment.I want the code to do something like this. (0 Replies)
Discussion started by: dinesh1985
0 Replies
7. Shell Programming and Scripting
Hi UNIX Gods!
Is it possible to merge two cells in .csv file using unix commands?
Imagine that this is my present csv file opened via excel:
Gate Reports| |
fatal alerts | 200 |
is is possible to make it look like this using unix?
Gate Reports |
fatal... (1 Reply)
Discussion started by: 4dirk1
1 Replies
8. Shell Programming and Scripting
Hi Experts,
i need your help here
:confused:
Need to send a report thru mail using unix shell script(AIX). can you help me to do this? . i tried "uuencode" with CSV format, but while reading report all values are in single column. i need each column values in separate cell.
Thanks in... (9 Replies)
Discussion started by: newbieabc
9 Replies
9. Programming
Perl script to merge cells
---------- Post updated at 12:59 AM ---------- Previous update was at 12:54 AM ----------
I am using below code to read files from a dir and print to excel.
open(my $in, '<', $file) or die "Could not open file: $!";
my $rowCount = 0;
my $colCount = 0;... (11 Replies)
Discussion started by: Jack_Bruce
11 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I would like to extract the data from particular date,
1. may i know which command i need to use?
2. Extract from unix command (those extracted above) to excel?
Please assist.
Thanks (2 Replies)
Discussion started by: Peru
2 Replies
LEARN ABOUT SUSE
openipmicmd
openipmicmd(1) An IPMI Command Interface openipmicmd(1)
NAME
openipmicmd - An IPMI Command Interface
SYNOPSIS
openipmicmd [-k entry-to-execute] <connection parms>
DESCRIPTION
The openipmicmd program allows a user to execute direct IPMI commands. It can work with direct interface with the OpenIPMI driver or with
IPMI LAN interfaces.
OPTIONS
-k entry-to-execute
Execute a single command an exit.
<connectionparms>
The parameters for the connection depend on the connection type. These are all described in openipmi_conparms (7)
COMMANDS
Once up, you can execute commands in the user interface. Note that commands and responses are asynchronous, you issue a command and the
interface returns immediately. When the response comes back, it will be dumped on your console. That's a little strange looking, but IPMI
is ansychronous underneath. Note that the -k option is synchronous, it will wait for the response or a timeout before returning.
0f lun netfn cmd [data1 [data2 ...]]
Send a command to the BMC you are connected to.
channel [ipmb] IPMB-addr lun netfn [seq] cmd [data1 [data2 ...]]
Send a command to a device on the IPMB bus. The "ipmb" string is optional. The seq must be provided if the netfn is a response (an
odd number). It must be the same sequence number that came in on the command in the "Command Sequence = seq" part of the command.
channel 00 IPMB-addr lun netfn cmd [data1 [data2 ...]]
Send a broadcast command to a device on the IPMB bus.
channel lan handle remote-swid local-swid lun netfn cmd [data1 [data ...]]
Send a command to a device over a LAN channel. Note that this not the same as a LAN connection. This sends a message through a
local BMC to a remote system that is hooked up with a LAN connection.
test_lat count command
Executes the given commands (one of the previous commands) count times and gives the average time per command to execute. Note that
"count" is hexadecimal.
help Display some help.
regcmd netfn cmd
Register to receive the given command. If the driver receives an external command, it will print it out. This only works with sys-
tem interface connections, it will not work on LAN connections.
unregcmd netfn cmd
Remove a command registration.
SEE ALSO
ipmi_ui(1), ipmilan(8), openipmi_conparms(7)
KNOWN PROBLEMS
The asychronous nature of the program can be annoying.
AUTHOR
Corey Minyard <cminyard@mvista.org>
OpenIPMI 05/13/03 openipmicmd(1)