08-19-2009
From Ascii files to Excell
Hi,
Is there anyway to copy a certain column from the Ascii file into a column on an Excel sheet?
Thanks,
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Can you pls help on writing ASCII files? For example, how to you put SUPPLIER NO and NAME in an ASCIIfile? (1 Reply)
Discussion started by: yialousa
1 Replies
2. Programming
Anyone knows how to open an ASCII file by using C
Thanks
:D (2 Replies)
Discussion started by: Wing m. Cheng
2 Replies
3. UNIX for Advanced & Expert Users
Hi,
How to view binary files in ASCII format.????????????????
Bye (2 Replies)
Discussion started by: manjunath
2 Replies
4. UNIX for Dummies Questions & Answers
We need to scramble data in a number of ASCII files. Some of these files are extremely large (1.2 GB). By scrambling, I mean that we need to substitute certain strings, which number around 400, with scrambled strings. An example has been given below
If "London" occurs in the file, then it... (2 Replies)
Discussion started by: SanjivNagraj
2 Replies
5. UNIX for Dummies Questions & Answers
how do I display the total number of words in a file which is of the type ascii text (1 Reply)
Discussion started by: madtim
1 Replies
6. Shell Programming and Scripting
Hello All,
I have a query inside a shell script and it will retun a 1000 rows result set. how can i take the output into an excel file from the script for better viewing the results.
Thanks,
Sateesh (4 Replies)
Discussion started by: kotasateesh
4 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I had to do something I could do in a way that worked fine, but I'm still wondering if there's a shorter way (which I think there is)...
I had to find only the ASCII files of a directory, and then work with them (that is, not only showing on screen)
What I did was
ls | xargs... (4 Replies)
Discussion started by: Casey
4 Replies
8. UNIX for Advanced & Expert Users
When you are dealing with ASCII files it easy to check on line endings type. You can just use the file command. You are not always lucky enough to be dealing with ASCII files. So in the cases that you don't have ASCII files how can you check what type of line endings you have? Please list all... (5 Replies)
Discussion started by: cokedude
5 Replies
9. Shell Programming and Scripting
Hi,
At the minute I am using a script to gather weekly SAR stats and put them into an excel scpreadsheet using perl.
I then get that spreadsheet and manually add in a chart on a new worksheet, Can i add this step into the script?
and if so how?
here is the part of my script that creates the... (9 Replies)
Discussion started by: Bdoydie
9 Replies
10. Shell Programming and Scripting
Anyone know how we can implement excel trimmean avg in Unix. possible by AWK
Sample File
scr1 100
scr1 2000
scr2 320
scr1 50
scr1 10
scr2 2
scr2 220
scr1 4234
scr2 2435
scr2 2
scr3 345
scr2 356
expected Output, which was using =trimmean(scr1 values, ignore 50% of values from... (8 Replies)
Discussion started by: mychbears
8 Replies
LEARN ABOUT DEBIAN
xlhtml
xlhtml(1) General Commands Manual xlhtml(1)
NAME
xlhtml - A program for converting Microsoft Excel Files .xls
SYNOPSIS
xlhtml [-a] [-asc] [-csv] [-xml] [-bcNNNNNN] [-bi/path] [-c] [-dp] [-v] [-fw] [-m] [-nc] [-nh] [-tcNNNNNN] [-te] [-xc:N-N] [-xp:N] [-xr:N-
N] FILE
DESCRIPTION
This manual page explains the xlhtml program. The program xlhtml is used to convert Microsoft Excel Spreadsheet files into either html or
tab delimitted ASCII. The program can be interfaced with helper scripts for viewing email attachments. Most use of this program is through
the helper scripts and one would probably rarely resort to using the commandline interface.
OPTIONS
-a aggressively optimize html by removing </TR> </TD> or VALIGN="bottom". Some older browsers may not display properly in this mode.
-asc Ascii out of -dp and extraction data (-xc, -xp, -xr)
-csv Output in Comma Separated Values of -dp and extraction data (-xc, -xp, -xr)
-xml Output in XML of -dp and extraction data (-xc, -xp, -xr)
-bc Override the background color. e.g. -bc808080 for gray
-bi Use background image. e.g. -bi/home/httpd/icon/tar.gif
-c Centers the tables horizontally
-dp Dump page count and max columns and rows per page
-v Prints program version
-fw suppress formula warnings about accuracy
-m No encoding for multibyte
-nc tells it not to colorize the output.
-nh Suppress header and body tags in html output
-tc Override the text color. e.g. -tcFF0000 for red
-te Trims empty rows & columns at the edges of a worksheet
-xc Columns (separated by a dash) for extraction (zero based)
-xp Page for extraction (zero based), one page only
-xr Rows (separated by a dash) to be extracted (zero based)
An example of the extraction command line is: xlhtml -fw -asc -xp:0 -xr:2-6 -xc:0-1 Test.xls
The extraction output is: Formatted output of cells by column left to right, columns separated by a tab, end of row is: 0x0A, end of file:
AUTHOR
Steve Grubb, Charles N Wyble
xlhtml May 15, 2002 xlhtml(1)