03-19-2020
Hi and welcome to the forums
For next time, please use code tags for easier reading.
2 important points.
1) Shell scripts are plaintext, XLS is not, you might want to check out CSV files for better usability.
2) Shell redirection works as follow: >=Create/Overwrite ;; >>=Append
Also, you might need to 'work' on the output you've created so far, it's not spreadsheet conform yet.
You're currently trying to combine 2 different worlds... Linux & MS.
For proper XLS file support, go with VBA.
For proper shell support, go with a CSV sheet.
Because AFAIK, it's not possible (read: even IF ; it would need tons of tweaking) to access//write XLS files (this 'SPECIFIC' file format, because its BINARY) from any regular *nix based shell.
Please correct me if I'm wrong on this.
Hope this helps, allthough not what you wanted.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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
2. Shell Programming and Scripting
Hi All,
I am having an excel sheet with pre-defined format which our business team specified, what i need to do is i have to write a script which need to pick values from database and update specified cells in excel sheet..
can any one please help me in this regard..
I am able to pull the... (3 Replies)
Discussion started by: balanarendra
3 Replies
3. Shell Programming and Scripting
I would like to read data from excel sheet as a input to a shell script.
Myproblem is the excel sheet is in windows. How can I write a shell script to read data from that excel sheet?
How can I do that?. (4 Replies)
Discussion started by: vj8436
4 Replies
4. Shell Programming and Scripting
Hi,
I have an excel sheet which has 100000 records. All these records are having 3 columns each with the last column as "Y" or "N". I would like to filter those records which has the value "Y". Can you please let me know how to proceed with that?
Thanks in advance.
-Sri
----------... (8 Replies)
Discussion started by: bhanusri83
8 Replies
5. Shell Programming and Scripting
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
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
7. UNIX for Dummies Questions & Answers
Hi,
i have some data in a temporary file in Unix (the data is taken from the result of an SQL query). Now i want to dump that data into an excel sheet. How to do that. Someone please advise. Thanks
Regards,
Vinit (3 Replies)
Discussion started by: vinit raj
3 Replies
8. UNIX for Dummies Questions & Answers
hi,
i wanted to add unix data to be updated to the excel sheet. (3 Replies)
Discussion started by: rupesh.bombale
3 Replies
9. Shell Programming and Scripting
(1 Reply)
Discussion started by: sagar_1986
1 Replies
10. Shell Programming and Scripting
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
LEARN ABOUT DEBIAN
bon_csv2html
bon_csv2html(1) General Commands Manual bon_csv2html(1)
NAME
bon_csv2html program to convert CSV format Bonnie++ data to a HTML form using tables suitable for display on a web page. NB Lynx can't dis-
play this properly, and due to the size it probably requires 1024x768 monitor to display properly.
bon_csv2txt program to convert CSV format Bonnie++ data to plain-text format suitable for pasting into an email or reading on a Braille
display.
DESCRIPTION
They take CSV format (comma-delimited spreadsheet files AKA Comma Seperated Values in MS land) data on standard input and produce HTML or
plain text on standard output respectively.
FORMAT
This is a list of the fields used in the CSV files format version 2. Format version 1 was the type used in Bonnie++ < 1.90. Before each
field I list the field number as well as the name given in the heading
0 format_version
Version of the output format in use (1.96)
1 bonnie_version
(1.96)
2 name Machine Name
3 concurrency
The number of copies of each operation to be run at the same time
4 seed Random number seed
5 file_size
Size in megs for the IO tests
6 chunk_size
Size of chunks in bytes
7 putc,putc_cpu
Results for writing a character at a time K/s,%CPU
9 put_block,put_block_cpu
Results for writing a block at a time K/s,%CPU
11 rewrite,rewrite_cpu
Results for reading and re-writing a block at a time K/s,%CPU
13 getc,getc_cpu
Results for reading a character at a time K/s,%CPU
15 get_block,get_block_cpu
Results for reading a block at a time K/s,%CPU
17 seeks,seeks_cpu
Results for the seek test seeks/s,%CPU
19 num_files
Number of files for file-creation tests (units of 1024 files)
20 max_size
The maximum size of files for file-creation tests. Or the type of files for links.
21 min_size
The minimum size of files for file-creation tests.
22 num_dirs
The number of directories for creation of files in multiple directories.
23 file_chunk_size
The size of blocks for writing multiple files.
24 seq_create,seq_create_cpu
Rate of creating files sequentially files/s,%CPU
26 seq_stat,seq_stat_cpu
Rate of reading/stating files sequentially files/s,%CPU
28 seq_del,seq_del_cpu
Rate of deleting files sequentially files/s,%CPU
30 ran_create,ran_create_cpu
Rate of creating files in random order files/s,%CPU
32 ran_stat,ran_stat_cpu
Rate of deleting files in random order files/s,%CPU
34 ran_del,ran_del_cpu
Rate of deleting files in random order files/s,%CPU
36 putc_latency,put_block_latency,rewrite_latency
Latency (maximum amount of time for a single operation) for putc, put_block, and reqrite
39 getc_latency,get_block_latency,seeks_latency
Latency for getc, get_block, and seeks
42 seq_create_latency,seq_stat_latency,seq_del_latency
Latency for seq_create, seq_stat, and seq_del
45 ran_create_latency,ran_stat_latency,ran_del_latency
Latency for ran_create, ran_stat, and ran_del
A string that starts with '#' is a comment.
AUTHOR
These programs were written by Russell Coker <russell@coker.com.au>. May be freely used and distributed without restriction.
bon_csv2html(1)