05-09-2022 2:46 PM
I want to upload an excel file containing many worksheets to table and then show traffic light if record is present in the row of excel. Also help how to separate sub headings within the excel. Different worksheet records starts with different row and each row contains customer details for example transaction details but after some rows there is subheading of another customer and that customer contains its transaction details. Hope you understand my question. Please help me fix this.
05-09-2022 3:03 PM
05-09-2022 3:47 PM
I understand the raw requirement, but not what the specific question is.
05-11-2022 9:43 AM
So here is the requirement.
This excel file contains many sheets.
I need to upload data of all the sheets to a custom table and display all the records from the excel file using ALV display.
If record is successfully saved display record using green light else red light.
For example in the excel image above in line number 4, 6, 10 and 12 record is not present so there we have to display red traffic light and in other line record is present so there it will show green light.
Also start reading of records after the payno date and message i.e after line number 3.
Output will be something like this.
05-11-2022 12:35 PM
05-12-2022 5:32 AM
My question is how do i upload this excel file(with multiple sheets) to a custom table containing all the fields made by me and then show the records uploaded in alv display so that wherever record is present show green traffic light and where ever record is not present show red traffic light. For example in line number 7 the record has payment number, date and message so in alv display make it as green light and in line number 10 the record is blank so make it red traffic light in alv display