来自excel的数据和来自用户的输入之间的计算? [英] Calculation between data from excel and input from user?
本文介绍了来自excel的数据和来自用户的输入之间的计算?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何根据用户键入我们在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屋!
查看全文