10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need help in debug following script. can somebody help....!!!
#!/usr/bin/perl -w
use strict;
use Spreadsheet::WriteExcel;
# Create a new workbook called simple.xls and add a worksheet.
my $workbook = Spreadsheet::WriteExcel->new('simple.xls');
my $worksheet =... (1 Reply)
Discussion started by: chettyravi
1 Replies
2. Shell Programming and Scripting
I'm pulling down some LUN usage data once per day. I store the data in a file name that matches the name of the LUN. Then I just append new usage amounts to the same file each day.
Filename might be serv01_luna, serv01_lunb, serv01_lunc, etc, etc.
Inside the file it would like the following... (7 Replies)
Discussion started by: dwcasey
7 Replies
3. 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
4. Shell Programming and Scripting
so in unix this command works works and shows me a list of directories
find . -name \*.xls -exec dirname {} \; | sort -u | > list.txt
but when i try running a perl script to run this command
my $query = 'find . -name \*.xls -exec dirname {} \; | sort -u | > list.txt';... (2 Replies)
Discussion started by: kpddong
2 Replies
5. 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
6. 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
7. Shell Programming and Scripting
I understand that in order to run basic unix commands I would normally type at the prompt, I would have to use the following format
system(ls -l);
or
exec(ls -l);
But when I actually try to use the command, the script fails to compile and keeps telling me there is an error with this line. ... (1 Reply)
Discussion started by: userix
1 Replies
8. UNIX for Dummies Questions & Answers
Hi all,
I am not a computer programmer nor a computer specialist but I do create some Excel speadsheets and I need to download the data generated from Excel to a Unix/linux programmed screen. Do you know if there is a way or a "trick" that could make this data transfer automated so it would... (2 Replies)
Discussion started by: claude73
2 Replies
9. 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
10. UNIX for Dummies Questions & Answers
Does anyone know if it's possible to import a Unix directory into an Excel spreadsheet?
I'm trying to create a report based on about several thousand files within a Unix server directory, I was thinking if I could import the directory into a spreadsheet it would be easier to sort the data based... (2 Replies)
Discussion started by: Arkitech
2 Replies
TableMatrix::Spreadsheet(3pm) perl/Tk Documentation TableMatrix::Spreadsheet(3pm)
NAME
Tk::TableMatrix::Spreadsheet - Table Display with Spreadsheet-like bindings.
SYNOPSIS
use Tk;
use Tk::TableMatrix::Spreadsheet;
my $t = $top->Scrolled('Spreadsheet', -rows => 21, -cols => 11,
-width => 6, -height => 6,
-titlerows => 1, -titlecols => 1,
-variable => $arrayVar,
-selectmode => 'extended',
-titlerows => 1,
-titlecols => 1,
-bg => 'white',
);
DESCRIPTION
Tk::TableMatrix::Spreadsheet is a Tk::TableMatrix-derived widget that implements some bindings so the resulting widget behaves more like a
spreadsheet.
Bindings Added:
o
Row/Col resize handles appear when the cursor is placed over a row/col border line in the rol/col title area.
Dragging these handles will resize the row or column. If multiple rows or columns are selected, then the new row/col size will apply to
all row/cols selected.
Note: With the base Tk::TableMatrix, it is possible to resize the row/cols by dragging on any cell border. To be more spreadsheet-like,
Tk::TableMatrix::Spreadsheet defaults to enable row/col resizing only thru the title row/col dragging. To override this default behavoir,
set the -resizeborder option to 'both' at startup.
o
A popup menu for row/col insert/delete appears when the mouse is right-clicked in the row/col title areas.
o
Cells activate (i.e. the contents become edit-able) only when the cell is double-clicked or the F2 button is pressed. The default
Tk::TableMatrix behavior is for the cell to be activated when the cell is single-clicked.
o
The Escape key causes any changes made to a cell to be canceled and the current selection cleared.
o
The return key causes the the current cell to move down.
o
The tab (or shift tab) key causes the current cell to be moved to the right (left).
o
The delete key will delete the current selection, if no cell is currently active.
o
The Mouse button 2 (middle button) paste from the PRIMARY. (Control-v pastes from the clipboard).
Additional Information
Widget methods, options, etc, are inherited from the Tk::TableMatrix widget. See its docs for additional information.
Tk1.23 2007-01-09 TableMatrix::Spreadsheet(3pm)