如何在excel中找到带有某个关键字的最后一行

羞愧

假设我有一个有 5 列和 600 行的 excel 文件，第一列有一个 id，第二列是名字，第三列是姓氏，一次是第 4 列和第 5 列。

我需要在消息框中输入一个 ID，然后在这个 excel 文件中查找该 ID。但是excel文件中多次包含此ID。我将如何在第一列中找到具有此 ID 的最后一行？此条目在第 5 列中还没有时间，目的是将当前时间添加到其中。

提前致谢！

羞愧

我自己找到了解决方案。

 Excel.Application Appl = null;
            Workbook opennwb = null;
            Worksheet wss = null;
            Workbooks opennwbs = null;
            // Save the whole row
            try
            {
                Appl = new Excel.Application();

                opennwbs = Appl.Workbooks;

                opennwb = opennwbs.Open(path,
                   Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                   Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                   Type.Missing, Type.Missing, Type.Missing, Type.Missing);

                wss = opennwb.Worksheets[DateTime.Now.ToString("MM-dd-yy").ToString()];

                // Get the count of row and column
                int rows = wss.UsedRange.Rows.Count;
                int columns = 1;
                // Traverse all data
                for (int row = 1; row <= rows; row++)
                {
                    for (int column = 1; column <= columns; column++)
                    {
                        string temp = ((Range)wss.Cells[row, column]).Text.ToString();
                        // If true, get the correspond row
                        if (barcode == temp)
                        {


                            usedrow = row;



                        }

                    }

                }

                return usedrow;
            }
            finally
            {
                //MessageBox.Show("about to quit query excel");


                //release all memory - stop EXCEL.exe from hanging around.

                if (opennwb != null) { opennwb.Close(); Marshal.FinalReleaseComObject(opennwb); opennwb = null; } //release each workbook like this
                if (wss != null) { Marshal.FinalReleaseComObject(wss); wss = null; } //release each worksheet like this
                if (opennwbs != null) { opennwbs.Close(); Marshal.FinalReleaseComObject(opennwbs); opennwbs = null; }
                if (Appl != null) { Appl.Quit(); Marshal.FinalReleaseComObject(Appl); Appl = null; } //release the Excel application 

                GC.Collect();

                //MessageBox.Show("Query closed");

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。