Hi all
I have a task which I am trying to complete, the task is to add excel data into a html snippet using dynamic tags to ‘pull’ the data
My spreadsheet has specifically 6 columns and around 650 rows that I need to merge into separate html snippets the snippet looks like this for reference
Overall the spreadsheet has around the 10different columns and I only need the data from some of them
<tr class="table__tr--success">
<td class="table__td--payment-status is-link u-is-actionable">
<a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/">
<div class="u-align-center u-direction-row">
<div class="status-disc status-disc--success u-margin-Rxs u-flex-none"><!-- react-empty: 31 --></div><div class="status-disc__inline u-align-center u-direction-row">
<span>Paid out</span>
</div></div></a></td>
<td class="is-link u-is-actionable"><a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/">
<div class="table__td--truncate-customer"><!-- react-text: 37 -->24-7 People Solutions Limited<!-- /react-text --></div>
</a></td>
<td class="table__td--payment-list-description--truncate is-link u-is-actionable">
<a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/">C230400062157</a>
</td>
<td class="is-link u-is-actionable">
<a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/"><span>
<span>Import</span></span></a></td>
<td class="table__td--date-cell u-text-right is-link u-is-actionable">
<a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/">08.06.23</a>
</td><td class="table__td--date-cell u-text-right is-link u-is-actionable">
<a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/">12.06.23</a>
</td><td class="u-text-right is-link u-is-actionable">
<a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/">
<span class=""><span class="amount__value">44.39</span><!-- react-text: 52 --> <!-- /react-text --><span class="amount__currency">GBP</span></span>
</a></td>
<td class="u-text-right is-link u-is-actionable">
<a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/"><strong><span class=""><span class="amount__value">43.62</span><!-- react-text: 59 --> <!-- /react-text --><span class="amount__currency">GBP</span></span></strong></a>
</td>
</tr>
The columns I need to fetch are:
Customer name
Payment reference number
Date requested
Date recieved
Gross value
Net value
How do I do this please??
I have a task which I am trying to complete, the task is to add excel data into a html snippet using dynamic tags to ‘pull’ the data
My spreadsheet has specifically 6 columns and around 650 rows that I need to merge into separate html snippets the snippet looks like this for reference
Overall the spreadsheet has around the 10different columns and I only need the data from some of them
<tr class="table__tr--success">
<td class="table__td--payment-status is-link u-is-actionable">
<a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/">
<div class="u-align-center u-direction-row">
<div class="status-disc status-disc--success u-margin-Rxs u-flex-none"><!-- react-empty: 31 --></div><div class="status-disc__inline u-align-center u-direction-row">
<span>Paid out</span>
</div></div></a></td>
<td class="is-link u-is-actionable"><a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/">
<div class="table__td--truncate-customer"><!-- react-text: 37 -->24-7 People Solutions Limited<!-- /react-text --></div>
</a></td>
<td class="table__td--payment-list-description--truncate is-link u-is-actionable">
<a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/">C230400062157</a>
</td>
<td class="is-link u-is-actionable">
<a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/"><span>
<span>Import</span></span></a></td>
<td class="table__td--date-cell u-text-right is-link u-is-actionable">
<a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/">08.06.23</a>
</td><td class="table__td--date-cell u-text-right is-link u-is-actionable">
<a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/">12.06.23</a>
</td><td class="u-text-right is-link u-is-actionable">
<a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/">
<span class=""><span class="amount__value">44.39</span><!-- react-text: 52 --> <!-- /react-text --><span class="amount__currency">GBP</span></span>
</a></td>
<td class="u-text-right is-link u-is-actionable">
<a class="u-text-truncate" href="/payments/PM00SVMM7Z807N/"><strong><span class=""><span class="amount__value">43.62</span><!-- react-text: 59 --> <!-- /react-text --><span class="amount__currency">GBP</span></span></strong></a>
</td>
</tr>
The columns I need to fetch are:
Customer name
Payment reference number
Date requested
Date recieved
Gross value
Net value
How do I do this please??