c # array matching excel

Hello guys, now I want to do this in C # in the form of a dream I made in Excel. Will be a texBox There will be a label to print, When I type 1-1 in Texbox, the label will output: 1 21 30 12 could not decode the codes:

1-1	1	21	30	12
1-2	30	12	25	33
1-3	18	27	16	32
1-4	11	28	2	16
1-5	16	19	36	7
1-6	23	3	34	20
1-7	9	34	5	0
1-8	24	32	27	18
1-9	14	25	23	3
1-10	16	15	13	18
1-11	5	6	9	-
1-12	22	6	24	0
1-13	10	26	6	14
1-14	20	2	8	35
1-15	6	24	0	-
1-16	33	4	11	28
1-17	8	35	17	1
1-18	31	17	10	26
1-19	13	33	15	-
1-20	20	21	30	28
1-21	11	12	2	1
1-22	31	25	23	35
1-23	24	15	13	29
1-24	33	19	36	29
1-25	30	35	25	20
1-26	29	27	16	0
1-27	33	26	34	31
1-28	22	34	5	26
1-29	9	17	10	3
1-30	5	32	27	18
1-31	14	2	8	12
1-32	34	5	0	-
1-33	1	4	11	7
1-34	8	3	17	14
1-35	18	6	24	0
1-36	10	0	6	9
2-1	30	12	25	33
2-2	2	14	3	30
2-3	16	15	13	18
2-4	21	20	35	11
2-5	36	7	21	24
2-6	17	9	0	23
2-7	5	6	9	-
2-8	27	29	19	24
2-9	23	3	34	20
2-10	13	7	4	16

Hi,I worked out the following code snippet for you by using Spire.XLS for .NET. Hope it helps.

using Spire.Xls;
using System.Windows.Forms;
namespace GetCellValue
{
public partial class Form1 : Form
{
Worksheet sheet;
string newString;
public Form1()
{
InitializeComponent();
//Load excel file
Workbook workbook = new Workbook();
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\test.xlsx");
//Get first sheet
sheet = workbook.Worksheets[0];
}
private void textBox1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
//Find the cell containing keyword
CellRange cell = sheet.FindString(textBox1.Text, false, false);
//Get the row number and col number of the cell
int currentRow = cell.Row;
int currentCol = cell.Column;
for (int i = 1; i < 5; i++)
{
//Get the four cells' values after the certain cell
newString += sheet[currentRow, currentCol + i].Value + " ";
}
label1.Text = newString;
}
}
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vishwakarma Vijay5y ago
Hi,I worked out the following code snippet for you by using Spire.XLS for .NET. Hope it helps.
using Spire.Xls;
using System.Windows.Forms;

namespace GetCellValue
{
    public partial class Form1 : Form
    {
        Worksheet sheet;
        string newString;
        public Form1()
        {
            InitializeComponent();
            //Load excel file
            Workbook workbook = new Workbook();
            workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\test.xlsx");
            //Get first sheet
            sheet = workbook.Worksheets[0];
        }
        private void textBox1_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                //Find the cell containing keyword
                CellRange cell = sheet.FindString(textBox1.Text, false, false);
                //Get the row number and col number of the cell
                int currentRow = cell.Row;
                int currentCol = cell.Column;
                for (int i = 1; i < 5; i++)
                {
                    //Get the four cells' values after the certain cell
                    newString += sheet[currentRow, currentCol + i].Value + " ";
                }
                label1.Text = newString;
            }
        }
    }
}