Heim >Web-Frontend >HTML-Tutorial >第三次作业 Excel数据读取及HTML文件初步 目标2_html/css_WEB-ITnose
第三次作业 Excel数据读取及HTML文件初步 目标2_html/css_WEB-ITnose
- WBOYOriginal
- 2016-06-21 09:13:29991Durchsuche
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.运行结果：
Stellungnahme：
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Vorheriger Artikel：CSS 层叠规则_html/css_WEB-ITnoseNächster Artikel：为什么text-align没有效果_html/css_WEB-ITnose