how to copy data to to excel file Post: 302271918

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help on email data file as excel from unix!!

Hi, I need to email a data in excel sheet from unix using shell scripting.I could able to generate the data file with tab delimiter with extension .xls could able to email it. The problem is when a coulmn with 16 digit number is exported, it is showing in scientific format. Any help in...

2. Shell Programming and Scripting

Copying data from excel file

Hii friends, I am a newbie to unix/shell scripting and got stuck in implementing a functionality.Dear experts,kindly spare some time to bring me out of dark pit :confused:.. My requirement is somewhat wierd,let me explain what i have and what i need to do... 1) there are several excel...

3. Shell Programming and Scripting

store the table data in excel file

Hello - I have a below table and i want to extract the data into excel sheet and send to different location. Here is the table structure... SQL> desc t_i1_exportdocs Name Null? Type ----------------------------------------- --------...

4. Shell Programming and Scripting

Sample ksh script for copy the data from excel to database table ?

Hi All, I need to convert the data from excel to database table in sybase. Please provide some sample script.. thanks, Royal.

5. Shell Programming and Scripting

urgent<parsing data from a excel file>

Hi all, I wud like to get ur assistance in retrieving lines containing l1.My excel dataset contains around 8000 lines.I converted it into a text tab delimiter file and got the lines containing l1,My output is a list of lines containing l1 saved in a outfile.Some of d lines from my outfile s...

6. Shell Programming and Scripting

Copy Data from CSV file to Excel Sheet using Perl

Hi All, Firstly I will like to wish A Happy New Year to all. Now my issue is I have one csv file say(data.csv) and one excel file say(result.xls) The result.xls contains two sheet name Sheet1 and Sheet2, Now What I am trying to do is to First I want to delete that data of Sheet2 if present any,...

7. Windows & DOS: Issues & Discussions

How to copy a file with long records ,i.e spanning to 2 or 3 lines from UNIX to excel?

Hi Experts, I have a Unix csv file which has long records ie the record length is more than 80 so it goes to the next line.So when its in unix though it spans to two or three lines it still counts it as one record. But what is happening is for the records that are long when i copy it into excel i...

8. Shell Programming and Scripting

Data formatting in CSV file to EXCEL

Hello friends I want to convert an csv file on unix (which is generated by a ETL application) to a formatted excel sheet like .I have roughly like 28 columns 1)All numbers need to be stored as numbers with leading zeros-like format as text for this column to preserve leading zeroes e.g...

9. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM...

10. UNIX for Beginners Questions & Answers

Copy txt file into excel vbscript

Hi everybody, I am working on Windows 10 and using cygwin. I have a vbscript as follows: Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True Set wb1 = objExcel.Workbooks.open("\\files\share\path\file1.xlsx") wb1.Worksheets("Sheet1").Range("A1:CR89").Clear Set...

LEARN ABOUT MOJAVE

datetime::locale::nl

DateTime::Locale::nl(3) 				User Contributed Perl Documentation				   DateTime::Locale::nl(3)

NAME

       DateTime::Locale::nl

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'nl' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Dutch.

DATA

       This locale inherits from the DateTime::Locale::root locale.

       It contains the following data.

   Days
       Wide (format)

	 maandag
	 dinsdag
	 woensdag
	 donderdag
	 vrijdag
	 zaterdag
	 zondag

       Abbreviated (format)

	 ma
	 di
	 wo
	 do
	 vr
	 za
	 zo

       Narrow (format)

	 M
	 D
	 W
	 D
	 V
	 Z
	 Z

       Wide (stand-alone)

	 maandag
	 dinsdag
	 woensdag
	 donderdag
	 vrijdag
	 zaterdag
	 zondag

       Abbreviated (stand-alone)

	 ma
	 di
	 wo
	 do
	 vr
	 za
	 zo

       Narrow (stand-alone)

	 M
	 D
	 W
	 D
	 V
	 Z
	 Z

   Months
       Wide (format)

	 januari
	 februari
	 maart
	 april
	 mei
	 juni
	 juli
	 augustus
	 september
	 oktober
	 november
	 december

       Abbreviated (format)

	 jan.
	 feb.
	 mrt.
	 apr.
	 mei
	 jun.
	 jul.
	 aug.
	 sep.
	 okt.
	 nov.
	 dec.

       Narrow (format)

	 J
	 F
	 M
	 A
	 M
	 J
	 J
	 A
	 S
	 O
	 N
	 D

       Wide (stand-alone)

	 januari
	 februari
	 maart
	 april
	 mei
	 juni
	 juli
	 augustus
	 september
	 oktober
	 november
	 december

       Abbreviated (stand-alone)

	 jan.
	 feb.
	 mrt.
	 apr.
	 mei
	 jun.
	 jul.
	 aug.
	 sep.
	 okt.
	 nov.
	 dec.

       Narrow (stand-alone)

	 J
	 F
	 M
	 A
	 M
	 J
	 J
	 A
	 S
	 O
	 N
	 D

   Quarters
       Wide (format)

	 1e kwartaal
	 2e kwartaal
	 3e kwartaal
	 4e kwartaal

       Abbreviated (format)

	 K1
	 K2
	 K3
	 K4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 1e kwartaal
	 2e kwartaal
	 3e kwartaal
	 4e kwartaal

       Abbreviated (stand-alone)

	 K1
	 K2
	 K3
	 K4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 Voor Christus
	 Anno Domini

       Abbreviated

	 v. Chr.
	 n. Chr.

       Narrow

	 v. Chr.
	 n. Chr.

   Date Formats
       Full

	  2008-02-05T18:30:30 = dinsdag 5 februari 2008
	  1995-12-22T09:05:02 = vrijdag 22 december 1995
	 -0010-09-15T04:44:23 = zaterdag 15 september -10

       Long

	  2008-02-05T18:30:30 = 5 februari 2008
	  1995-12-22T09:05:02 = 22 december 1995
	 -0010-09-15T04:44:23 = 15 september -10

       Medium

	  2008-02-05T18:30:30 = 5 feb. 2008
	  1995-12-22T09:05:02 = 22 dec. 1995
	 -0010-09-15T04:44:23 = 15 sep. -10

       Short

	  2008-02-05T18:30:30 = 05-02-08
	  1995-12-22T09:05:02 = 22-12-95
	 -0010-09-15T04:44:23 = 15-09--10

       Default

	  2008-02-05T18:30:30 = 5 feb. 2008
	  1995-12-22T09:05:02 = 22 dec. 1995
	 -0010-09-15T04:44:23 = 15 sep. -10

   Time Formats
       Full

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

       Short

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 09:05
	 -0010-09-15T04:44:23 = 04:44

       Default

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = dinsdag 5 februari 2008 18:30:30 UTC
	  1995-12-22T09:05:02 = vrijdag 22 december 1995 09:05:02 UTC
	 -0010-09-15T04:44:23 = zaterdag 15 september -10 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 5 februari 2008 18:30:30 UTC
	  1995-12-22T09:05:02 = 22 december 1995 09:05:02 UTC
	 -0010-09-15T04:44:23 = 15 september -10 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 5 feb. 2008 18:30:30
	  1995-12-22T09:05:02 = 22 dec. 1995 09:05:02
	 -0010-09-15T04:44:23 = 15 sep. -10 04:44:23

       Short

	  2008-02-05T18:30:30 = 05-02-08 18:30
	  1995-12-22T09:05:02 = 22-12-95 09:05
	 -0010-09-15T04:44:23 = 15-09--10 04:44

       Default

	  2008-02-05T18:30:30 = 5 feb. 2008 18:30:30
	  1995-12-22T09:05:02 = 22 dec. 1995 09:05:02
	 -0010-09-15T04:44:23 = 15 sep. -10 04:44:23

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 di
	  1995-12-22T09:05:02 = 22 vr
	 -0010-09-15T04:44:23 = 15 za

       Hm (HH:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 09:05
	 -0010-09-15T04:44:23 = 04:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 PM
	  1995-12-22T09:05:02 = 9:05 AM
	 -0010-09-15T04:44:23 = 4:44 AM

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 PM
	  1995-12-22T09:05:02 = 9:05:02 AM
	 -0010-09-15T04:44:23 = 4:44:23 AM

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (d-M)

	  2008-02-05T18:30:30 = 5-2
	  1995-12-22T09:05:02 = 22-12
	 -0010-09-15T04:44:23 = 15-9

       MEd (E d-M)

	  2008-02-05T18:30:30 = di 5-2
	  1995-12-22T09:05:02 = vr 22-12
	 -0010-09-15T04:44:23 = za 15-9

       MMd (d-MM)

	  2008-02-05T18:30:30 = 5-02
	  1995-12-22T09:05:02 = 22-12
	 -0010-09-15T04:44:23 = 15-09

       MMdd (dd-MM)

	  2008-02-05T18:30:30 = 05-02
	  1995-12-22T09:05:02 = 22-12
	 -0010-09-15T04:44:23 = 15-09

       MMM (LLL)

	  2008-02-05T18:30:30 = feb.
	  1995-12-22T09:05:02 = dec.
	 -0010-09-15T04:44:23 = sep.

       MMMd (d-MMM)

	  2008-02-05T18:30:30 = 5-feb.
	  1995-12-22T09:05:02 = 22-dec.
	 -0010-09-15T04:44:23 = 15-sep.

       MMMEd (E d MMM)

	  2008-02-05T18:30:30 = di 5 feb.
	  1995-12-22T09:05:02 = vr 22 dec.
	 -0010-09-15T04:44:23 = za 15 sep.

       MMMMd (d MMMM)

	  2008-02-05T18:30:30 = 5 februari
	  1995-12-22T09:05:02 = 22 december
	 -0010-09-15T04:44:23 = 15 september

       MMMMEd (E d MMMM)

	  2008-02-05T18:30:30 = di 5 februari
	  1995-12-22T09:05:02 = vr 22 december
	 -0010-09-15T04:44:23 = za 15 september

       mmss (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (M-yyyy)

	  2008-02-05T18:30:30 = 2-2008
	  1995-12-22T09:05:02 = 12-1995
	 -0010-09-15T04:44:23 = 9--010

       yMEd (EEE d-M-yyyy)

	  2008-02-05T18:30:30 = di 5-2-2008
	  1995-12-22T09:05:02 = vr 22-12-1995
	 -0010-09-15T04:44:23 = za 15-9--010

       yMMM (MMM y)

	  2008-02-05T18:30:30 = feb. 2008
	  1995-12-22T09:05:02 = dec. 1995
	 -0010-09-15T04:44:23 = sep. -10

       yMMMEd (EEE d MMM y)

	  2008-02-05T18:30:30 = di 5 feb. 2008
	  1995-12-22T09:05:02 = vr 22 dec. 1995
	 -0010-09-15T04:44:23 = za 15 sep. -10

       yMMMM (MMMM y)

	  2008-02-05T18:30:30 = februari 2008
	  1995-12-22T09:05:02 = december 1995
	 -0010-09-15T04:44:23 = september -10

       yQ (Q yyyy)

	  2008-02-05T18:30:30 = 1 2008
	  1995-12-22T09:05:02 = 4 1995
	 -0010-09-15T04:44:23 = 3 -010

       yQQQ (QQQ y)

	  2008-02-05T18:30:30 = K1 2008
	  1995-12-22T09:05:02 = K4 1995
	 -0010-09-15T04:44:23 = K3 -10

       yyMM (MM-yy)

	  2008-02-05T18:30:30 = 02-08
	  1995-12-22T09:05:02 = 12-95
	 -0010-09-15T04:44:23 = 09--10

       yyMMM (MMM yy)

	  2008-02-05T18:30:30 = feb. 08
	  1995-12-22T09:05:02 = dec. 95
	 -0010-09-15T04:44:23 = sep. -10

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

       yyQQQQ (QQQQ yy)

	  2008-02-05T18:30:30 = 1e kwartaal 08
	  1995-12-22T09:05:02 = 4e kwartaal 95
	 -0010-09-15T04:44:23 = 3e kwartaal -10

       yyyyMMMM (MMMM y)

	  2008-02-05T18:30:30 = februari 2008
	  1995-12-22T09:05:02 = december 1995
	 -0010-09-15T04:44:23 = september -10

   Miscellaneous
       Prefers 24 hour time?

       Yes

       Local first day of the week

       maandag

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.18.2							    2017-10-06						   DateTime::Locale::nl(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help on email data file as excel from unix!!

Discussion started by: sparan_peddu

2. Shell Programming and Scripting

Copying data from excel file

Discussion started by: 5ahen

3. Shell Programming and Scripting

store the table data in excel file

Discussion started by: govindts

4. Shell Programming and Scripting

Sample ksh script for copy the data from excel to database table ?

Discussion started by: royal9482