Notice that the last column of the 1st and the last row have a single quote mark. I think because of which all the rows between these two rows are missing in the email attachment when it is opened as an excel sheet. however, they are seen if opened in a notepad.
Hi,
Can anyone tell the option to change the file type in unix.
i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format.
Thanks in advance,
Milton. (1 Reply)
Hi does anybody know how to convert xls to csv undex linux.
I need only data (that is log from test, dont need any macro and so on) from xls.
Any idea how to do that? Perl? shell? Could you give me any example?
Thanks in advance for answer.
Gracjan (4 Replies)
Ok, every morning at my office we send out excel sheets to Economy people with statistics for yesterdays trading.
All the trading run's in Redhat or Solaris environments.
We run a script on a Redhat server whitch generates the stats in CSV format.
After we download we open it in Excel and... (3 Replies)
I would like to know if have one way with read table from oracle converter in CSV o TXT and After converter in XLS or spreedsheet
Thanks so much
JAvier (3 Replies)
Hello
I have a script which converts log to csv.
Now I need to have xls.
Is there any easy way/command which can convert csv to xls?:confused:
preferably just using bash and not perl,... is it possible? (1 Reply)
Discussion started by: frhling
1 Replies
LEARN ABOUT DEBIAN
layout::manager::grid
Layout::Manager::Grid(3pm) User Contributed Perl Documentation Layout::Manager::Grid(3pm)NAME
Layout::Manager::Grid - Simple grid-based layout manager.
DESCRIPTION
Layout::Manager::Grid is a layout manager places components into evenly divided cells.
When you instantiate a Grid manager, you must supply it with a count of how many rows and columns it will have. For example, a Grid with 1
column and 2 rows would look like:
+--------------------------------+
| |
| component 1 |
| |
+--------------------------------+
| |
| component 2 |
| |
+--------------------------------+
The container is divided into as many <rows> * <columns> cells, with each taking up an equal amount of space. A grid with 3 columns and 2
rows would create 6 cells that consume 33% of the width and 50% of the height.
Components are placed by specifying the cell they reside in via the row and column number.
$container->add_component($comp, { row => 0, column => 3 });
$container->add_component($comp, { row => 0, column => 2, height => 2 });
Optionally, you may choose to override the default "width" or "height" of 1. Setting it to a something else will cause the component to
consume that many rows or columns worth of space.
Grid is similar to Java's GridLayout <http://java.sun.com/docs/books/tutorial/uiswing/layout/grid.html>.
SYNOPSIS
$cont->add_component($comp1, { row => 0, column => 1 });
$cont->add_component($comp2, { row => 0, column => 2 });
my $lm = Layout::Manager::Grid->new(rows => 1, columns => 2);
$lm->do_layout($con);
DYNAMIC SIZING
If the container that the Grid is manging does not have one or both of it's dimensions set, Grid will compute the appropriate sizes. The
simple way for me to avoid writing a long explanation is to say it works similar to HTML tables. Rows will become as big as their biggest
consituent, as will columns. It is common to add a Grid-managed component to a scene with only one of it's dimensions set.
ATTRIBUTES
columns
The number of columns in this Grid.
rows
The number of rows in this Grid.
METHODS
do_layout
Size and position the components in this layout.
AUTHOR
Cory Watson, "<gphat@cpan.org>"
COPYRIGHT & LICENSE
Copyright 2008 - 2010 Cory G Watson
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.12.3 2011-05-16 Layout::Manager::Grid(3pm)