11-14-2007
I would have thought that Excel supports a whole range of date formats, I suppose the trick is to tell it which one to use while importing.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello friends,
I am looking for a script or method that can display all the dates between any 2 given dates.
Input:
Date 1
290109
Date 2
010209
Output:
300109
310109
Please help me. Thanks. :):confused: (2 Replies)
Discussion started by: frozensmilz
2 Replies
2. Shell Programming and Scripting
Hi I am working on the script parsing specific message "TEST" from multiple file. The log file name looks like:
N3.2009-11-26-03-05-02.console.log.tar.gz
N4.2009-11-29-00-25-03.console.log.tar.gz
N6.2009-12-01-10-05-02.console.log.tar.gz
I am using the following command:
zgrep -a --text... (1 Reply)
Discussion started by: shyork2001
1 Replies
3. Shell Programming and Scripting
I remember there is a sed switch i can use to edit and save the file at the same time, but i cannot recall it at all.
so instead of
-> sed 's/A/B/' file > file-tmp
-> mv file-tmp file
what can i do to just let sed edit and save the "file" (4 Replies)
Discussion started by: fedora
4 Replies
4. UNIX for Advanced & Expert Users
This took me quite awhile to find so I wanted to share this with other people.
To switch windows in vimdiff or
to navigate windows in vimdiff or
to change windows in vimdiff try the following:
The ":vertical" command can be inserted before another command that
splits a window.
... (0 Replies)
Discussion started by: cokedude
0 Replies
5. UNIX for Dummies Questions & Answers
HP-UX
I have a fixed length file like this
9921190625797AE2560 20091001US20091001@@NEWSITE @@ 20091013001X X 01NEW00DNA00007081 @@ SPRINGFIELD @@ ... (2 Replies)
Discussion started by: rs1969
2 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
I am trying to print the dates that falls between 2 date variables into a file. Here is the example.
$BUS_DATE =20120616
$SUB_DATE=20120613
Output to file abc.txt should be : 20120613,20120614,120120615,20120616
Can you pls help me accomplish this in LINUX.
Thanks... (5 Replies)
Discussion started by: dsfreddie
5 Replies
7. Shell Programming and Scripting
Dear all,
I have file input like this,
file input:
input.txt
ROUTE 0001,
( 10021)=X 71Y 1605,
X 1486Y 2220,X 1720Y 2380,X 1962Y 2553,X 2112Y 2650,X 2289Y 2746,
YF 5000,
( 10022)=X 71Y 1605,
X 498Y... (4 Replies)
Discussion started by: attila
4 Replies
8. UNIX for Advanced & Expert Users
Hi Am Using Unix Ksh ...
I have a Table called date
select * from date ;
Date
01/02/2013
06/02/2013
I need the output as
Missing Date
01/02/2013
02/02/2013
03/02/2013
04/02/2013
05/02/2013
06/02/2013 (2 Replies)
Discussion started by: Venkatesh1
2 Replies
9. Shell Programming and Scripting
Hi
I have problem with replace line in txt file , I have this string:
144185 DISK
Piece qqr8ot6l_1_1
--
144186 DISK
Piece ukr8pf2e_1_1
--
144187 DISK
Piece ter8p9gc_1_1
--
144188 DISK
Piece 4er8qb84_1_1
and (8 Replies)
Discussion started by: primo102
8 Replies
10. UNIX for Beginners Questions & Answers
I have multiple strings in a file which have special character $, when i search strings by ignoring $ with \ using single quotes it returns empty results.
My search strings are set char_1($lock) and set new_char_clear_3($unlock)
I tried searching with
but it returns empty results.However... (3 Replies)
Discussion started by: g_eashwar
3 Replies
LEARN ABOUT DEBIAN
excel::writer::xlsx::package::packager
Excel::Writer::XLSX::Package::Packager(3pm) User Contributed Perl Documentation Excel::Writer::XLSX::Package::Packager(3pm)
NAME
Packager - A class for creating the Excel XLSX package.
SYNOPSIS
See the documentation for Excel::Writer::XLSX.
DESCRIPTION
This module is used in conjunction with Excel::Writer::XLSX to create an Excel XLSX container file.
From Wikipedia: The Open Packaging Conventions (OPC) is a container-file technology initially created by Microsoft to store a combination
of XML and non-XML files that together form a single entity such as an Open XML Paper Specification (OpenXPS) document.
<http://en.wikipedia.org/wiki/Open_Packaging_Conventions>.
At its simplest an Excel XLSX file contains the following elements:
____ [Content_Types].xml
|
|____ docProps
| |____ app.xml
| |____ core.xml
|
|____ xl
| |____ workbook.xml
| |____ worksheets
| | |____ sheet1.xml
| |
| |____ styles.xml
| |
| |____ theme
| | |____ theme1.xml
| |
| |_____rels
| |____ workbook.xml.rels
|
|_____rels
|____ .rels
The "Excel::Writer::XLSX::Package::Packager" class co-ordinates the classes that represent the elements of the package and writes them into
the XLSX file.
AUTHOR
John McNamara jmcnamara@cpan.org
COPYRIGHT
X MM-MMXII, John McNamara.
All Rights Reserved. This module is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.
LICENSE
Either the Perl Artistic Licence <http://dev.perl.org/licenses/artistic.html> or the GPL
<http://www.opensource.org/licenses/gpl-license.php>.
DISCLAIMER OF WARRANTY
See the documentation for Excel::Writer::XLSX.
perl v5.10.1 2012-04-02 Excel::Writer::XLSX::Package::Packager(3pm)