Excel file to HTML file convertor

[callaamir]

I m looking for any component or code through which I can upload and convert that uploaded excel file into a html file

Please if any one can help me out

Thanks
Aamir

[callaamir]

hey.... whats up... its been a day...

no one with any idea?????

Please I need it asap..

Thanks

[Roelf]

excel has the ability to save as html itself. If the excel file is on the server, you can use asp to create an instance of an activeX.excel object (if you run on a windows server, like NT or 2000) then you can programmatically open the sheet, and save as html.

[whammy]

Or you can just save it as HTML and upload it... what are you trying to accomplish, exactly?

Some of the clients I deal with would rather download an excel file or a .csv if you're just dealing with data - since then they can manipulate the data however they want. Not to mention that's WAY easier than writing a report. ;)

[callaamir]

Thanks for the reply
What exactly I want is that I upload the excel file using asp file component (which is not a problem) after uploading that file automatically get converts in htm file and get saved to a specific location....
:)

[glenngv]

i'd go for Roelf's suggestion.
here's the syntax for the method SaveAs:

Sub SaveAs([Filename], [FileFormat], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [AccessMode As XlSaveAsAccessMode = xlNoChange], [ConflictResolution], [AddToMru], [TextCodepage], [TextVisualLayout])
Member of Excel.Workbook

You can see all the properties and methods of the Excel component. Open Excel, then Tools->Macro->Visual Basic Editor
Then in the editor window, click View->Object Browser (or F2).
You can now see all the properties and methods.

You can invoke excel in asp by:

Set oExcel=Server.CreateObject("Excel.Application")

Hope this helps and starts you on the right track.

[callaamir]

Thanks buddy I'll try that.....