How can I capture the last row of a very large Excel table and input it into a web page?

Help Activities
1

Hi Team,

I’m working on a task where I need to capture the last row of a very large Excel table and input that data into a web page. Given the size of the table, I’m looking for efficient ways to accomplish this.

Does anyone have suggestions or methods that might work for this process? Here are some specific points I’m considering:

  • Extracting the Last Row: What’s the best way to programmatically or manually identify and extract the last row from such a large Excel sheet?
  • Data Handling: How can I ensure that the data from the last row is accurately captured and formatted for web input?
  • Automation: Are there tools or scripts that you would recommend for automating this process?
  • Web Input: What’s the best approach to input the extracted data into the web page or form efficiently?

Any insights or recommendations you could share would be greatly appreciated!

Thanks in advance for your help.

Best regards,
Darshan Hiranandani

2

Hi @darshanhiranandani23

Try this

The image depicts a workflow sequence in UiPath where an Excel workbook is read, the last row is assigned to a variable, and the variable's value is displayed in a message box. (Captioned by AI)

Str_LastRow = String.Join(", ", dt.AsEnumerable().LastOrDefault().ItemArray.Select(Function(value) value.ToString()))

Regards,