Convert excel to tab Post: 302998388

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert to excel

Hi to all the tycoons of Shell programming!! I am getting a csv report out of a query and the report is delimited with '|' symbol. I would like to convert this csv report into an xls column wise.. Let me show u an example as below Say a.csv looks like below Number|Description|Cycle|Date...

2. Shell Programming and Scripting

Convert each field to excel

Hi Folks!! I would like to convert each and every output of my query to the excel column wise. Let me give you an example The first attachment (cr.jpg) is the one which i am getting out of a query and the fields are delimited with a '|' (pipe) symbol. I would like to convert each field into a...

3. Shell Programming and Scripting

convert new line to tab

hey i m newbie i dont know whether this is happining in my terminal or is there any reason behind this here it is when i do 1.) sed -n 's/\t/\n/gp' space > enter #where space is tab seperated file it works fine it give me a outupt that all tab seperated convert into column but when i...

4. Shell Programming and Scripting

Convert MS Excel file to Tab limiter file in UNIX

Hi, We have a couple of ms excel files in unix server.We need convert the excel files to files TAB limiter format file with using unix script. Could you please advise on this

5. Shell Programming and Scripting

Adding Tab to excel Sheet

Hi, I have 2 sets of data in two different files,say f1 and f2. I want to create a excel sheet with two tabs whose names will be set at run time(different from excel name) in a shell script, and the data will be written into those two tabs at run time.Any command in UNIX doing so? I am...

6. Shell Programming and Scripting

Shell script - Excel/CSV file - More than one tab

Hi All, Following is my requirement. I have searched the site and found some threads which has same queries, but non of them have any answer. I thought of posting it once more. We are generating different reports through shell script after we finish our data load. Currently there are 7 such...

7. UNIX for Dummies Questions & Answers

Convert csv to excel

Hi All, I have a csv file in unix and I need to convert it into excel formate. Please help me out

8. Shell Programming and Scripting

Adding tab to excel sheet with shell script

9. UNIX for Beginners Questions & Answers

Convert Excel File (xls) to tab delimited text file on AIX

Hi i have a problem in my job i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand cat xxx.xls > xxx.txt Do you have eny idea? PS: sorry for my english Thanks!!

10. Shell Programming and Scripting

Trouble reading from a tab delimited excel file

So I have a file1.txt that is tab delimited: e.g. FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 9545641 123 "Neighbor and Labrador,Canada" 54895 'CANADA' 9456465 456 "Neighbor and Labrador,Canada" 54893 'CANADA' 8746512 789 "Neighbor and...

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)