Displays Excel Cells to web page C#

  • Thread starter Thread starter Sunny K
  • Start date Start date
S

Sunny K

Hi,

I need to display certain cells from an Excel spreadsheet to a
webpage.

For example; across the A,B,C columns I will have locations named (Eg
London, Leeds etc) and across the 1,2,3 rows I will have the same
locations (eg London, Leeds etc). Like you see in maps they include
distances between certain locations by reading across the columns and
rows and where they meet shows a distance.

I basically need to be able to read from a webpage, two locations
(which are on a spreadsheet) and for it to display the distance (which
is found by reading down and across the spreadsheet) to a webpage.

How easyily is this done, or does anyone know of any websites with a
walkthrough of how to do this. Im sure there are plenty examples of
this as it is a typical school/college project!

Thanks
Sunny
 
I have written a very simple component for simplifying the task of working
with
Excel using OLEDB.
It defines objects like ExcelBook, ExcelSheet, ExcelTableRow, ExcelTableCell
and ExcelDataType. I had to perform some Excel parsing, and using Automation
was not an option, but i think this component made the work more fun and
easy.
If you are interested, please tell me.

PS
Of course it is open and free.
 
Back
Top