Hi Daniweb,
I've been using perl for Regex recently and I want to know is it possible to create an Excel Movie Library with the movie poster, the name of that file and a hyperlink of that clip is attached to the poster. Any help is appreciated. thanks.

Recommended Answers

I would create a text file in comma separated values (or tab-separated if you prefer) format extension because I find it easier to write text files. Then you can start up Excel and import the movies_or_whatever.txt file into a sheet using Excel and save it as an Excel file.

Jump to Post

All 2 Replies

I would create a text file in comma separated values (or tab-separated if you prefer) format extension because I find it easier to write text files. Then you can start up Excel and import the movies_or_whatever.txt file into a sheet using Excel and save it as an Excel file.

Hi,

it possible to create an Excel Movie Library with the movie poster, the name of that file and a hyperlink of that clip is attached to the poster.

Very Possible.

You could check this cpan modules:
For Excel which also include 2007 up, use this
http://search.cpan.org/~jmcnamara/Excel-Writer-XLSX-0.49/lib/Excel/Writer/XLSX.pm

For Older version of excel, use this:
http://search.cpan.org/~jmcnamara/Spreadsheet-ParseExcel-0.59/lib/Spreadsheet/ParseExcel.pm

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.