I have a spreadsheet that is updated with new info every day. How can I set up a page/part that will grab certain fields and display them. I imagine that I could import into the database and then use some kind of repeater, but I would like to keep this info out of the database if possible.
Please let me know what to do or point me in the right direction to find out. Thanks!
You can create a scheduled task to get the data from the file and insert it into a custom table.
Here is what I do with other SQL data. It dynamically gets the columns and maps them based on the column names being the same in the custom table in Kentico.
Thanks for the help Brenden and Yehuda.
Please, sign in to be able to submit a new answer.