Excel Format converted to HTML

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hey everyone.

I'm trying to parse a excel file and print out its content into html table so it can be viewed via the web.

I have lots of excel files I will be using and I need a way I can easily take the format that exists on the exel file so its the same viewed on the web. So If a row value on a excel file was bold, then it will also be bold on the browser.

The closest module I have that may be able to do this is SpreadSheet::Parse. I have looked at their formatting section on the manual but not sure if theres a way to do what I want to do.

If anyone has any referrence they can share or knowledge on this topic, I'll appreciate it dearly.

Cheers,
Alexis

Comment on Excel Format converted to HTML

Replies are listed 'Best First'.
Re: Excel Format converted to HTML by chargrill (Parson) on Feb 19, 2006 at 01:06 UTC
Did you try searching here? I did, and found Printing extracted Excel data into a HTML table. Does that help you? --chargrill `$/ = q#(\w)# ; sub sig { print scalar reverse join ' ', @_ } + sig map { s$\$/\$/$\$2\$1$g && $_ } split( ' ', ",erckha rlPe erthnoa stJu +" );` [download]	[reply] [d/l]
Re^2: Excel Format converted to HTML by Anonymous Monk on Feb 19, 2006 at 03:37 UTC
I actually found that, but it does not mention anything about taking the existing excel format and converting it into html. :(	[reply]
Re: Excel Format converted to HTML by planetscape (Chancellor) on Feb 19, 2006 at 09:19 UTC
Ok, not sure if anything here will actually help, but this is the definitive resource here on PM for working with spreadsheets: Index of Spreadsheet FAQs If I find anything else in the meantime, I will update this node. HTH, Update: If you can do what you need to do in VBA, you can then Convert VBA to Perl (credit for this link goes to marto). As the link above implies, you can always automate Excel using Win32::OLE. If you do generate your HTML from within Excel, you'll undoubtedly want to run the result through Demoronizer and probably also HTML Tidy. Are you committed to HTML? PDF::Template might be useful otherwise... HTML::FromText may help... module review CGI & Spreadsheet::WriteExcel Module Help needed - Yes, it talks about CGI. But there are also many tips, interesting code, and good articles referenced in this thread. (updated link for the Perl Journal article on Spreadsheet::WriteExcel) planetscape	[reply]
Re: Excel Format converted to HTML by Anonymous Monk on Feb 19, 2006 at 18:38 UTC
Thanks a lot for taking your time to compile these referrence links. I will take a look and see if any of these results solve what I'm looking to do. IF so, I will post for further referrence for anyone else who may search upon this thread. Thanks you, Alexis	[reply]