Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^2: Merging 2 xlsx files (UPDATED)

by mnakkach (Novice)
on Sep 14, 2017 at 04:53 UTC ( #1199369=note: print w/replies, xml ) Need Help??


in reply to Re: Merging 2 xlsx files (UPDATED)
in thread Merging 2 xlsx files

Thanks, it works well, is there a way we can transfer cell comments? ***

Replies are listed 'Best First'.
Re^3: Merging 2 xlsx files (UPDATED)
by thanos1983 (Priest) on Sep 14, 2017 at 21:21 UTC

    Hello mnakkach,

    If you are trying to learn programming you really are not showing any effort. As the fellow Monks already said this is a not a free code forum. Show us some effort, show us your code and then you can ask for advice / code improvements etc.

    I will answer your question because I found it extremely easy. Did you read the documentation of the Excel::Writer::XLSX/write_comment( $row, $column, $string, ... ). Regarding reading the comments from you spread sheet, this is for you to figure it out. Show us the effort and we will try to help.

    Hope this helps, BR.

    Seeking for Perl wisdom...on the process of learning...not there...yet!
      I have already added the comments through "write comment", but this is not the intention to write "Any" comment, i needed to transfer the comments from merged sheets, $worksheet->write_comment( 'A1', 'Test Comment', visible => 1, author => 'Author test' ); There is no way I found to read comments through Spreadsheet::Read http://search.cpan.org/~hmbrand/Spreadsheet-Read-0.74/Read.pm I have managed now to do the same through Excel VB Macros and it works well. Regards

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1199369]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (4)
As of 2017-09-24 02:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    During the recent solar eclipse, I:









    Results (273 votes). Check out past polls.

    Notices?