C # Third job: Importing Excel in C # and generating HTML files

Using System;  Using System.Collections.Generic;  Using System.ComponentModel;  Using System.Data;  Using System.Drawing;  Using System.Linq;  Using System.Text;  Using System.Windows.Forms;  Using System.Data.OleDb;      Using System.IO; namespace ReadFile {public partial class Form1:form {public Form1 () {Initia          Lizecomponent (); private void Form1_Load (object sender, EventArgs e) {} private void  Datagridview1_cellcontentclick (object sender, DataGridViewCellEventArgs e) {} private void              Button1_Click (object sender, EventArgs e) {OpenFileDialog openFiledialog1 = new OpenFileDialog ();           Openfiledialog1.filter = "Excel file |*.xls"; Open the Excel file and read the contents if (Openfiledialog1.filterindex = = 1 && openfiledialog1.showdialog () = = Dialogres Ult. OK) {DataSet ds = ExceltODS (Openfiledialog1.filename);              Printrows (DS); }} public DataSet Exceltods (string path) {//Access Excel data string STRC              Onn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data source=" + @path + ";" + "Extended properties=excel 8.0;";              OleDbConnection conn = new OleDbConnection (strconn); Conn.              Open ();              String strexcel = "";              OleDbDataAdapter mycommand = null;              DataSet ds = null;              Strexcel = "Select name, job URL from [sheet1$]";              mycommand = new OleDbDataAdapter (Strexcel, strconn);              DataTable table1 = new DataTable ();              ds = new DataSet ();                Mycommand.fill (table1); Ds.              Tables.add (table1);              Mycommand.fill (table1);    Datagridview1.datasource = table1;          The data is displayed on the DataGridView return DS;         } private void Printrows (DataSet dataset) {     string [email protected] "e:/1.html";                  if (file.exists (strhtmlfile) ==false) {FileStream myfs=new FileStream (strhtmlfile,filemode.create);                            Myfs.close ();              } int count=0; using (StreamWriter sw=new StreamWriter (strhtmlfile,false,encoding.default)) {SW.              WriteLine ("


Click Import Excel, and then select the name and link in Excel. Generate HTML file, open the link to enter the blog
 
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
 
C # Third job: Importing Excel in C # and generating HTML files