Sponsored Content
Top Forums Shell Programming and Scripting Help needed to combine files to excel sheet Post 302180141 by ahjiefreak on Sunday 30th of March 2008 04:58:15 AM
Old 03-30-2008
Hi,

I checked wiht man cat and it doesnt provide close clue to this. I am actually generated alot of text files and would like to do better comparison among these text files efficiently. And there are thousands of them; which is why I need to find a solution to automate them to worksheets in excel.

Please advise.
Thanks.
 

10 More Discussions You Might Find Interesting

1. HP-UX

Creating Excel Sheet in Hp-UX

Dear Members, How do I create an eqvivalant of Excel sheet in Hp-UX. Is there any application like the Microsoft Excel on HP-UX. How do I invoke it. Regards, PrasadKVS (5 Replies)
Discussion started by: KVSPRASAD
5 Replies

2. UNIX for Advanced & Expert Users

Exporting files from unix to Excel sheet

How can we export a file in unix with certain number of columns to an excel sheet. It's very useful in time saving...... (3 Replies)
Discussion started by: bishweshwar
3 Replies

3. Shell Programming and Scripting

combine 3 excel files using shell.

Is there any way to combine 3 excel files into one comma separated file, after removing the header row from all the three files. Is this possible? I have looked in FAQ and I did not find anything. Appreciate any suggestions or links to resources. Radhika. (11 Replies)
Discussion started by: radhika
11 Replies

4. Solaris

Excel sheet

Hello, I have an information of about 100 odd file names which i have in my server. I need to attach this information in an excel sheet and sent to the concerned team. I use uuencode for attaching a text file. But how will i have all the information in attachment. Please assist. Is there... (1 Reply)
Discussion started by: venkidhadha
1 Replies

5. Shell Programming and Scripting

Excel sheet to be created from unix.

Hi Guys, I like to create a excel sheet with four tabs. Is it possible to create it. Acutually i want to apply formulas in fourth tab which uses the three different tabs. Is it possible to create such a script? Thanks & regards, Magesh (3 Replies)
Discussion started by: mac4rfree
3 Replies

6. Shell Programming and Scripting

Pdf to excel sheet??

Hi everyone, I want a shellscript code that takes an pdf as input and returns the data in the pdf into an excel sheet... Thanks, C10 (3 Replies)
Discussion started by: Carlton
3 Replies

7. Shell Programming and Scripting

Attaching two text files in two different sheet in same excel

Hi, My requirement is to get attach two different text file contents to two different sheets in same excelsheet. Also, is there any way we can name the tabs as desired ? Kindly assist. (2 Replies)
Discussion started by: sanjaydubey2006
2 Replies

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

9. Shell Programming and Scripting

Format Excel sheet

Hi, I want to format Excel sheet through Unix script. Format would mean bolding the data in the cell, adding clor to it etc. Please help me if it is possible through Unix scripting? Thanks, Durga (2 Replies)
Discussion started by: Durga Prasad NK
2 Replies

10. 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
NUP(1)							      General Commands Manual							    NUP(1)

NAME
nup - multiple pages per sheet with dvi2ps SYNOPSIS
nup [ [ -p paper ] [ -2 ] [ -4 ] [ -8 ] [ -l ] [ -n ] ] DESCRIPTION
This manual page documents briefly the nup command. This manual page was written for the Debian GNU/Linux distribution because the origi- nal command hadn't manual page. Nup puts multiple logical pages onto each physical sheet of paper with dvi2ps. The input PostScript file should be of dvi2ps The -p paper option is to set the paper size which is available with dvi2ps. The -2 option is to put 2 logical pages on each sheet of paper. The -4 option is to put 4 logical pages on each sheet of paper. The -8 option is to put 8 logical pages on each sheet of paper. The -l option is to surround a page with frame. The -n option in not to shrink each logical pages. EXAMPLES
to print 2 pages in a sheet: dvi2ps foo.dvi | nup -2 | lpr to print 8 pages in a B4 paper: dvi2ps foo.dvi | nup -8 -p b4 | lpr to print 4 pages in a letter size paper with frame: dvi2ps foo.dvi | nup -4 -p letter -l | lpr to print 2 B5 size pages in a B4 paper: dvi2ps -o b5 foo.dvi | nup -2 -n -p b4 | lpr SEE ALSO
dvi2ps(1) AUTHOR
This manual page was written by Atsuhito Kohda <kohda@debian.org>, for the Debian GNU/Linux system (but may be used by others). NUP(1)
All times are GMT -4. The time now is 01:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy