Sponsored Content
Top Forums Shell Programming and Scripting Excel sheet to be created from unix. Post 302406517 by ktrimu on Tuesday 23rd of March 2010 07:37:33 AM
Old 03-23-2010
using perl

Hi
By using perl you can create excel sheets
Code:
#!/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
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Exporting files from unix to Excel sheet

How can we export a file in unix with certain number of columns to an excel sheet. It's very useful in time saving...... (3 Replies)
Discussion started by: bishweshwar
3 Replies

2. Shell Programming and Scripting

Read window Excel sheet to unix

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)
Discussion started by: vj8436
4 Replies

3. Shell Programming and Scripting

HOWTO create in UNIX a Microsoft Excel-Sheet (with data from Oracle)

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)
Discussion started by: slashdotweenie
4 Replies

4. Shell Programming and Scripting

How to check count of rows in excel sheet in Unix

Hi, Would anyone be able to tell me how to check the number of rows in an excel sheet on unix box, please? Cheers, Girish. (2 Replies)
Discussion started by: girish1428
2 Replies

5. Shell Programming and Scripting

Find count of rows in excel sheet in Unix

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)
Discussion started by: girish1428
7 Replies

6. Shell Programming and Scripting

Perl :Is it possible to read the excel 2007 sheet on unix machine using spredsheet::xlsx module

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)
Discussion started by: giridhar276
2 Replies

7. 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

8. UNIX for Dummies Questions & Answers

Load UNIX data into excel sheet

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)
Discussion started by: vinit raj
3 Replies

9. UNIX for Dummies Questions & Answers

UNIX data to be updated to ms excel sheet

hi, i wanted to add unix data to be updated to the excel sheet. (3 Replies)
Discussion started by: rupesh.bombale
3 Replies

10. 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
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)
All times are GMT -4. The time now is 12:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy