Hi,
I am able to open a excel file, and write data into it, but i want to know how i can insert a row between two rows with data.
i am not using the spreadsheet::wr ite excel .
could anyone please tell me how to do this.
or could you tell me where i could get details of what all instances are available while working with an excel file.
Thanks in advance
supriyamk
Last Activity: Aug 9 '08, 10:07 PM
Joined: Jul 1 '08
Location:
-
i just changed the code from copy to system(copy) and it works, so i guess i am not using perl's copy function correctly -
Copy function doesnt seem to work
Hi,
i am trying to copy files of a certain type into a different directory using perl,
The copy function doesnt seem to work.
...Code:my @dir_list; my $sub_dir; my $file_name1; my $file_name2; my @file_list_gel; my @file_list_res; #--------------LINE21 opendir(aDIR, $dir_root); @dir_list = grep !/^\.\.?$/, readdir aDIR; -
Thank you so much for the responses.Leave a comment:
-
split function usage
Hi,
in order to split a path i used split m!/!, $Dir_name.
when i print the path, it gives \, so i tried different combinations but none are working,
please let me know.
i tried -
split m!\!, $_
split /\/, $_
etc
thanks in advance -
Hi thanks for the guidance.
i got to know the problem.
i had to specify the path for the source file.
as i was using read directory, i assumed the active directory would change but it was not so, so once i gave the full path for the src and dest files, the whole program worked.
thanks againLeave a comment:
-
Hi,
i modified my code, now i am able to print the path where i want the file to go, but still the file is not getting copied.
Please tell me what is wrong in the code below.
use strict;
use warnings;
use File::Copy;
use Cwd;
my $dir_root; #dir to start in
my $dir_dest_gel = 'C:\TS'; #destination directory for gel files
my $dir_dest_res = 'C:\results'; # destination directory...Leave a comment:
-
i am trying to group all files of a certain type into an array using glob.
but i guess that is not happeningLeave a comment:
-
copying files of a certain type to different folder
Hi,
I am trying to search a directory for subdirectories, recreate the subdirectories elsewhere and copy only certain files from current subdirectory to new subdirectory.
In other words i am sorting filetypes into subdirectories with same name.
so far i have been able to create the subdirectories, but i am not able to copy the files into those directories.
...Code:my code is : use strict; use warnings;
-
Can i create a subdirectory using mkdir command?
i have made a directory c:/abcd
now i want to gather a list of sub directories from 1 directory and create the same list here.
i am able to print the list of sub directories,
but mkdir $dest/$_;
is not creating the subdirectory.
Please help -
Hi,
i am trying to copy 1 set of files to a folder from an existing directory tree.
Can you please tell me what is wrong with this code?
...Code:use strict; use warnings; use File::Copy; use File::Glob; my $Src_Dir = 'C:\Documents and Settings\abcd'; my $Dest_Dir_Gel = 'C:\gel'; my $Dest_Dir_Res = 'C:\Results'; Sub dir_read { # parse directory andLeave a comment:
-
Copying sub directories
Hi,
I would like to know how to copy certain types of files from a group of directories into another group of directories.
No activity results to display
Leave a comment: