09-21-2011
CSV file format doesn't support multiple sheets (you can see that by trying to save a workbook with multi-sheets to csv).
You are probably best having separate csv files for each sheet and loading them in separately.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
UNIX shell script (Bourne shell syntax) called
admin_script. This script is described below as a usage summary:
admin_script
Note: if no options are specified, a menu is displayed which allows
users to perform one of the following tasks and then exit. If
incorrect options are provided,... (1 Reply)
Discussion started by: nadman123
1 Replies
2. UNIX for Dummies Questions & Answers
Hello,
I have done some BASIC shell scripting/PERL scripting before so I am familiar with the languages. I am not really sure which one would lend itself better to the application I have to write.
I am required to scan the message logs for possible break in attempts. If I use shell scripting... (2 Replies)
Discussion started by: mojoman
2 Replies
3. AIX
If I need delete some disk,
for i in hdisk1 hdisk2 hdisk3 hdisk4
do
rmdev -dl $i
done
if I have more than 100 hdisks, how to write a script like that to delete them? (6 Replies)
Discussion started by: rainbow_bean
6 Replies
4. IP Networking
Hi,
We have smb client running on two of the linux boxes and smb server on another linux system. During a backup operation which uses smb, read of a file was allowed while write to the same file was going on.Also simultaneous writes to the same file were allowed.Following are the settings in the... (1 Reply)
Discussion started by: swatidas11
1 Replies
5. Solaris
hi all
how I can create an ftp user in solaris 10 and have read and write permission on a directory.
Thanks. (1 Reply)
Discussion started by: luisfja
1 Replies
6. Shell Programming and Scripting
Hi All,
I have written the follwing script to take the backup of the file every day
along with the date.
DATE=`date +%Y%m%d`
export DATE
cp var/hr/hr333m.txt cp var/hr/payments/hr333m_$DATE.txt
The file name as follows after taking the backup.
hr333m_20110630.txt
Could you... (3 Replies)
Discussion started by: ajaykumarkona
3 Replies
7. Shell Programming and Scripting
Hello all,
I am new to shell scripting. I want to write a shell script which will give me the output of the following query as an attachment in a mail
SELECT /*+ parallel(a,4)*/ban, subscriber_no, business_id, price_plan_code, call_action_code, special_seq_no, toll_soc, toll_feature_code,... (1 Reply)
Discussion started by: paraspawar
1 Replies
8. Shell Programming and Scripting
I am having a File format as mentioned below
Employee id|Name|Languages
12345|Hema|02|English|Hindi
4567|Basha|03|Engligh|Hindi|Telegu
the 02 and 03 are counters. Using that we need to generate the output records as mentioned below
12345|Hema|English
12345|Hema|Hindi
... (8 Replies)
Discussion started by: bashamsc
8 Replies
9. UNIX for Beginners Questions & Answers
Hello,
I have written a cron job to automate the sftp of files using key authentication.
I wanted to add a timeStamp and name of file sent to a log file and append each these details to the same file each time files are sent and if possible include whether the files were sent successfully or not.... (3 Replies)
Discussion started by: KidKoder
3 Replies
10. UNIX for Beginners Questions & Answers
I have built a website and I can access and edit the website'files on server via the root user. The current file and directory structures are not changeable. Now I am hiring a webpage designer to help me re-design some pages, I am going to let the designer edit the files directly on the server. So... (5 Replies)
Discussion started by: uwo-g-xw
5 Replies
LEARN ABOUT PHP
set_color
set_color(1) fish set_color(1)
NAME
set_color - set_color - set the terminal color
set_color - set the terminal color
Synopsis
set_color [-v --version] [-h --help] [-b --background COLOR] [COLOR]
Description
Change the foreground and/or background color of the terminal. COLOR is one of black, red, green, brown, yellow, blue, magenta, purple,
cyan, white and normal.
o -b, --background Set the background color
o -c, --print-colors Prints a list of all valid color names
o -h, --help Display help message and exit
o -o, --bold Set bold or extra bright mode
o -u, --underline Set underlined mode
o -v, --version Display version and exit
Calling set_color normal will set the terminal color to whatever is the default color of the terminal.
Some terminals use the --bold escape sequence to switch to a brighter color set. On such terminals, set_color white will result in a grey
font color, while set_color --bold white will result in a white font color.
Not all terminal emulators support all these features. This is not a bug in set_color but a missing feature in the terminal emulator.
set_color uses the terminfo database to look up how to change terminal colors on whatever terminal is in use. Some systems have old and
incomplete terminfo databases, and may lack color information for terminals that support it. Download and install the latest version of
ncurses and recompile fish against it in order to fix this issue.
Version 1.23.1 Sun Jan 8 2012 set_color(1)