来自excel的数据和来自用户的输入之间的计算？ [英] Calculation between data from excel and input from user?

问题描述

如何根据用户键入我们在c＃中链接的excel文件中的数据（列）的数量进行计算？



我尝试过：

how to make calculation based on the quantity that user key in with the data(column) in the excel file that we link in c# ?

What I have tried:

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

namespace myproject
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        DataSet result;

        private void btnopen_Click(object sender, EventArgs e)
        {
            using (OpenFileDialog ofd = new OpenFileDialog() { Filter = "Excel Workbook|*.xlsx", ValidateNames = true })
            {
                if (ofd.ShowDialog() == DialogResult.OK)
                {
                    FileStream fs = File.Open(ofd.FileName, FileMode.Open, FileAccess.Read);
                    IExcelDataReader reader = ExcelReaderFactory.CreateOpenXmlReader(fs);
                    reader.IsFirstRowAsColumnNames = true;
                    result = reader.AsDataSet();
                    Sheetname.Items.Clear();
                    foreach (DataTable dt in result.Tables)
                        Sheetname.Items.Add(dt.TableName);
                    reader.Close();
                }
            }
        }

        private void Sheetname_SelectedIndexChanged(object sender, EventArgs e)
        {
            dataview.DataSource = result.Tables[Sheetname.SelectedIndex];
        }
    }
}

推荐答案

参见 Microsoft.Office.Interop.Excel namespace（） [ ^ ]。

这篇关于来自excel的数据和来自用户的输入之间的计算？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！