Sponsored Content
Full Discussion: Excel formatting
Top Forums Shell Programming and Scripting Excel formatting Post 302373309 by ggs on Friday 20th of November 2009 02:32:05 AM
Old 11-20-2009
In excel, you have the "TRANSPOSE" function to shift the vertical/horizontal orientation.
 

10 More Discussions You Might Find Interesting

1. Filesystems, Disks and Memory

Formatting excel file

Hi, I have a problem in formatting the excel file from my script. Assume that there is a text file generated using a 'C shell Unix script' with a format similar to the one seen below. Each column has a fixed length and every row is going to have a value against a column depending on the... (1 Reply)
Discussion started by: subra
1 Replies

2. Shell Programming and Scripting

PERL: Split Excel Workbook to Indiv Excel files

Hi, I am trying to find a way to read an excel work book with multiple worksheets. And write each worksheet into a new excel file using perl. My environment is Unix. For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies

3. Shell Programming and Scripting

PERL: Modify Excel cell formatting

Hi, I would like to modify an existing excel cell format to a custom format. Is there a way to do it with out writing into a new excel file. In-place editing? Thanks (0 Replies)
Discussion started by: sandeep78
0 Replies

4. Shell Programming and Scripting

Problem in formatting output of SQL query in excel sheet in shell script

Hi Guys.. Need your help to format the output of my shell script. I am using spool command to take out put in csv file. below is my code. (for example) col USERNAME for a15 col EMAIL for a30 col FULL_NAME for a20 col LAST_LOGIN for a40 col DATE_CREATED for a40 SPOOL 120.csv... (3 Replies)
Discussion started by: Agupte
3 Replies

5. Shell Programming and Scripting

Formatting Shell script output to Excel

I am facing a problem formatting the output of my shell script in excel. We are directing the output of the script to an excel sheet and need long integer type data printed in Excel as it is (i.e. not in the default scientific notation). Also, leading zeroes(if any) in the output are getting... (4 Replies)
Discussion started by: bornali.p
4 Replies

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

7. Shell Programming and Scripting

Perl script to Merge contents of 2 different excel files in a single excel file

All, I have an excel sheet Excel1.xls that has some entries. I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls These may be in different workbooks. They are totally independent made by 2 different users. I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies

8. Shell Programming and Scripting

Data formatting in CSV file to EXCEL

Hello friends I want to convert an csv file on unix (which is generated by a ETL application) to a formatted excel sheet like .I have roughly like 28 columns 1)All numbers need to be stored as numbers with leading zeros-like format as text for this column to preserve leading zeroes e.g... (6 Replies)
Discussion started by: etldev
6 Replies

9. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

10. Shell Programming and Scripting

Formatting data to put it in the excel file

Hello, I have a file with the below contents : Policy Name: Backup_bkp Policy Type: Catalog_bkp Active: yes Effective date: 08/07/2013 02:02:12 Mult. Data Streams: no Client Encrypt: no Checkpoint: no Policy Priority: ... (11 Replies)
Discussion started by: rahul2662
11 Replies
VWRIGHT(1)						      General Commands Manual							VWRIGHT(1)

NAME
vwright - normalize a RADIANCE view, shift it to the right SYNOPSIS
vwright [ view options ] distance vwright [ view options ] name DESCRIPTION
In the first form, vwright shifts a RADIANCE view the specified distance to the right, putting out a complete set of view parameters in a single line on the standard output. This utility is most often used to compute a right-eyed view from a left-eye view for stereo imaging. If no options are specified on the command line, vwright reads a view from its standard input. The distance given is in world coordinate units. A negative value indicates a shift to the left rather than the right. The second form substitutes a name prefix in place of the shift distance, and produces constant assignments on the standard output suitable for passing directly to rcalc(1). For a given prefix N, the constant names are as follows: Nt: view type ('v'==1,'l'==2,'a'==3,'h'==4,'c'==5,'s'==6) Npx: view point x value Npy: view point y value Npz: view point z value Ndx: view direction x value (normalized) Ndy: view direction y value (normalized) Ndz: view direction z value (normalized) Nd: view focal distance Nux: view up vector x value (normalized) Nuy: view up vector y value (normalized) Nuz: view up vector z value (normalized) Nh: view horizontal size Nv: view vertical size Ns: view shift Nl: view lift No: view fore clipping distance Na: view aft clipping distance Nhx: derived horizontal image vector x value (normalized) Nhy: derived horizontal image vector y value (normalized) Nhz: derived horizontal image vector z value (normalized) Nhn: derived horizontal image vector multiplier Nvx: derived vertical image vector x value (normalized) Nvy: derived vertical image vector y value (normalized) Nvz: derived vertical image vector z value (normalized) Nvn: derived vertical image vector multiplier EXAMPLES
To start rpict(1) on a view .06 meters left of the view in the file "right.vf": rpict `vwright -.06 < right.vf` scene.oct > right.hdr & To move the rad(1) view named "left" 2.5 inches to the right and render from there: rad -v "right `rad -n -s -V -v left examp.rif | vwright 2.5`" examp.rif & To pass a view to rcalc for conversion to some other view: rcalc -n -e `vwright orig < orig.vf` -f viewmod.cal -o view.fmt > new.vf AUTHOR
Greg Ward SEE ALSO
pdfblur(1), rad(1), rcalc(1), rpict(1), rvu(1) RADIANCE
8/29/96 VWRIGHT(1)
All times are GMT -4. The time now is 10:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy