In my current Perl script, I am working on a functionality where I retrieve data from an xls file and display it as input text on a webpage. The objective is that when a user selects the edit option from a menu, the entire table fetched from the xls file will be displayed and the existing values will be shown in text boxes.
However, my challenge arises when the user edits the cells and clicks on save. Although I am able to send all the IDs to a Perl function, I struggle with mapping the edited cells back to their corresponding positions in the table.
For example, if a user enters a new value "A" for column 1, row 1 and another value "B" for column 2, row 1, how can I inform my Perl function that "A" should go to Column 1, Row 1 and "B" should go to Column 2, Row 1? Is there a way to achieve this mapping, similar to sending a 2D array to a Perl subroutine from a submit button using Ajax?