Hello all,
I am new here and new to asp.
My boss just told me to make a webpage that can read from a excel file and display the columns and the rows of that excel file.
I can use either classic asp or asp.net
I have no idea where to start. Can someone help me .
anything would help.

thanks

The best way to read the data would be by converting the excel file to csv (comma separated values). Then it would be simple enough to read the file in as a variable, split it into an array based on the new line character (into rows), then split each row into columns on the comma character. Hence you would have a 2D array of the spreadsheet which you could output as required. As long as the excel file was not too big it would work fine.

What sort of data are you planning to store?

Ok,
the excel file is going to have 6 columns!
How do I fit everything into a 2D array.

The issues is that they keep updating the excel file.

thanks

I'm working on a very similar situation, but using PHP and mySQL. I built a simple uploader for the client to upload the excel file as a csv file. The same script sent me an email telling me to import it using mysqlimport -p -v -d --local --fields-terminated-by=','
--lines-terminated-by='\n' etc.... i'm sure if i was less lazy i could make this automated, but to make a long story short, putting excel files into databases works well.