Need help to write a shell script to convert text file to excel file. Post: 302957497

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to convert fields from a text file to excel columns

i have this file which has the following contents: ,-0.3000 ,-0.3000 ,-0.3000 ,-0.9000 ,-0.9000 ,-0.9000 i would like to get this: -0.3-0.9-0.3-0.9-0.3-0.9 so far i am trying: awk '{for(i=1; i<=NF; i++) {printf("%f\n",$i)}}' test1 > test2 any help...

2. Shell Programming and Scripting

a shell script to generate an excel sheet from a text file..

hi, i have a text file that looks like this! i want to generate an excel sheet out of it, removing all the junk data except the addresses that look like . Arrow Electrical Services Rotating Machinery, Electrical Contracting & Mining Specialists Onsite maintenance, breakdown...

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

4. Shell Programming and Scripting

Need help on inserting data from text file to excel using shell script

Hi, Please help me on this. I want to insert data from text file to excel using shell script nawk -v r=4 -v c=4 -v val=$a -F, 'BEGIN{OFS=","}; NR != r; NR == r {$c = val; print}' "file.csv" I used above one to insert $a value in 4th row, 4th column in an excel file.csv and it...

5. Shell Programming and Scripting

How to write text file data to excel using UNIX shell script?

Hi All, I have the requirement in unix shell script. I want to write the "ls -ltr" command out put to excel file as below. Input :text file data : drwxr-xr-x 5 root root 4096 Oct 2 12:26 drwxr-xr-x 2 apx aim 4096 Nov 29 18:40 drwxr-xr-x 5 root root 4096 Oct 2 12:26 drwxr-xr-x...

6. Shell Programming and Scripting

Convert excel file to PDF file using shell script

Hi All, Is it possible to convert the excel file to PDF file(Without loosing any format) using unix shell scripting ??? If yes Kindly help me on the code Thanks in advance!!!

7. Shell Programming and Scripting

Shell Script for copying text file to Excel Sheet

Hi, I want to write a program to copy a log file to Excel sheet. Excel sheet has four columns MethodName , Code , Description, Details and Time. I want to pick these info from text file and put it in excel sheet. here is how the text file looks - 04.17.2014 08:06:12,697...

8. Shell Programming and Scripting

Need to convert delimited text file in UNIX to an Excel file

Dear Users , Need to convert delimited text files in UNix server to an Excel file and move the excel file to Windows environment. Am trying to automate the whole process. Can anyone share the ideas,if they have done similar ones before...Thanks -Meera

9. Shell Programming and Scripting

Need to convert text file into Excel sheet

:cool:Hi, Iam new to this Scripts and forum too. Plz excuse if may i ask silly questions now and further.. Prob: i need to convert txt files data into excel sheet. Suppose if i have hour-wise data in txt file1 and file2 like file1 file2 00: 140 00: 235 01: 160 01:415...

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

LEARN ABOUT OPENSOLARIS

ppmtopj

ppmtopj(1)                                                    General Commands Manual                                                   ppmtopj(1)

NAME

       ppmtopj - convert a portable pixmap to an HP PaintJet file

SYNOPSIS

       ppmtopj  [-gamma  val]  [-xpos val] [-ypos val] [-back dark|lite] [-rle] [-center] [-render none|snap|bw|dither|diffuse|monodither|monodif-
       fuse|clusterdither|monoclusterdither] [ppmfile]

DESCRIPTION

       Reads a portable pixmap as input and converts it into a format suitable to be printed by an HP PaintJet printer.

       For best results, the input file should be in 8-color RGB form; i.e. it should have only the 8 binary combinations of full-on and  full-off
       primaries.  You could get this by sending the input file through ppmquant -map with a map file such as:
           P3
           8 1
           255
           0 0 0      255 0 0    0 255 0    0 0 255
           255 255 0  255 0 255  0 255 255  255 255 255
       Or else you could use use ppmdither -red 2 -green 2 -blue 2.

OPTIONS

       -rle          Run length encode the image.  (This can result in larger images)

       -back         Enhance the foreground by indicating if the background is light or dark compated to the foreground.

       -render alg   Use an internal rendering algorithm (default dither).

       -gamma int    Gamma correct the image using the integet parameter as a gamma (default 0).

       -center       Center the image to an 8.5 by 11 page

       -xpos pos     Move by pos pixels in the x direction.

       -ypos pos     Move by pos pixels in the y direction.

REFERENCES

       HP PaintJet XL Color Graphics Printer User's Guide

SEE ALSO

       pnmdepth(1), ppmquant(1), ppmdither(1), ppm(5)

BUGS

       Most of the options have not been tested because of the price of the paper.

AUTHOR

       Copyright (C) 1991 by Christos Zoulas.

                                                                   13 July 1991                                                         ppmtopj(1)