can any one tell me how to rectify the below error?
:confused:Can't locate Spreadsheet/TieExcel.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .)
you need to install the TieExcel perl module.
execute the below command
perl -MCPAN -e 'install "Spreadsheet::WriteExcel"'
Hi,
Thank you for your reply........
I already installed the package mentioned by you.
Is both "Spreadsheet::WriteExcel,Spreadsheet::TieExcel" are same?
seems you are working with linux.
Spreadsheet/TieExcel.pm will work only in windows machine with excel installed.
In this case, you need to work with ParseExcel ( check the module SaveParser )
I tried to move content from one cell to another cell using Spreadsheet::ParseExcel...Instead of moving content it overwrite the cell content.
can you please tell me Is there possibility to move content as i mentioned below?
Example:
content in (3,1),(3,2) should move to (3,3) ,(3,4) respectively...
and new information should be stored to (3,1),(3,2)