How can we automatically pull info from a XLS spreadsheet?

Ryan R asked on June 17, 2014 14:12

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!

Correct Answer

Yehuda Lando answered on June 17, 2014 15:21

You can create a scheduled task to get the data from the file and insert it into a custom table.

0 votesVote for this answer Unmark Correct answer

Recent Answers


Brenden Kehren answered on June 18, 2014 07:42

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.

0 votesVote for this answer Mark as a Correct answer

Ryan R answered on June 18, 2014 10:13

Thanks for the help Brenden and Yehuda.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.