I don't really know what topic to put this under, but can anyone tell me if it is possible to create a table on a page from a CSV file stored in the media folder?
Yes, this is possible. I suggest you write a .Net user control, let it know the media item it should render upon page load (aka provide as a parameter), then read out the CSV file and either put it in a custom data type and bind it to one of the .Net data controls (e.g. DataGrid) or create the html table row by row when reading the data.
CSV to Table
Hello,
I don't really know what topic to put this under, but can anyone tell me if it is possible to create a table on a page from a CSV file stored in the media folder?
Yes, this is possible. I suggest you write a .Net user control, let it know the media item it should render upon page load (aka provide as a parameter), then read out the CSV file and either put it in a custom data type and bind it to one of the .Net data controls (e.g. DataGrid) or create the html table row by row when reading the data.
Here is some info to read out a csv file in .Net: http://www.codeproject.com/KB/database/CsvReader.aspx, or probably even better in your case: http://netomatix.com/development/importcsvintogrid.aspx
Hope that helps,
Sascha
is working on a reply...