10-08-2007
If you "cat" an .xls file, you will notice that unix understand it as binary file, and you won't see relevant content. Instead, you can rely on "
comma separated value format" and alter such file. Otherwise, you can use Excel's macros, thus putting yourself in need of writing on Visual basic.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello,
Our group is just starting to get into UNIX here. We are former REXX users on a VM Mainframe. Can someone point me to the documentation to read a file and write a file in a Unix Shell Script or does this have to be done in another language?
Thank you in advance...
Dave (3 Replies)
Discussion started by: tracydp
3 Replies
2. Shell Programming and Scripting
Is it possible to read from or write to sockets with ksh?
I use AIX 5.3 (1 Reply)
Discussion started by: rein
1 Replies
3. Shell Programming and Scripting
Hi all
I am new to shell scripting.
I need to write a shell script that reads each row of an USER_ID colume in a excel file.
the excel has around 10000 rows of data.
Can someone gives me some example or advice what's best way to do this
thanks (11 Replies)
Discussion started by: tiger99
11 Replies
4. Programming
Hello everybody,
I'm trying to code a program which makes the following:
It sends an ARP request frame and when it gets the reply, extracts the IP address of source and writes it to a .txt file. This is gonna be done with many hosts (with a for() loop), so, the text file would look like... (2 Replies)
Discussion started by: Zykl0n-B
2 Replies
5. Programming
Hi,
I have a requirement where users will send excel(.xls) file to Linux Platform using ftp/sftp. After that the excel file needs to be read using java on linux and converted into csv.
I am using jxl to parse the excel, but few character like £ are not getting parsed properly. If i open the... (0 Replies)
Discussion started by: joy_bt
0 Replies
6. Shell Programming and Scripting
Hi All,
Here is my requirement. I am grepping through the log files and cutting some fields from the file to generate a csv file. Now I have to check if 2nd field is having some fixed value then with the help of 4th field I have to look in same log and run another grep command to retrieve the... (11 Replies)
Discussion started by: kmajumder
11 Replies
7. Shell Programming and Scripting
There is a perl scriptwhich will read Excel sheet and create one file(.v) .
Excel sheet:::
A B C D
1 cpu_dailog 2 3 4
Perl will create the file(.v) like thsi :::
assert (cpu_dailog_iso ==2) ;
assert (cpu_dailog_reset ==3);
assert (cpu_dailog_idle... (3 Replies)
Discussion started by: naaj_ila
3 Replies
8. Shell Programming and Scripting
I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix
But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed.
What to do...Please... (7 Replies)
Discussion started by: mud_born
7 Replies
9. Shell Programming and Scripting
Hello,
I'm trying to write a script to export a txt file to excel. The text file is a delimited with commas
Example:
Report Date,12/12/2014
Report By, Person
Issue, Job Failed
I tried exporting as csv and mailed to my id. But if I open the csv file the data is coming in single... (6 Replies)
Discussion started by: annamalaikasi
6 Replies
10. Shell Programming and Scripting
Hi all.
I am working on the below requirement of generating .xml file from .xls file which i have , can someone please help me or in writing the perl script for the same:
The xls file format is as below which has two columns and number of rows are not fixed:
Fixlet Name ... (12 Replies)
Discussion started by: omkar.jadhav
12 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)