Excel sheet modification using perl module


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Excel sheet modification using perl module
# 1  
Old 12-29-2011
Excel sheet modification using perl module

HTML Code:
I need to insert new column to already existing file ..can any one help me..??
# 2  
Old 12-29-2011
Searched this site and found some good examples.
I don't have 5 posts, which surprises me, so I can't post a URL here.

Do a search and you may find the answer before asking the same question.

Good luck.
# 3  
Old 01-03-2012
excel sheet modification

HTML Code:
Hi I got idea that how to insert column using perl?....
1]. I store the content from spreadsheet to 1D array using "push" ?
2].After that i am planning to write the content to new Excel sheet.

Actually content stored in push is in 1D array format.Do you have any idea how to write that as 2D array format?

For Example ..

content of array is :
  name mark percentage 616 100 0 0 0 0 616 100    

The above content should be stored as below...............

   	 	 	 	 	body, div, table, thead, tbody, tfoot, tr, th, td, p { font-family: "Arial"; font-size: x-small; } 	   	 	 		 			name 			 		 			mark 			Percentage 		 		 			616 			100 		 		 			0 			0 		 		 			0 			0 		 		 			616 			100 		 	  
   	 	 	 	 	body, div, table, thead, tbody, tfoot, tr, th, td, p { font-family: "Arial"; font-size: x-small; }Thanks in advance..

Can any one help me???:confused:
---------- Post updated at 06:55 AM ---------- Previous update was at 06:47 AM ----------

HTML Code:
Hi I got idea that how to insert column using perl?....
1]. I store the content from spreadsheet to 1D array using "push" ?
2].After that i am planning to write the content to new Excel sheet.

Actually content stored in push is in 1D array format.Do you have any idea how to write that as 2D array format?

For Example ..

content of array is :
  name mark percentage 616 100 0 0 0 0 616 100    

The above content should be stored as below...............[TABLE]

   	 	 	 	 	body, div, table, thead, tbody, tfoot, tr, th, td, p { font-family: "Arial"; font-size: x-small; } 	   	 	 		 			name 			 		 			mark 			Percentage 		 		 			616 			100 		 		 			0 			0 		 		 			0 			0 		 		 			616 			100 		 	  [/TABLE]
   	 	 	 	 	body, div, table, thead, tbody, tfoot, tr, th, td, p { font-family: "Arial"; font-size: x-small; }Thanks in advance..

Can any one help me???:confused:
# 4  
Old 01-04-2012
Quote:
Originally Posted by kavi.mogu
...Actually content stored in push is in 1D array format.Do you have any idea how to write that as 2D array format?
...
If every element of an array is a reference to another array, then you'll have a two-dimensional array. Check out the documentation on references.

tyler_durden
# 5  
Old 01-04-2012
excel sheet modification

HTML Code:
Hi thank u  for you reply..I am new to perl...
can you tell the "website" names..In previous mail you mention docment know...which documnet i have to refer?
# 6  
Old 01-04-2012
Online Perl documentation:

Perl programming documentation - perldoc.perl.org

tyler_durden
# 7  
Old 01-05-2012
Excel sheet modification using perl module

HTML Code:
thank you....
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Summing up the data from different excel sheet into one excel sheet

Hi Folks, Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are 1excel.xslx 2excel.xslx 3excel.xslx now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies

2. Shell Programming and Scripting

Perl : to get all the hyperlinks from the xlsx sheet(hyperlinks not visible in excel sheet directly)

Hi folks, I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx). Spreadsheet contains few lines of hyperlink data (pic attached). P.S. Hyperlink is behind the data and not visible in excel sheet directly. Now using perl script I need to copy the hyperlinks in... (3 Replies)
Discussion started by: scriptscript
3 Replies

3. 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... (3 Replies)
Discussion started by: naaj_ila
3 Replies

4. Shell Programming and Scripting

Perl :Is it possible to read the excel 2007 sheet on unix machine using spredsheet::xlsx module

I have an Excel 2007 excel sheet on windows machine and using Spreadsheet::XLSX I had written a script to read the excel sheet and was successful. My requirement is I need to generate another excel sheet from the old excel 2007 sheet on unix machine. Now is it possible to read the excel... (2 Replies)
Discussion started by: giridhar276
2 Replies

5. Shell Programming and Scripting

Perl : Deleting the records in the excel sheet

I have a excel sheet with contains the records as below.. also uploaded the input excelsheet and the output excel sheet(expected output). 322mpls32.net.xyz.comBW: 44.0 M Hrly Avg (IN /... (1 Reply)
Discussion started by: giridhar276
1 Replies

6. Shell Programming and Scripting

Perl : not capturing all the data from excel sheet

Hi folks, I am working on assignment that captures all the records(2 columns one column contains names and other contain date of birth) from excel sheet stored in a directory and checks for current date and month. If it matches current date and month then the matched records are printed as... (1 Reply)
Discussion started by: giridhar276
1 Replies

7. Programming

Excel sheet modification using perl module

Hi , can any one tell me,"How to extract the same format from existing excel file to new excel file " using Spreadsheet::WriteExcel or Spreadsheet::ParseExcel module ??? Example_pgm: Below program is used to read existing excel file..In this program "my $cell = $_;" line is used to... (0 Replies)
Discussion started by: kavi.mogu
0 Replies

8. Shell Programming and Scripting

Excel sheet modification using perl module

Hi , Is there any possibility to read excel sheet in column by column order ?...Thanks in advance,........ :confused: (1 Reply)
Discussion started by: kavi.mogu
1 Replies

9. Shell Programming and Scripting

Excel sheet modification using perl module

Is there any possibility to move the content from one cell to another cell (Excel sheet) using perl module? (3 Replies)
Discussion started by: kavi.mogu
3 Replies

10. Shell Programming and Scripting

How to change cell background in excel sheet using perl

I need to change a cell in an excel sheet to different background color using perl.I tried SaveParse, but was unable to get it Please help regarding this. Thanks and Regards, Neelam G https://www.unix.com/images/misc/progress.gif (0 Replies)
Discussion started by: gujrathinr
0 Replies
Login or Register to Ask a Question