Need to dump mailtest into a xls sheet


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need to dump mailtest into a xls sheet
# 1  
Old 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
# 2  
Old 03-26-2008
Create a .csv file and use tab as delimiter. When you import into Excel, select one column and use Data > text to columns wizard to create a formatted report

Atleast that is what i have been doing till now. Works well for me and my customers

~s4g3
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Writing xml from excel sheet .xls using perl script

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

2. Shell Programming and Scripting

Merging Multiple XLS into Different tabs in xls/ xlsx

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

3. Shell Programming and Scripting

Summing up the data from different excel sheet into one excel sheet

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

4. Shell Programming and Scripting

Perl : to get all the hyperlinks from the xlsx sheet(hyperlinks not visible in excel sheet directly)

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

5. Solaris

Excel sheet

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

6. Shell Programming and Scripting

converting xls file to txt file and xls to csv

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

7. Shell Programming and Scripting

How to Merge Two .xls files side by side into a single .xls

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

8. Shell Programming and Scripting

How to Merge Two .xls files side by side into a single .xls

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

9. HP-UX

Creating Excel Sheet in 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

10. UNIX for Dummies Questions & Answers

help, what is the difference between core dump and panic dump?

help, what is the difference between core dump and panic dump? (1 Reply)
Discussion started by: aileen
1 Replies
Login or Register to Ask a Question