Skip to main content
December 7, 2022
Question

Retrieving the Excell Highlighted rows

  • December 7, 2022
  • 2 replies
  • 0 views

Hi,

I am doing like saving excel sheet to data base and retrieving same data from the user from same excel sheet after editing by the user,

where he can upload through file upload component.

I am getting the data as well as saving the data through export datastore entity to excel

But i want like in excel one of the field is highlighted i send to the user and he need to edit the excel and same highlighted field need to come.

Highlighted field in the sense like any color to the field or row of particular data. 

How to get the highlighted field after, where we send the excel sheet...that particular row he will edit and send back? i am not getting highlighted field while i am getting the data with out errors.

    2 replies

    amitk9244
    December 13, 2022

    I want to store selected column from Excel to database, can you help in do so

    vinays024987
    December 13, 2022

    You will need to create a Staging table to store all data and then retrieve and store desired data into main table.