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 CENTOS
th_make_cells
thai/thcell.h(3) libthai thai/thcell.h(3)
NAME
thai/thcell.h -
Thai string cell custering.
SYNOPSIS
Data Structures
struct thcell_t
Thai char cell representation.
Functions
void th_init_cell (struct thcell_t *cell)
Initialize a Thai cell.
size_t th_next_cell (const thchar_t *s, size_t len, struct thcell_t *cell, int is_decomp_am)
Get first cell from string.
size_t th_prev_cell (const thchar_t *s, size_t pos, struct thcell_t *cell, int is_decomp_am)
Get previous cell from string.
size_t th_make_cells (const thchar_t *s, size_t len, struct thcell_t cells[], size_t *ncells, int is_decomp_am)
Tokenize string into cells.
Detailed Description
Thai string cell custering.
Function Documentation
void th_init_cell (struct thcell_t *cell)
Initialize a Thai cell.
Parameters:
cell : pointer to the cell to initialize
Initializes values in the Thai cell struct.
size_t th_make_cells (const thchar_t *s, size_tlen, struct thcell_tcells[], size_t *ncells, intis_decomp_am)
Tokenize string into cells.
Parameters:
s : the string
len : the length of string
cells : the array of output cells buffer
ncells : the address of integer storing the number of cells provided by the buffer, and to keep the number of resulting cells on return
is_decomp_am : whether SARA AM is to be decomposed into NIKHANIT and SARA AA and to be in separate cells
Returns:
total characters consumed
Tokenizes the string bounded by s and len into cells, and stores at most *ncells resulting cells in the cells buffer. On return, *ncells is
also set to the total cells stored in cells[].
size_t th_next_cell (const thchar_t *s, size_tlen, struct thcell_t *cell, intis_decomp_am)
Get first cell from string.
Parameters:
s : the string
len : the length of string
cell : the output buffer
is_decomp_am : whether SARA AM is to be decomposed into NIKHANIT and SARA AA and to be in separate cells
Returns:
total chars consumed by the cell
Gets first cell from the string bounded by s and len, and, if cell is not null, stores the cell data in it.
size_t th_prev_cell (const thchar_t *s, size_tpos, struct thcell_t *cell, intis_decomp_am)
Get previous cell from string.
Parameters:
s : the string
pos : the position in string to get cell previous to
cell : the output buffer
is_decomp_am : whether SARA AM is to be decomposed into NIKHANIT and SARA AA and to be in separate cells
Returns:
total chars consumed by the cell
Gets last cell from the string bounded by s and pos, and if cell is not null, stores the cell data in it.
Author
Generated automatically by Doxygen for libthai from the source code.
Version 0.1.14 Tue Jun 17 2014 thai/thcell.h(3)