Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: two csv file in an excel file in two tabs
Top Forums UNIX for Dummies Questions & Answers two csv file in an excel file in two tabs Post 302284109 by curleb on Wednesday 4th of February 2009 09:01:13 PM
Old 02-04-2009
just as an FYI...the Spreadsheet::WriteExcel module works great...albeit only on my ActiveState version of Perl thus far. I intend to port it to a UNIX build soon, but haven't gotten it there just yet; base install of Perl out of sync with the repository I've got access to, etc. [sigh] But the output file is fully portable, so it shouldn't matter the source system.

I'll say it has even made me a better Excel VBA user too since the tweaking required some additional efforts in understanding the object model...(not that I'd admit that in public, but...oh wait...)
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

text file to excel or csv

Hi, I have a text file like ---------------------- aaa|bbb|ccc|ddd|eee fff|gggg|hhhhhh|kkkk -------------------- I have a script which will transfer(thourgh FTP) this text file to windows system. But I want to covert it into excel or CSF then upload into windows system.. thanks (9 Replies)
Discussion started by: srikanthus2002
9 Replies

2. UNIX for Advanced & Expert Users

Problem in converting password protected excel file to csv file in unix

I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner. I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
2 Replies

3. Shell Programming and Scripting

How to convert a excel file to a .csv file from unix script

Hi I have a excel file in unix machine and have to convert it into a .csv file.I have to do this from a unix script.How do we do this? Thanks Abhinav (3 Replies)
Discussion started by: akashtcs
3 Replies

4. UNIX for Dummies Questions & Answers

Excel File to CSV

Hi All, I have to convert the excel file which will be placed in the Unix box to a CSV file using a shell script. Please Advise. Thanks & Regards, Kumar66 (1 Reply)
Discussion started by: kumar66
1 Replies

5. Shell Programming and Scripting

csv file to excel file with shellscripting

Hi all, Please help me out How to write a shell script which converts abc.csv file into abc.xls example file abc.csv AP_RQ_ID,TXN_IER,AP_RS_RESP_CD,TXN_CNT,TOTAL_AMT 60000002,ACTIVATION,00,490,14657.52 60000002,ACTIVATION,08,1,100 This needs to be converted into excel format using a... (3 Replies)
Discussion started by: dudd9
3 Replies

6. Shell Programming and Scripting

csv file to excel issue

Hi, I am trying to attach and email a csv file in the form of an excel sheet. And I have been successful in doing this. But after some days I realised that some fields in the csv file are also having commas because of which this field is getting splitted in columns in the excel sheet. ... (5 Replies)
Discussion started by: girish1428
5 Replies

7. Shell Programming and Scripting

Conversion of below Tabs Tex file into CSV format file : shell script needed

Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given Name Domain Contact Phone Email Location ----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
Discussion started by: sreenath1037
7 Replies

8. Shell Programming and Scripting

How to print excel file / csv file in solaris server ?

Hi, I have to print a excel file in solaris server. I am using lexmark printer with post script printer driver . But the problem is when i am using " lp -d <printer name> <somefile name.xls>" command it is not printing correctly. but for pdf file using the same command it printing correctly. ... (2 Replies)
Discussion started by: Sambuddha
2 Replies

9. Shell Programming and Scripting

Converting specific Excel file tabs to CSV in Python

Hi list, This is probably something really simple, but I am not particularly familiar with Python so I thought I would ask as I know that python has an excel module. I have an excel document with multiple tabs of data and graphs. One of the tabs is just data which I require to have dumped to... (8 Replies)
Discussion started by: landossa
8 Replies

10. Shell Programming and Scripting

How to convert excel file to csv file or text file?

Hi all, I need to find a way to convert excel file into csv or a text file in linux command. The reason is I have hundreds of files to convert. Another complication is the I need to delete the first 5 lines of the excel file before conversion. so for instance input.xls description of... (6 Replies)
Discussion started by: johnkim0806
6 Replies

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)
All times are GMT -4. The time now is 02:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy