Copying data from excel file Post: 302283886

8 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

how to copy data to to excel file

Hi, Can any one tell me how to copy data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column. Say my text file data is: 15-dec-2008 15-dec-2009 16-dec-2008 16-dec-2009 ...

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

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

5. Shell Programming and Scripting

Shell Script for copying text file to Excel Sheet

Hi, I want to write a program to copy a log file to Excel sheet. Excel sheet has four columns MethodName , Code , Description, Details and Time. I want to pick these info from text file and put it in excel sheet. here is how the text file looks - 04.17.2014 08:06:12,697...

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

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

8. Shell Programming and Scripting

Formatting data to put it in the excel file

Hello, I have a file with the below contents : Policy Name: Backup_bkp Policy Type: Catalog_bkp Active: yes Effective date: 08/07/2013 02:02:12 Mult. Data Streams: no Client Encrypt: no Checkpoint: no Policy Priority: ...

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)