03-26-2008
Need to dump mailtest into a xls sheet
I have created a script which mails me the hardware info for each server i have, now i need to put all this info in an xls sheet which can be a pain, would this be possible through a script?
"======= HOSTNAME ========="
Host Name: servername
"===== IP ADDRESSES ========"
IP Address. . . . . . . . . . . . : x.x.x.x
IP Address. . . . . . . . . . . . : x.x.x.x
"===== CPU INFO ========"
[01]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[02]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[03]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[04]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[05]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[06]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[07]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[08]: EM64T Family 15 Model 4 Stepping 8 GenuineIntel ~2793 Mhz
[01]: Intel(R) PRO/1000 MT Network Connection
Processor(s): 8 Processor(s) Installed.
"===== MEMORY ========"
Total Physical Memory: 8,191 MB
"===== TOTAL DISK ON SERVER ========"
Microsoft DiskPart version 5.2.3790.3959
Copyright (C) 1999-2001 Microsoft Corporation.
On computer: servername
Disk ### Status Size Free Dyn Gpt
-------- ---------- ------- ------- --- ---
Disk 0 Online 68 GB 8033 KB
Disk 1 Online 838 GB 0 B
"===== RAID DISK INFORMATION IN SHORT ========"
Size : 68.24 GB (73274490880 bytes)
Size : 838.13 GB (899929866240 bytes)
Layout : RAID-1
Layout : RAID-10
"===== RAID DISK INFORMATION IN DETAILS ========"
Capacity : 68.24 GB (73274490880 bytes)
Capacity : 68.24 GB (73274490880 bytes)
Capacity : 279.38 GB (299976622080 bytes)
Capacity : 279.38 GB (299976622080 bytes)
Capacity : 279.38 GB (299976622080 bytes)
Capacity : 279.38 GB (299976622080 bytes)
Capacity : 279.38 GB (299976622080 bytes)
Capacity : 279.38 GB (299976622080 bytes)
Capacity : 279.38 GB (299976622080 bytes)
Capacity : 279.38 GB (299976622080 bytes)
"===== O/S RELEASE ========"
OS Name: Microsoft(R) Windows(R) Server 2003 Enterprise x64 Edition
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
help, what is the difference between core dump and panic dump? (1 Reply)
Discussion started by: aileen
1 Replies
2. HP-UX
Dear Members,
How do I create an eqvivalant of Excel sheet in Hp-UX.
Is there any application like the Microsoft Excel on HP-UX.
How do I invoke it.
Regards,
PrasadKVS (5 Replies)
Discussion started by: KVSPRASAD
5 Replies
3. Shell Programming and Scripting
Hi all,
please help me out in below requirement.
I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side
Ex:
abc.xls
Eno Ename
101 hello
102 hero
103 india
bbc.xls
Eno Ename
201 delhi
202 Hyd
203... (0 Replies)
Discussion started by: jagadish99
0 Replies
4. Shell Programming and Scripting
Hi all,
please help me out in below requirement.
I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side
Ex:
abc.xls bbc.xls
Eno Ename Eno Ename
101 hello ... (2 Replies)
Discussion started by: jagadish99
2 Replies
5. Shell Programming and Scripting
I need to convert an excel file into a text file
and an excel file into a CSV file..
any code to do that is appreciated
thanks (6 Replies)
Discussion started by: bandar007
6 Replies
6. Solaris
Hello,
I have an information of about 100 odd file names which i have in my server. I need to attach this information in an excel sheet and sent to the concerned team.
I use uuencode for attaching a text file. But how will i have all the information in attachment. Please assist. Is there... (1 Reply)
Discussion started by: venkidhadha
1 Replies
7. Shell Programming and Scripting
Hi folks,
I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx).
Spreadsheet contains few lines of hyperlink data (pic attached).
P.S. Hyperlink is behind the data and not visible in excel sheet directly.
Now using perl script I need to copy the hyperlinks in... (3 Replies)
Discussion started by: scriptscript
3 Replies
8. Shell Programming and Scripting
Hi Folks,
Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
1excel.xslx
2excel.xslx
3excel.xslx
now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies
9. Shell Programming and Scripting
HI,
I have multiple files per dept in folder
for eg : In a folder
File1_Dept100.xls
File2_Dept100.xls
File3_Dept100.xls
File1_Dept200.xls
File2_Dept200.xls
File3_Dept200.xls
Output should be :
Dept100.xls which has File1, File2, File3 in different tabs
Dept200.xls which has... (1 Reply)
Discussion started by: venkyzrocks
1 Replies
10. Shell Programming and Scripting
Hi all.
I am working on the below requirement of generating .xml file from .xls file which i have , can someone please help me or in writing the perl script for the same:
The xls file format is as below which has two columns and number of rows are not fixed:
Fixlet Name ... (12 Replies)
Discussion started by: omkar.jadhav
12 Replies
LEARN ABOUT DEBIAN
xlhtml
xlhtml(1) General Commands Manual xlhtml(1)
NAME
xlhtml - A program for converting Microsoft Excel Files .xls
SYNOPSIS
xlhtml [-a] [-asc] [-csv] [-xml] [-bcNNNNNN] [-bi/path] [-c] [-dp] [-v] [-fw] [-m] [-nc] [-nh] [-tcNNNNNN] [-te] [-xc:N-N] [-xp:N] [-xr:N-
N] FILE
DESCRIPTION
This manual page explains the xlhtml program. The program xlhtml is used to convert Microsoft Excel Spreadsheet files into either html or
tab delimitted ASCII. The program can be interfaced with helper scripts for viewing email attachments. Most use of this program is through
the helper scripts and one would probably rarely resort to using the commandline interface.
OPTIONS
-a aggressively optimize html by removing </TR> </TD> or VALIGN="bottom". Some older browsers may not display properly in this mode.
-asc Ascii out of -dp and extraction data (-xc, -xp, -xr)
-csv Output in Comma Separated Values of -dp and extraction data (-xc, -xp, -xr)
-xml Output in XML of -dp and extraction data (-xc, -xp, -xr)
-bc Override the background color. e.g. -bc808080 for gray
-bi Use background image. e.g. -bi/home/httpd/icon/tar.gif
-c Centers the tables horizontally
-dp Dump page count and max columns and rows per page
-v Prints program version
-fw suppress formula warnings about accuracy
-m No encoding for multibyte
-nc tells it not to colorize the output.
-nh Suppress header and body tags in html output
-tc Override the text color. e.g. -tcFF0000 for red
-te Trims empty rows & columns at the edges of a worksheet
-xc Columns (separated by a dash) for extraction (zero based)
-xp Page for extraction (zero based), one page only
-xr Rows (separated by a dash) to be extracted (zero based)
An example of the extraction command line is: xlhtml -fw -asc -xp:0 -xr:2-6 -xc:0-1 Test.xls
The extraction output is: Formatted output of cells by column left to right, columns separated by a tab, end of row is: 0x0A, end of file:
AUTHOR
Steve Grubb, Charles N Wyble
xlhtml May 15, 2002 xlhtml(1)