Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help required for open excel

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help required for open excel
# 1  
Old 01-21-2013
Help required for open excel
Hi,

I have a requirement as mentioned below:

I have to develop a script which takes a screen shot as what user is doing after every 2 minutes, open the excel and keep on pasting the screen shot in that order vertically.

I have developed the script up to the creating of screenshot. That screenshots are being pasted on my desktop. Can some please help me put with opening the excel and pasting those screen shots in that vertically . ThanksSmilie

***********************************************************
Code:
if [ $1 ]; then
appenddate=date +%d%b%y
fi

while [ 1 -eq 1 ]; do
date=`date +%y-%m-%d-%T`

#Import the screenshot of the window opened.
import -window root ~/screenshot_$appenddate.png

#move all the screenshot on a perticular path
mv screenshot_$appenddate.png /home/eguapaj/Desktop/screenshot_$date 
sleep 2
done

**************************************************************

---------- Post updated at 03:30 AM ---------- Previous update was at 01:16 AM ----------

Hi,

Can Anybody please reply...in case of any additional information please let me know
Last edited by Scrutinizer; 01-24-2013 at 04:50 AM.. Reason: code tags
# 2  
Old 01-21-2013
Bumping up posts or double posting is not permitted in these forums.

Please read the rules, which you agreed to when you registered, if you have not already done so.

You may receive an infraction for this. If so, don't worry, just try to follow the rules more carefully. The infraction will expire in the near future

Thank You.

The UNIX and Linux Forums.

Why does it have to be excel? That's about the least suitable format for this I can imagine, not to mention the hardest to script.
# 3  
Old 01-24-2013
Hi,

Can you please share by another method the desired output can be reached.....Smilie
# 4  
Old 01-24-2013
Make it a slideshow. I think sth like GPicView or irfanview (on windows) will offer the required feature. If files are named according to creation time, the slide show will be in correct order.
# 5  
Old 01-24-2013
How about an HTML file?

Code:
echo "<html><body>" > list.html
printf "<div><img src='%s'></div>\n" screenshot* >> list.html
echo "</body></html>" >> list.html

Login or Register to Ask a Question

Previous Thread | Next Thread

9 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

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

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

Writing excel file using perl : Excel file formatting changed

I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed. What to do...Please... (7 Replies)
Discussion started by: mud_born
7 Replies

5. Shell Programming and Scripting

generating report in Excel(Open office) using shell scripting

Hello All, I need to execute around 15 queries after which all data should come in Excel format. Executing 15 queries is not a problem. Problem is how to present/put data in excel. kindly suggest me how to start, what to study or what should i do. thanks, (1 Reply)
Discussion started by: shubham8787
1 Replies

6. Red Hat

cannot set user id: Resource temporarily unavailable (not open file/open process related)

First post, sorry to be a bother but this one has been dogging me. I have a process user (java application server) that trips a resource limit every couple weeks and need help finding what limit we're hitting. First, this is what's running: This is the error when jobs are run or the... (0 Replies)
Discussion started by: Katahdin
0 Replies

7. Shell Programming and Scripting

Getting required fields from a test file in required fromat in unix

My data is something like shown below. date1 date2 aaa bbbb ccccc date3 date4 dddd eeeeeee ffffffffff ggggg hh I want the output like this date1date2 aaa eeeeee I serached in the forum but didn't find the exact matching solution. Please help. (7 Replies)
Discussion started by: rdhanek
7 Replies

8. Shell Programming and Scripting

PERL: Split Excel Workbook to Indiv Excel files

Hi, I am trying to find a way to read an excel work book with multiple worksheets. And write each worksheet into a new excel file using perl. My environment is Unix. For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies

9. Shell Programming and Scripting

Win32::OLE open excel file as read only

I am using Win32::OLE to write a perl script which opens an excel file. That excel file is password protected and everytime i run that script dialog box pops up and I have to click on Read-Only then my script executes. Is there any way I can specify the readonly attribute in my code so i dont have... (0 Replies)
Discussion started by: dguy
0 Replies
Login or Register to Ask a Question