Upload an excel file, then transform the data and display it.

Question

Hi, I need an example on how to upload an excel file, transform the data in it (without touching the excel file), and finally to display the transformed data and save it into a database table.

My main confusion in this is on how do I configure the file directory on the server to save the uploaded excel files to, and how do I find and transform only a particular column (ex: first names & last names are all capitalized)

Thanks in advance.

Ramya Sivakumar · Answer

Hi Cheong,Greetings
from Syncfusion.We are
checking the feasibility to provide the sample for your requirement, and we
will provide the sample in 2 business days, on September 28, 2022.Regards,Ramya

Ramya Sivakumar · Answer

HiPlease try the below sample to transform the Excel file as
table and display itSample link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/F-1777521082992085Regards,Ramya