Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Storing UNIX shell command output to a new sheet in excel Post 303045404 by sea on Thursday 19th of March 2020 03:18:41 PM
Old 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

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

2. Shell Programming and Scripting

How to update existing excel sheet using shell script

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

Read window Excel sheet to unix

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

Filter data in Excel sheet using Shell Script

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

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

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

7. UNIX for Dummies Questions & Answers

Load UNIX data into excel sheet

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

UNIX data to be updated to ms excel sheet

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

Adding tab to excel sheet with shell script

(1 Reply)
Discussion started by: sagar_1986
1 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
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)
All times are GMT -4. The time now is 08:31 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy