Reading and Writing from Excel using Unix scripting Post: 302144645

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Reading and Writing Files ?

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

2. Shell Programming and Scripting

reading/ writing to sockets

Is it possible to read from or write to sockets with ksh? I use AIX 5.3

3. Shell Programming and Scripting

reading data from excel using shell script

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

4. Programming

I need help with file reading/writing in C

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

5. Programming

Excel reading on Linux using Java

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

6. Shell Programming and Scripting

Reading and writing in same file

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

7. Shell Programming and Scripting

Perl Reading Excel sheet isssue

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

8. Shell Programming and Scripting

Writing excel file using perl : Excel file formatting changed

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

9. Shell Programming and Scripting

Writing in excel sheet using ksh

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

10. Shell Programming and Scripting

Writing xml from excel sheet .xls using perl script

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

LEARN ABOUT DEBIAN

excel::template::container::keepleadingzeros

Excel::Template::Container::KeepLeadingZeros(3pm)	User Contributed Perl Documentation	 Excel::Template::Container::KeepLeadingZeros(3pm)

NAME

       Excel::Template::Container::KeepLeadingZeros - Excel::Template::Container::KeepLeadingZeros

PURPOSE

       To set the keep_leading_zeros flag for the surrounding worksheet or any worksheets that might be contained within this node.

NODE NAME

       KEEP_LEADING_ZEROS

INHERITANCE

       CONTAINER

ATTRIBUTES

       None

CHILDREN

       None

EFFECTS

       Alters how leading zeros are interpreted by Spreadsheet::WriteExcel.

DEPENDENCIES

       None

USAGE

	 <worksheet>
	   ... Cells here will NOT have leading-zeros preserved
	   <keep_leading_zeros>
	     ... Cells here will have leading-zeros preserved
	   </keep_leading_zeros>
	   ... Cells here will NOT have leading-zeros preserved
	 </worksheet>

	 <keep_leading_zeros>
	   <worksheet>
	     ... Cells here will have leading-zeros preserved
	   </worksheet>
	   <worksheet>
	     ... Cells here will have leading-zeros preserved
	   </worksheet>
	 </keep_leading_zeros>

AUTHOR

       Rob Kinyon (rob.kinyon@gmail.com)

SEE ALSO

       CELL, Spreadsheet::WriteExcel

perl v5.14.2							    2010-06-17			 Excel::Template::Container::KeepLeadingZeros(3pm)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Reading and Writing Files ?

Discussion started by: tracydp

2. Shell Programming and Scripting

reading/ writing to sockets

Discussion started by: rein

3. Shell Programming and Scripting

reading data from excel using shell script

Discussion started by: tiger99

4. Programming

I need help with file reading/writing in C

Discussion started by: Zykl0n-B