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
git-annex-shell
git-annex-shell(1) General Commands Manual git-annex-shell(1)
NAME
git-annex-shell - Restricted login shell for git-annex only SSH access
SYNOPSIS
git-annex-shell [-c] command [params ...]
DESCRIPTION
git-annex-shell is a restricted shell, similar to git-shell, which can be used as a login shell for SSH accounts.
Since its syntax is identical to git-shell's, it can be used as a drop-in replacement anywhere git-shell is used. For example it can be
used as a user's restricted login shell.
COMMANDS
Any command not listed below is passed through to git-shell.
Note that the directory parameter should be an absolute path, otherwise it is assumed to be relative to the user's home directory. Also the
first "/~/" or "/~user/" is expanded to the specified home directory.
configlist directory
This outputs a subset of the git configuration, in the same form as git config --list
inannex directory [key ...]
This checks if all specified keys are present in the annex, and exits zero if so.
dropkey directory [key ...]
This drops the annexed data for the specified keys.
recvkey directory key
This runs rsync in server mode to receive the content of a key, and stores the content in the annex.
sendkey directory key
This runs rsync in server mode to transfer out the content of a key.
commit directory
This commits any staged changes to the git-annex branch. It also runs the annex-content hook.
OPTIONS
Most options are the same as in git-annex. The ones specific to git-annex-shell are:
--uuid=UUID
git-annex uses this to specify the UUID of the repository it was expecting git-annex-shell to access, as a sanity check.
HOOK
After content is received or dropped from the repository by git-annex-shell, it runs a hook, .git/hooks/annex-content (or hooks/annex-con-
tent on a bare repository). The hook is not currently passed any information about what changed.
ENVIRONMENT
GIT_ANNEX_SHELL_READONLY
If set, disallows any command that could modify the repository.
GIT_ANNEX_SHELL_LIMITED
If set, disallows running git-shell to handle unknown commands.
SEE ALSO
git-annex(1)
git-shell(1)
AUTHOR
Joey Hess <joey@kitenet.net>
<http://git-annex.branchable.com/>
git-annex-shell(1)