1일차 C# 윈폼 EXCEL 데이터 컴파일

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 Microsoft.Office.Interop.Excel;
using Excel = Microsoft.Office.Interop.Excel;

namespace Project
{
    public partial class Form1 : Form
    {
        //=============================== 전역 변수 선언
        Excel.Application ap = null;
        Excel.Workbook wb = null;
        Excel.Worksheet ws = null;


        string filepoint = "C:\\Users\\Administrator\\Documents\\Point1.xlsx";
        //=============================== 전역 변수 끝


        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            try
            {
                ap = new Excel.Application();

                wb = ap.Workbooks.Open("C:\\Point1.xlsx");

                ws = wb.Worksheets.get_Item(1) as Excel.Worksheet;

                TB_8Bit.Text = ws.Cells[2, 3].Value.ToString();
                TB_16Bit.Text = ws.Cells[3, 3].Value.ToString();
                TB_32Bit.Text = ws.Cells[4, 3].Value.ToString();
                TB_Float.Text = ws.Cells[5, 3].Value.ToString();
                if (ws.Cells[6, 3].Value == 0)
                    TB_Digital.Text = "OFF";
                else
                    TB_Digital.Text = "ON";
                TB_String.Text = ws.Cells[7, 3].Value.ToStirng();

                ws = wb.Worksheets.get_Item(2) as Excel.Worksheet;
                TB_16Bit_2.Text = ws.Cells[2, 2].Value.ToString();
                TB_String_2.Text = ws.Cells[2, 3].Value.ToString();
                wb.Save();
                wb.Close(false);
                ap.Quit();
            }
            catch (Exception ex)
            {
                throw ex;

            }

        }

    }
}

 

이코드는 불러오는 코드이다 설정을 보고 참고 하길 바란다