如何将五个excel文件导入C＃并进行一些数学运算，如矩阵乘法？ [英] How do I import five excel file to C# and doing some math operation like matrix multiplication between them?

问题描述

嗨
我在一个excel文件和单独的工作表中有五个矩阵（大小为40x30）。我将它们导入c＃作为DataTable，现在我想做一些数学运算，比如这个DataTables之间的矩阵乘法（我的意思是DataTable1 * DataTable2 * DataTable3 ......）。我知道在Datatable上做这样的事情可能很长很无聊或者不可能。

对我来说最好的方式是什么？

谢谢。



我尝试了什么：

Hi I have five matrix (with size 40x30 ) in one excel file and separate sheet. i import them to c# as DataTable, and now i want to doing some math operation like matrix multiplication between this DataTables(i mean DataTable1*DataTable2*DataTable3... ). i know that doing something like this on Datatable maybe is very long and boring or impossible.
what is the best way for me?
thanks.

What I have tried:

private void btnLoadExcel_Click(object sender, EventArgs e)
        {
            string connstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + txtPath.Text + ";Extended Properties=\"Excel 8.0;HDR=Yes;\";";   

            OleDbConnection conn = new OleDbConnection(connstring);
            OleDbDataAdapter ada1 = new OleDbDataAdapter("Select * from [" + "Sheet1" + "$]", conn);
            OleDbDataAdapter ada2 = new OleDbDataAdapter("Select * from [" + "Sheet2" + "$]", conn);
            OleDbDataAdapter ada3 = new OleDbDataAdapter("Select * from [" + "Sheet3" + "$]", conn);
            OleDbDataAdapter ada4 = new OleDbDataAdapter("Select * from [" + "Sheet4" + "$]", conn);
            DataTable dt1 = new DataTable();
            DataTable dt2 = new DataTable();
            DataTable dt3 = new DataTable();
            DataTable dt4 = new DataTable();
            ada1.Fill(dt1);
            ada2.Fill(dt2);
            ada3.Fill(dt3);
            ada4.Fill(dt4);

推荐答案

，conn）;
OleDbDataAdapter ada2 = new OleDbDataAdapter（ 选择*来自[ + Sheet2 +

", conn); OleDbDataAdapter ada2 = new OleDbDataAdapter("Select * from [" + "Sheet2" + "

，conn）;
OleDbDataAdapter ada3 = new OleDbDataAdapter（ 从[ + 中选择* Sheet3 +

", conn); OleDbDataAdapter ada3 = new OleDbDataAdapter("Select * from [" + "Sheet3" + "

，conn）;
OleDbDataAdapter ada4 = new OleDbDataAdapter（ Sele ct *来自[ + Sheet4 +

", conn); OleDbDataAdapter ada4 = new OleDbDataAdapter("Select * from [" + "Sheet4" + "

这篇关于如何将五个excel文件导入C＃并进行一些数学运算，如矩阵乘法？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！