Home >Web Front-end >HTML Tutorial >第三次作业 Excel数据读取及HTML文件初步 目标2_html/css_WEB-ITnose
第三次作业 Excel数据读取及HTML文件初步 目标2_html/css_WEB-ITnose
- WBOYOriginal
- 2016-06-21 09:13:29977browse
1．功能：
1)导入excel文件内容：
2)导出excel.txt文件：
3)导出excel.html文本文件：
2.源程序如下：
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using System.Data.OleDb; using System.IO;namespace WindowsFormsApplication3{ public partial class Form1 : Form { public Form1() { InitializeComponent(); } public DataSet ReadExcel(string path) { string strConn = "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 班级,学号,姓名,类别,作业网址 from [sheet1$]"; myCommand = new OleDbDataAdapter(strExcel, strConn); DataTable table1 = new DataTable(); ds = new DataSet(); myCommand.Fill(table1); myCommand.Fill(ds); dataGridView1.DataSource = table1; return ds; } private void button1_Click(object sender, EventArgs e) { OpenFileDialog openfile = new OpenFileDialog(); openfile.Filter = "工作薄(*.xls)|*.xls|所有文件(*.*)|*.*|工作薄(*.xlsx)|*.xlsx"; if (openfile.FilterIndex == 1 && openfile.ShowDialog() == DialogResult.OK) { DataSet dataSet = ReadExcel(openfile.FileName); String name = ""; using (StreamWriter sw = new StreamWriter(@"C:\Users\Administrator.LBDZ-20121019BZ\Documents\学习\C#\3\excel.txt", false, Encoding.Default)) { foreach (DataTable table in dataSet.Tables) { foreach (DataRow row in table.Rows) { foreach (DataColumn column in table.Columns) { //Console.WriteLine(row[column]); if (column.ColumnName == "姓名") { name = row[column].ToString(); } if (column.ColumnName == "作业网址") { sw.WriteLine(name + ":" + row[column].ToString() + ";"); } } } } } using (StreamWriter sw = new StreamWriter(@"C:\Users\Administrator.LBDZ-20121019BZ\Documents\学习\C#\3\excel.html", false, Encoding.Default)) { sw.WriteLine("<html>"); sw.WriteLine("<body>"); sw.WriteLine("<table cellPadding=1 align=center>"); foreach (DataTable table in dataSet.Tables) { foreach (DataRow row in table.Rows) { foreach (DataColumn column in table.Columns) { //Console.WriteLine(row[column]); if (column.ColumnName == "姓名") { // sw.Write("<a href=\"" + row[column] + "\">"); name = row[column].ToString(); sw.WriteLine("<tr>" + "<td>" + name + "</td>"); } if (column.ColumnName == "作业网址") { sw.WriteLine("<td>" + "<A Href=\"" + row[column].ToString() + "\">" + row[column].ToString() + "</a>"); sw.WriteLine("</td>"); sw.WriteLine("</tr>"); } } } } sw.WriteLine("</table>"); sw.WriteLine("</body>"); sw.WriteLine("</html>"); } } } }} 3.运行结果：
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：CSS 层叠规则_html/css_WEB-ITnoseNext article：为什么text-align没有效果_html/css_WEB-ITnose