Converting HTML table to excel sheet using C#

Question

I have html table in Microsoft.Office.Interop.Outlook.MailItem body and I just need to fill excel sheet with this table using C# for desktop application. Could any one help me in this regard. Thanks

vc 74 · Accepted Answer · 2011-02-08 08:26:03Z

3

A quick and dirty way:

File.WriteAllText(@"C:\Temp\Table.xls", mailItem.Body);

Excel will open it even though the file does not contain a valid xls document

answered Feb 8, 2011 at 8:26

vc 74

38.3k7 gold badges80 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Stefan Steiger Over a year ago

But it will issue a warning on load, at least in Excel 2010

user607374 Over a year ago

It does fill the excel sheet except few columns contain hyperlinks :(.

Carles Company · Accepted Answer · 2011-02-08 11:27:47Z

0

You can also use HtmlAgilityPack to parse the e-mail and EPPlus to write to Excel (only 2007/2010 xlsx version).

answered Feb 8, 2011 at 11:27

Carles Company

7,1955 gold badges52 silver badges80 bronze badges

Collectives™ on Stack Overflow

Converting HTML table to excel sheet using C#

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related