Форум программистов [Powered by Invision Power Board]

Код


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace Excel_to_Acces
{
    public partial class Form1 : Form
    {
        private string connStrToExcl;
        private string strExclType;

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            comboBox1.Items.Add("Excel 8.0");
            comboBox1.Items.Add("Excel 5.0");
        }

        private void button1_Click(object sender, EventArgs e)
        {
            openFileDialog1.ShowDialog();
        }

        private void openFileDialog1_FileOk(object sender, CancelEventArgs e)
        {
            //MessageBox.Show(openFileDialog1.FileName.Substring(13));
            string strExclName = openFileDialog1.FileName.Substring(13);
            connStrToExcl = "provider=Microsoft.JET.OLEDB.4.0;" + "data source = d:\\Исходники\\"
                            + strExclName +";Extended Properties="+strExclType+"; HDR=No; IMEX=1";

            readExclFile(strExclName);
        }
        public void readExclFile(string strSheetName) {
            string strCommand = "Select * From" + strSheetName;
            OleDbConnection conn = new OleDbConnection(connStrToExcl);
            //MessageBox.Show(connStrToExcl.ToString());
            conn.Open();
            OleDbDataAdapter daAdapter = new OleDbDataAdapter(strCommand, connStrToExcl);
            DataTable dtTable = new DataTable(strSheetName);
            daAdapter.FillSchema(dtTable, SchemaType.Source);
            daAdapter.Fill(dtTable);
            conn.Close();
            MessageBox.Show("Количество столбцов= " + dtTable.Columns.Count.ToString()
                                + " ; Количество строк= " + dtTable.Rows.Count.ToString());
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            strExclType = comboBox1.Text;
        }
    }
}