Sponsored Content
Top Forums Shell Programming and Scripting Shell script to turn on Autofilter in Excel. Post 302232017 by Smiling Dragon on Wednesday 3rd of September 2008 06:43:16 PM
Old 09-03-2008
Sorry but .csv files don't support filtering, that's .xls and .xlsx only.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to get values from an excel in a shell script

Hi All, Am trying to write a shell script which will get values from an excel and do some calculations. Can any one pls help me out in the commands used to get the values from ms-excel. Thanks!!!:) (2 Replies)
Discussion started by: msri.1900
2 Replies

2. Shell Programming and Scripting

Export to Microsoft excel using shell script

I have requirement where i have to export the data extracted from a flat file to a microsoft excel sheet. If the awk returns multiple records then all these records should go in into different rows of same column in excel. Eg. say data returned by excel is A,B,C,D then these 4 records should go... (1 Reply)
Discussion started by: goutam_igate
1 Replies

3. Shell Programming and Scripting

editing excel file through shell script

Hi, I am having a business file in excel having charts based on data already present on it. I would like to add new rows after the existing data and refesh the chart on it using shell script. For example-- In excel file in "sheet1", There is some data in first 10 rows ( from column A to F).... (0 Replies)
Discussion started by: sanjay1979
0 Replies

4. UNIX for Dummies Questions & Answers

How to take input from excel for shell script.

i have both linux and windos installed on my pc . i want to take 1st column of excel as in input for my shell script .can anyone tell me how can i achive that. (1 Reply)
Discussion started by: nitin_aaa27
1 Replies

5. Shell Programming and Scripting

AutoFilter in Excel report when exporting from Unix

Hi All, Is it possible to have AutoFilter applied in the Excel Sheet which is Exported from UNix server as *.csv file. (0 Replies)
Discussion started by: rawat_me01
0 Replies

6. Shell Programming and Scripting

Zip an excel in a shell script

I am getting an xls file in the dir errorpath. I would like to zip it. Kindly help me on this. The code is as below. sqllst=$errorpath/$run_pgm.${date_stamp}".xls" sqlstatus=$errorpath/$run_pgm"."${date_stamp}".sqlstatus" sqlscript=$binpath"/im_rpt.sql" (2 Replies)
Discussion started by: Nithin
2 Replies

7. UNIX for Dummies Questions & Answers

Read excel file using shell script

Is it possible to read an excel sheet using shell script ? (2 Replies)
Discussion started by: hiten.r.chauhan
2 Replies

8. Shell Programming and Scripting

How to turn off ora errors in shell script?

I have a shell script which select total count from a table and use its value in a if condition like below connect_string="username/password@tnsname" tot=`sqlplus -s $connect_string << EOF set echo off set feedback off set head off select count(*) from test_table; EOF ` if then echo... (2 Replies)
Discussion started by: vel4ever
2 Replies

9. Shell Programming and Scripting

Formatting Shell script output to Excel

I am facing a problem formatting the output of my shell script in excel. We are directing the output of the script to an excel sheet and need long integer type data printed in Excel as it is (i.e. not in the default scientific notation). Also, leading zeroes(if any) in the output are getting... (4 Replies)
Discussion started by: bornali.p
4 Replies

10. Shell Programming and Scripting

Excel from shell script

Is it possible to generate excel sheet from a shell script and rename the worksheet..? Thanks for your answer (1 Reply)
Discussion started by: Anu_1
1 Replies
Excel::Template::Element::Image(3pm)			User Contributed Perl Documentation		      Excel::Template::Element::Image(3pm)

NAME
Excel::Template::Element::Image - Excel::Template::Element::Image PURPOSE
To insert an image into the worksheet NODE NAME
IMAGE INHERITANCE
ELEMENT EFFECTS
This will consume one column in the current row. DEPENDENCIES
None USAGE
<image path="/Some/Full/Path" /> <image path="/Some/Full/Path" offset="2,5" /> <image path="/Some/Full/Path" scale="2,0.4" /> <image path="/Some/Full/Path" offset="4,0" scale="0,2" /> Please see "" in Spreadsheet::WriteExcel for more information about the offset and scaling options as well as any other restrictions that might be in place. This node does NOT perform any sort of validation upon your parameters. You are assumed to know what you are doing. Note that the offset and scaling values are "X,Y". You must provide both values, even if the Y value is 0. If you provide a 0 value for either scaling option, "" in Spreadsheet::WriteExcel will default that to 1. AUTHOR
Rob Kinyon (rob.kinyon@gmail.com) SEE ALSO
Nothing perl v5.14.2 2010-06-17 Excel::Template::Element::Image(3pm)
All times are GMT -4. The time now is 04:16 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy