in reply to Converting EXCEL Workbooks to HTML

If you're going from Excel to something else, you don't really need Spreadsheet::WriteExcel. Have you taken a look at Spreadsheet::ParseExcel? That will let you get at the data from the Excel spreadsheet, which you can then write out some other way. It's a very useful module for when you need to start with the data in Excel and use it somewhere else.

BTW, there are also Spreadsheet::BasicRead, Spreadsheet::TieExcel, and some others, but I have never tried any of those and can't comment much on them. Perhaps some other monks have more information on those.

Replies are listed 'Best First'.
Re^2: Converting EXCEL Workbooks to HTML
by jcc2007 (Initiate) on Aug 31, 2007 at 17:35 UTC
    First of all thank you for the response. I will like to clarify my questions:

    1. We get flat file which we create an Excelsheet.
    2. The data needs to be displayed on an IIS 6 Server.
    We would like to take the Excel file we generate from the flat file, to HTML format.
    something like this:

    use strict;
    use Win32::OLE qw(in with);
    use Win32::OLE::Const 'Microsoft Excel';
    $Win32::OLE::Warn = 3; # die on errors...
    my $Excel = Win32::OLE->GetActiveObject
    ('Excel.Application') || Win32::OLE->new
    ('Excel.Application', 'Quit');
    # application or open new
    my $Book = $Excel->Workbooks->Open("C:\\\\Copy of test.xls"); # open Excel file
    my $Sheet = $Book->Worksheets(1);
    $Book->SaveAs('c:\\t.htm','FileFormat:=xlHtml');
    $Book->Close;

    Thanks.

[reply]

In Section Seekers of Perl Wisdom