10 More Discussions You Might Find Interesting
1. Programming
Perl script to merge cells
---------- Post updated at 12:59 AM ---------- Previous update was at 12:54 AM ----------
I am using below code to read files from a dir and print to excel.
open(my $in, '<', $file) or die "Could not open file: $!";
my $rowCount = 0;
my $colCount = 0;... (11 Replies)
Discussion started by: Jack_Bruce
11 Replies
2. Shell Programming and Scripting
Hi,
I am trying to write a shell script which will modify existing values and take backup of old values.
file trying to modify is : /etc/sysctl.conf
script name: modify.sh
execute ./modify.sh
enter ref no: 123
add below values in file sysctl.cnf
kernel.shmall = 4194304
... (7 Replies)
Discussion started by: darling
7 Replies
3. Shell Programming and Scripting
Hello All,
I have the following code in PERL to write data to excel sheet.
Can someone please help me about how to append data to an exisitng cell?
For ex in the below given case,Cell 1,1 has Active State PERL
Now I want to add a new line like "prorgamming" without overwritting the... (3 Replies)
Discussion started by: prasperl
3 Replies
4. Shell Programming and Scripting
Hi
I ran some query in solaris machine and the result of the query is as below.
Result:
dn: uid=xxx,dc=example,dc=com
id: xxx
firstname: sam
lastname: nam
But my question is , how to get result in excel format in solaris and result attributes dn,id,firstname,lastname values ... (1 Reply)
Discussion started by: buzzme
1 Replies
5. Shell Programming and Scripting
greetings,
i have the following env variable:
LSB_HOSTS='t70cra102 t70cra102 t70cra108 t70cra108'the variable could be any number of host names and sometimes the same name several times. i was hoping there's a way to turn it into the following:
NEW_LSB_HOSTS=,,,]always appreciate the help... (2 Replies)
Discussion started by: crimso
2 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
i have an excel sheet as below:
day
-----
monday
tuesday
wenesday
thursday
friday
i need to append the two more columns in this existing file below:
insert date should be todays date---
day insert date insert user
---- ---------- ... (3 Replies)
Discussion started by: arunmanas
3 Replies
7. Shell Programming and Scripting
Hi,
I would like to modify an existing excel cell format to a custom format.
Is there a way to do it with out writing into a new excel file.
In-place editing?
Thanks (0 Replies)
Discussion started by: sandeep78
0 Replies
8. Shell Programming and Scripting
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
I want to know that will SpreadSheet::WriteExcelXML will work on the existing excel file. (1 Reply)
Discussion started by: akash
1 Replies
10. UNIX for Advanced & Expert Users
Hi,
I know that to create a pdf file I can use the txt2pdf command.
But if I would change an existing pdf file, by inserting lines in particular positions of this file, what can I use? And How? (3 Replies)
Discussion started by: fandwick
3 Replies