Login or Register to Ask a Question and Join Our Community


Windows & DOS: Issues & Discussions

Run UNIX Script from Excel

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Special Forums Windows & DOS: Issues & Discussions Run UNIX Script from Excel
# 1  
Old 09-12-2014
Run UNIX Script from Excel
How to run scripts from Excel and bring results back to excel?
# 2  
Old 09-12-2014
What have u tried?
This User Gave Thanks to SriniShoo For This Post:
santoshdrkr
# 3  
Old 09-12-2014
I have some commands which are used to find filenames, counts, previous day files and currently i am running them in directories to get results. Is it possible to call them from excel?
# 4  
Old 09-12-2014
That would be Excel macros, and so MSwindows, no more UNIX...
Therefore wrong forum, moving to windows...
This User Gave Thanks to vbe For This Post:
santoshdrkr
# 5  
Old 09-12-2014
Hello santoshdrkr,

I have a few to questions pose in response first:-
  • Is this homework/assignment? There are specific forums for these.
  • What have you tried so far?
  • What output/errors do you get?
  • How are you opening the connection to the unix server?
  • Is this an ODBC connection to an Oracle Database perhaps?
  • What Unix OS and version are you using?
  • What Windows OS and version are you using?
  • What version of Excel are you using?
  • What are your preferred tools? (C, shell, perl, awk, VB etc.)
  • What logical process have you considered? (to help steer us to follow what you are trying to achieve)
Most importantly, What have you tried so far?

There are probably many ways to achieve most tasks, so giving us an idea of your style and thoughts will help us guide you to an answer most suitable to you so you can adjust it to suit your needs in future.


We're all here to learn and getting the relevant information will help us all.
This User Gave Thanks to rbatte1 For This Post:
santoshdrkr
# 6  
Old 09-12-2014
Quote:
Originally Posted by santoshdrkr
How to run scripts from Excel and bring results back to excel?
In the past when I wanted to create a spreadsheet based on something that runs in Unix/Linux I create a shell script that runs on a server, which creates a comma delimeted file with the .csv extension and then emails the file to an email address. you can then save the file and open it with Excel. I have had good luck with the comma and double quote delimeter as in:

"field1","field2","field3","field4"...

Mailing files from Linix/Unix is OS dependent. But I used the Perl Mime Libraries, which work well. On Solaris you can also use uuencode or mpack with either mail or sendmail depending on what you have. The Perl Mime libraries are not usually installed by default.
This User Gave Thanks to gandolf989 For This Post:
santoshdrkr
# 7  
Old 09-12-2014
Quote:
Originally Posted by rbatte1
Hello santoshdrkr,

I have a few to questions pose in response first:-
  • Is this homework/assignment? There are specific forums for these.
  • What have you tried so far?
  • What output/errors do you get?
  • How are you opening the connection to the unix server?
  • Is this an ODBC connection to an Oracle Database perhaps?
  • What Unix OS and version are you using?
  • What Windows OS and version are you using?
  • What version of Excel are you using?
  • What are your preferred tools? (C, shell, perl, awk, VB etc.)
  • What logical process have you considered? (to help steer us to follow what you are trying to achieve)
Most importantly, What have you tried so far?

There are probably many ways to achieve most tasks, so giving us an idea of your style and thoughts will help us guide you to an answer most suitable to you so you can adjust it to suit your needs in future.


We're all here to learn and getting the relevant information will help us all.

Hi rbatte 1,

Actually i am new to this. It would be great if you suggest me process doc's/threads from past. I need to understand the process and then I will implement this.

I have few question's Answers :
  1. this is not a homework/assignment this is a real time thing and I am interested in modifying the process to save time.
  2. .
  3. .
  4. generally we use to log in using server name and credentials.
  5. no idea about connection
  6. how to find unix version?
  7. windows 7
  8. excel 2010/2007
  9. no tools from list
  10. .
Last edited by rbatte1; 09-15-2014 at 07:43 AM.. Reason: Added LIST=1 tags
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

2. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies

3. Shell Programming and Scripting

Perl script to Merge contents of 2 different excel files in a single excel file

All, I have an excel sheet Excel1.xls that has some entries. I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls These may be in different workbooks. They are totally independent made by 2 different users. I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies

4. Shell Programming and Scripting

How to write text file data to excel using UNIX shell script?

Hi All, I have the requirement in unix shell script. I want to write the "ls -ltr" command out put to excel file as below. Input :text file data : drwxr-xr-x 5 root root 4096 Oct 2 12:26 drwxr-xr-x 2 apx aim 4096 Nov 29 18:40 drwxr-xr-x 5 root root 4096 Oct 2 12:26 drwxr-xr-x... (10 Replies)
Discussion started by: Balasankar
10 Replies

5. Shell Programming and Scripting

Invoke a script in UNIX using Excel Macro

Hi, I am using Send Keys to connect to UNIX server and invoke a script . Is there an alternate way to connect to UNIX server using Excel macro and invoke a UNIX Shell script? Anu (2 Replies)
Discussion started by: anandita.jha
2 Replies

6. UNIX and Linux Applications

Perl Script to read an excel file into an array and search in the UNIX directories

Hi, I want the Perl script with versions 5.8.2 and 5.8.5 starting with #!/usr/bin/perl The Perl program should read the excel file or text file line by line and taking into an array and search in the UNIX directories for reference file of .jsp or .js or .xsl with path .The Object names... (2 Replies)
Discussion started by: pasam
2 Replies

7. Shell Programming and Scripting

Run the UNIX script only in specified timelines

Hi, I have an UNIX script which runs in every 20 mins of all the days scheduled through CRON. But i need to modify the CRON entry such that it should run from 00:00 AM to 18:00 and again from 22:30 to 23:59 on Saturday. Remaning days, it should run as usual in every 20 mins. Could anybody... (1 Reply)
Discussion started by: rjanardhan83
1 Replies

8. Shell Programming and Scripting

Run the UNIX script only in specified timelines

Hi, I have an UNIX script which runs in every 20 mins of all the days scheduled through CRON. But i need to modify the CRON entry such that it should run from 00:00 AM to 18:00 and again from 22:00 to 23:59 on Saturday. Remaning days, it should run as usual in every 20 mins. Could... (1 Reply)
Discussion started by: rjanardhan83
1 Replies

9. Shell Programming and Scripting

check in unix shell script so that no one is able to run the script manually

I want to create an automated script which is called by another maually executed script. The condition is that the no one should be able to manually execute the automated script. The automated script can be on the same machine or it can be on a remote machine. Can any one suggest a check in the... (1 Reply)
Discussion started by: adi_bang76
1 Replies

10. Shell Programming and Scripting

need help on unix script to run report

Hi All, I have a report which I am running from unix shell script using CONCSUB utility. Just for testing I put the order number in shell script as ord_low and ord_high. But Actually what is going to happen is that the order numbers will be in a file say a.txt and this CONCSUB... (2 Replies)
Discussion started by: isingh786
2 Replies
Login or Register to Ask a Question