10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c command. But the problem is the file getting created is in binary format and hence some of the data becomes unreadable which has chinese characters as part of data.
file -i filename.csv - gives... (2 Replies)
Discussion started by: Dharmatheja
2 Replies
2. Shell Programming and Scripting
HI,
I have multiple files per dept in folder
for eg : In a folder
File1_Dept100.xls
File2_Dept100.xls
File3_Dept100.xls
File1_Dept200.xls
File2_Dept200.xls
File3_Dept200.xls
Output should be :
Dept100.xls which has File1, File2, File3 in different tabs
Dept200.xls which has... (1 Reply)
Discussion started by: venkyzrocks
1 Replies
3. Linux
Hi,
I have tried to convert a UTF-8 file to windows UTF-16 format file as below from unix machine
unix2dos < testing.txt | iconv -f UTF-8 -t UTF-16 > out.txt
and i am getting some chinese characters as below which l opened the converted file on windows machine.
LANG=en_US.UTF-8... (3 Replies)
Discussion started by: phanidhar6039
3 Replies
4. Shell Programming and Scripting
Dear Friends,
I am in urgent need for awk/sed/sh script for converting a specific data format (.txt) to .xls.
The input is as follows:
>gi|1234|ref|
Query = 1 - 65, Target = 1677 - 1733
Score = 8.38, E = 0.6529, P = 0.0001513, GC = 46
fd sdfsdfsdfsdf
fsdfdsfdfdfdfdfdf... (6 Replies)
Discussion started by: Amit1
6 Replies
5. Shell Programming and Scripting
Hi,
I need the output of sql query which is executed using a shell script to xls file format. (10 Replies)
Discussion started by: Arasu
10 Replies
6. Shell Programming and Scripting
Hi Folks,
I have written a perl script that reads data from excel sheet(.xls) using Spreadsheet::ParseExcel module. But the problem is this module doesn't work for excel sheets with extension .xlsx.
I have gone through Spreadsheet::XLSX module with which we can read from .xlsx file directly.... (1 Reply)
Discussion started by: giridhar276
1 Replies
7. Shell Programming and Scripting
Hi All,
Can any one help me to get the shell/perl scripts for the below requirements.
1: To get the clearcase checkin's information between two lables
generate a formatted Xls output
and to find the added changed and removed files and versions between
the ClearCase baselines.
2... (2 Replies)
Discussion started by: saku
2 Replies
8. UNIX for Dummies Questions & Answers
I have a .csv file in Unix box i need a UNIX script to convert the.csv files to.xls format.
Its very urgent please help me. (1 Reply)
Discussion started by: moon_friend
1 Replies
9. Shell Programming and Scripting
Hi,
I have a file coming in xxx.txt(csv format) i do some work on it and i need to send out as a .xls format. Is there any way there is some code i can use in my script to convert this?
I'm struggling on this.
Thanks (11 Replies)
Discussion started by: Pablo_beezo
11 Replies
10. Shell Programming and Scripting
Hi
I have spool file which is pipe delimated and i want to convert it into xls .
Is any tool or method availabe in UNIX for this kind of conversion (2 Replies)
Discussion started by: prasadg
2 Replies
Geo::GoogleEarth::Pluggable(3pm) User Contributed Perl Documentation Geo::GoogleEarth::Pluggable(3pm)
NAME
Geo::GoogleEarth::Pluggable - Generates GoogleEarth Documents
SYNOPSIS
use Geo::GoogleEarth::Pluggable;
my $document=Geo::GoogleEarth::Pluggable->new(%data); #is a special Folder...
my $folder =$document->Folder(%data); #isa Geo::GoogleEarth::Pluggable::Folder
my $point =$document->Point(%data); #isa Geo::GoogleEarth::Pluggable::Point
my $netlink =$document->NetworkLink(%data); #isa Geo::GoogleEarth::Pluggable::NetworkLink
my $lookat =$document->LookAt(%data); #isa Geo::GoogleEarth::Pluggable::LookAt
my $style =$document->Style(%data); #isa Geo::GoogleEarth::Pluggable::Style
print $document->render;
KML CGI Example
use Geo::GoogleEarth::Pluggable;
my $document=Geo::GoogleEarth::Pluggable->new(name=>"KML Document");
print $document->header,
$document->render;
KMZ CGI Example
use Geo::GoogleEarth::Pluggable;
my $document=Geo::GoogleEarth::Pluggable->new(name=>"KMZ Document");
print $document->header_kmz,
$document->archive;
DESCRIPTION
Geo::GoogleEarth::Pluggable is a Perl object oriented interface that allows for the creation of XML documents that can be used with Google
Earth.
Geo::GoogleEarth::Pluggable (aka Document) is a Geo::GoogleEarth::Pluggable::Folder with a render method.
Object Inheritance Graph
-- Base --- Folder --- Document
|
+- Placemark -+- Point
| +- LineString
| +- LinearRing
|
+- StyleBase -+- Style
| +- StyleMap
|
+- NetworkLink
USAGE
This is all of the code you need to generate a complete Google Earth document.
use Geo::GoogleEarth::Pluggable;
my $document=Geo::GoogleEarth::Pluggable->new;
$document->Point(name=>"White House", lat=>38.897337, lon=>-77.036503);
print $document->render;
CONSTRUCTOR
new
my $document=Geo::GoogleEarth::Pluggable->new(name=>"My Name");
METHODS
type
Returns the object type.
my $type=$folder->type;
document
Returns the document object.
All objects know to which document they belong even the document itself!
render
Returns an XML document with an XML declaration and a root name of "Document"
print $document->render;
archive
Returns a KMZ formatted Zipped archive of the XML document
print $document->archive;
xmlns
Add or update a namespace
$document->xmlns->{"namespace"}=$url;
Delete a namespace
delete($document->xmlns->{"xmlns:gx"});
Replace all namespaces
$document->{"xmlns"}={namespace=>$url};
Reset to default namespaces
delete($document->{"xmlns"});
nextId
This method is in the document since all Styles and StyleMaps are in the document not folders.
my $id=$document->nextId($type); #$type in "Style" or "StyleMap"
header, header_kml
Returns a header appropriate for a web application
Content-type: application/vnd.google-earth.kml+xml
Content-Disposition: attachment; filename=filename.xls
$document->header #embedded in browser
$document->header(filename=>"filename.xls") #download prompt
$document->header(content_type=>"application/vnd.google-earth.kml+xml") #default content type
header_kmz
Returns a header appropriate for a web application
Content-type: application/vnd.google-earth.kml+xml
Content-Disposition: attachment; filename=filename.xls
$document->header_kmz #embedded in browser
$document->header_kmz(filename=>"filename.xls") #download prompt
$document->header_kmz(content_type=>"application/vnd.google-earth.kmz") #default content type
TODO
Support for default Polygon and Line styles that are nicer than GoogleEarth's
Support for DateTime object in the constructor that is promoted to the LookAt object.
Create a GPS::Point plugin (Promote tag as name and datetime to LookAt)
BUGS
Please log on RT and send to the geo-perl email list.
LIMITATIONS
Not So Pretty XML
The XML produced by XML::LibXML is not "pretty". If you need pretty XML you must pass the output through xmllint or a simular product.
For example:
perl -MGeo::GoogleEarth::Pluggable -e "print Geo::GoogleEarth::Pluggable->new->render" | xmllint --format -
Write Only
This package can only write KML and KMZ files. However, if you need to read KML files, please see the Geo::KML package's "from" method.
SUPPORT
DavisNetworks.com supports all Perl applications including this package.
AUTHOR
Michael R. Davis (mrdvt92)
CPAN ID: MRDVT
COPYRIGHT
This program is free software licensed under the...
The BSD License
The full text of the license can be found in the LICENSE file included with this module.
SEE ALSO
Geo::KML, XML::LibXML, XML::LibXML::LazyBuilder, Archive::Zip, IO::Scalar
perl v5.14.2 2011-06-25 Geo::GoogleEarth::Pluggable(3pm)