C#源码读取excel数据到程序中-SQL SERVER-到dataset中
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
using System.Reflection;
namespace ExcelDemo
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();  
}
        private void button1_Click(object sender, EventArgs e)
        {
            Microsoft.Office.Interop.Excel.ApplicationClass app = new ApplicationClass();
            app.Visible = false;
           
            WorkbookClass w = (WorkbookClass)app.Workbooks.Open(@"C:Documents and Settingsqqq桌面.xls", //Environment.CurrentDirectory+
                Missing.Value,                Missing.Value,                Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value);
           
            object missing = Type.Missing;           
            Sheets sheets = w.Worksheets;
            Worksheet datasheet = null;
            foreach (Worksheet sheet in sheets)
            {
                if (sheet.Name == "Recovered_Sheet1")
                {
                    datasheet = sheet;
                    break;
              &
	
相关新闻>>
- 发表评论
- 
				
- 最新评论 进入详细评论页>>




