08-25-2012
At the expense of coming across as pedantic, isn't the data you are storing going to be used for something else, such as a report or a graph? The data structure example you provide would not seem the most efficient way to build a report or graph off of. I dont even think Excel would be the optimal solution for this.
I concur with DGPickett that your first choice should be to write a script in for example Perl that transforms your data that is better suited for a database and subsequently analyse your data from there. Then Excel is probably not going to be part of the solution.
7 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I want to know that will Spreadsheet::WriteExcelXML coding will work in unix with perl and shell scripting. (1 Reply)
Discussion started by: akash
1 Replies
2. Shell Programming and Scripting
Hi,
I have a perl script that prints some data in the form of a table (HTML table) Now, I want to be able to convert this data into a report on an Excel sheet. How can I do this?
Regards,
Garric (4 Replies)
Discussion started by: garric
4 Replies
3. AIX
I may have posted in the wrong section, either way I need some help.
And I have to modify this part of the script, I'm not sure what to change the content-type to for this to work, or what else I would need to change here:
# This script sends Email acoording to command line arguments.
#... (1 Reply)
Discussion started by: NycUnxer
1 Replies
4. Shell Programming and Scripting
And I have to modify this part of the script, I'm not sure what to change the content-type to for this to work, or what else I would need to change here:
# This script sends Email acoording to command line arguments.
# $1 - file to be attached (full path with name)
# $2 - file name as it... (1 Reply)
Discussion started by: NycUnxer
1 Replies
5. Shell Programming and Scripting
I have a spreadsheet in a folder that looks like this:
Sector1...Sector2...Sector3...Sector4...Sector5...Sector6...Sector7
SomeID....Title.......SomeID...SomeID....SomeID...SomeID....SomeID
OtherID...MyTitle....SomeID...SomeID....SomeID...SomeID....SomeID... (7 Replies)
Discussion started by: Xterra
7 Replies
6. Shell Programming and Scripting
Very new to UNIX, so still getting used to all this.
I made a Perl script where I want to create a spreadsheet file when extracting "data" from a text file.
Now, this works perfectly fine on my Windows OS since I'm using the Win32 libraries with Microsoft Excel, but when I want to try it out on... (0 Replies)
Discussion started by: kooshi
0 Replies
7. Shell Programming and Scripting
Hi
I can't seem to figure out why i keep getting this error. the Spreadsheet::PhaseExcel is installed on 3 servers and is working on only 2... the last one it is installed exactly the same way but I keep getting this error.
This is whats odd.
If i run this script as a normal user i get... (2 Replies)
Discussion started by: vpundit
2 Replies
SG_RDAC(8) SG3_UTILS SG_RDAC(8)
NAME
sg_rdac - Display or Modify RDAC Redundant Controller Page
SYNOPSIS
sg_rdac [-a] [-f=LUN] [-v] [-V] DEVICE
DESCRIPTION
sg_rdac displays or modifies the RDAC controller settings via the Redundant Controller Page (0x2C). When modifying the settings it allows
to transfer the ownership of individual drives to the controller the command was received on.
OPTIONS
-a Transfer all (visible) devices
-f=LUN Transfer the device identified by LUN. This command will only work if the controller supports 'Dual Active Mode' (aka active/active
mode).
-v be verbose
-V print version string then exit
EXIT STATUS
The exit status of sg_rdac is 0 when it is successful. Otherwise see the sg3_utils(8) man page.
AUTHOR
Written by Hannes Reinecke <hare at suse dot com>, based on sg_emc_trespass.
REPORTING BUGS
Report bugs to <dgilbert at interlog dot com>.
COPYRIGHT
Copyright (C) 2006-2007 Hannes Reinecke, Douglas Gilbert.
This software is distributed under the GPL version 2. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PUR-
POSE.
sg3_utils-1.23 January 2007 SG_RDAC(8)