open Excel/Htm file in Excel mode

[Guest]

I have a file that is created in Excel and saved as an htm file.
(if I open the file through Excel it open as Excel file, if I click on the
file name it open in internet explorer).

I need to read this Excel/htm file but in excel mode through VB.net, in
order to have acces to specifc cells and worksheets.

how can I do that ?

thanks

 

[Guest]

IF you open up the file in notepad you will see that it consists of a style
sheet and html. If you open the file and read it you should be able to get
to the HTML and then parse it out.

If you need a more detailed answer let me know.

 

[Yan-Hong Huang[MSFT]]

Hello Zino,

I think the best way to do it is to use Automation to automate Excel in
VB.NET. Then open this file in the code and access to cells and worksheets
using Excel object model.

Please refer to the following artcile for how to automate Excel in VB.NET.
"HOWTO: Automate Microsoft Excel from Visual Basic .NET"
http://support.microsoft.com/?id=301982
This article demonstrates how to create an Automation client for Microsoft
Excel by using Microsoft Visual Basic .NET.

Does that answer your question?

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
-http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.as
p&SD=msdn

This posting is provided "AS IS" with no warranties, and confers no rights.