How can we automatically pull info from a XLS spreadsheet?

MyPoint CreditUnion 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!

xls spreadsheet

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

MyPoint CreditUnion answered on June 18, 2014 10:13

Thanks for the help Brenden and Yehuda.

0 votesVote for this answer Mark as a Correct answer