Possible for a webpage to read/export cells from Excel?

peterattheboro · 10 Jun 2008 at 14:03

Trying to create a webpage that will read monthly reports and want something like:

# of new clients = [ cell ]

Is this doable?

numnutz · 10 Jun 2008 at 14:24

Yup .net can do it.

eg. http://forums.devx.com/showthread.php?t=141855

peterattheboro · 10 Jun 2008 at 14:34

Thanks mate. Looks complicated tho!

meghatronic · 11 Jun 2008 at 23:56

... or easier with php:

http://www.ustrem.org/en/articles/reading-xls-with-php-en/

voodooflux · 12 Jun 2008 at 10:57

jdickerson said:
... or easier with php

It's not that hard in .NET either...

Code:

using Excel = Microsoft.Office.Interop.Excel;
 
...
 
Excel.Application excel = new Excel.Application();
 
Excel.Workbook workbook = excel.Workbooks.Open(@"Test.xlsx", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
 
Excel.Worksheet worksheet = workbook.Worksheets[1] as Excel.Worksheet;
Excel.Range range = worksheet.Cells["2", "C"] as Excel.Range;
 
Label1.Text = range.Value2.ToString();
 
excel.Quit();