#!/usr/bin/perl
use Spreadsheet::WriteExcel;
# Create a new Excel workbook
my $workbook = Spreadsheet::WriteExcel->new('perl.xls');
# Add a worksheet
$worksheet = $workbook->add_worksheet();
# Add and define a format
$format = $workbook->add_format(); # Add a format
$format->set_bold();
$format->set_color('red');
$format->set_align('center');
# Write a formatted and unformatted string, row and column notation.
$col = $row = 0;
$worksheet->write($row, $col, 'Hi Excel!', $format);
$worksheet->write(1, $col, 'Hi Excel!');
Last edited by zaxxon; 03-23-2010 at 08:45 AM..
Reason: use code tags please,ty
I would like to read data from excel sheet as a input to a shell script.
Myproblem is the excel sheet is in windows. How can I write a shell script to read data from that excel sheet?
How can I do that?. (4 Replies)
Hi
HOWTO create in UNIX a Microsoft Excel sheet (with data from Oracle). At the moment I am making CSV files (using SQL statemens with || ';'), but search for more advanced formatting. Don't wish to use Perl.
cheers (4 Replies)
Hi,
Is there a way to find the count of number of rows of a.txt please? Where a.txt is as follows:
/usr/bin/uuencode /tmp/a.csv a.csv > /tmp/a.txt
#a.csv is a comma separated variable file
Cheers,
Girish. (7 Replies)
I have an Excel 2007 excel sheet on windows machine and using
Spreadsheet::XLSX I had written a script to read the excel sheet and was successful.
My requirement is I need to generate another excel sheet from the old excel 2007 sheet on unix machine.
Now is it possible to read the excel... (2 Replies)
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)
Hi,
i have some data in a temporary file in Unix (the data is taken from the result of an SQL query). Now i want to dump that data into an excel sheet. How to do that. Someone please advise. Thanks
Regards,
Vinit (3 Replies)
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
LEARN ABOUT DEBIAN
prima::header
Prima::Header(3) User Contributed Perl Documentation Prima::Header(3)NAME
Prima::Header - a multi-tabbed header widget.
DESCRIPTION
The widget class provides functionality of several button-like caption tabs, that can be moved and resized by the user. The class was
implemented with a view to serve as a table header for list and grid widgets.
API
Events
Click INDEX
Called when the user clicks on the tab, positioned at INDEX.
DrawItem CANVAS, INDEX, X1, Y1, X2, Y2, TEXT_BASELINE
A callback used to draw the tabs. CANVAS is the output object; INDEX is the index of a tab. X1,Y2,X2,Y2 are the coordinates of the
boundaries of the tab rectangle; TEXT_BASELINE is a pre-calculated vertical position for eventual centered text output.
MeasureItem INDEX, RESULT
Stores in scalar, referenced by RESULT, the width or height ( depending on vertical property value ) of the tab in pixels.
MoveItem OLD_INDEX, NEW_INDEX
Called when the user moves a tab from its old location, specified by OLD_INDEX, to the NEW_INDEX position. By the time of call, all
internal structures are updated.
SizeItem INDEX, OLD_EXTENT, NEW_EXTENT
Called when the user resizes a tab in INDEX position. OLD_EXTENT and NEW_EXTENT are either width or height of the tab, depending on
vertical property value.
SizeItems
Called when more than one tab has changed its extent. This might happen as a result of user action, as well as an effect of set-calling
to some properties.
Properties
clickable BOOLEAN
Selects if the user is allowed to click the tabs.
Default value: 1
dragable BOOLEAN
Selects if the user is allowed to move of the tabs.
Default value: 1
items ARRAY
Array of scalars, representing the internal data of the tabs. By default the scalars are treated as text strings.
minTabWidth INTEGER
A minimal extent in pixels a tab must occupy.
Default value: 2
offset INTEGER
An offset on the major axis ( depends on vertical property value ) that the widget is drawn with. Used for the conjunction with list
widgets ( see Prima::DetailedList ), when the list is horizontally or vertically scrolled.
Default value: 0
pressed INTEGER
Contains the index of the currently pressed tab. A -1 value is selected when no tabs are pressed.
Default value: -1
scalable BOOLEAN
Selects if the user is allowed to resize the tabs.
Default value: 1
vertical BOOLEAN
If 1, the tabs are aligned vertically; the offset, widths property and extent parameters of the callback notification assume heights of
the tabs.
If 0, the tabs are aligned horizontally, and the extent properties and parameters assume tab widths.
widths ARRAY
Array of integer values, corresponding to the extents of the tabs. The extents are widths ( "vertical" is 0 ) or heights ( "vertical"
is 1 ).
Methods
tab2offset INDEX
Returns offset of the INDEXth tab ( without regard to offset property value ).
tab2rect INDEX
Returns four integers, representing the rectangle area, occupied by the INDEXth tab ( without regard to offset property value ).
AUTHOR
Dmitry Karasik, <dmitry@karasik.eu.org>.
SEE ALSO
Prima, Prima::Widget, Prima::DetailedList, examples/sheet.pl.
perl v5.14.2 2009-02-24 Prima::Header(3)