Gurus in the house, is there any way that i can query data that is in excel to appear in to a html web page?

Hmn, i believe i discussed that somewhere on my blog not too long ago, let me see

One of the constant headaches of developers especially when dealing with applications that will require massive data upload such as stock exchange data, school results, name list, mailing lists and other spreadsheets is how to import these data directly into the database or at least convert it into an array and do whatever you wish to after that.
There are many classes that can handle this online, however, there are PROs and CONs to using these classes. I have found out from experience that PHPExcel is simply one of the best classes to handle this. This library can read do a lot of work, however, I am focusing on the ability to read excel data (CSV,XLS,XLSX) into PHP arrays - both active worksheet and entire worksheets.

Read more here - http://dhtmlhub.com/blogs/15

supercharged: Gurus in the house, is there any way that i can query data that is in excel to appear in to a html web page?

It definitely can be done. But you didn't indicate what platform/language you wish to use so that you can get help from the right people who are knowledgeable with your preferred tool set.

uken73:
It definitely can be done. But you didn't indicate what platform/language you wish to use so that you can get help from the right people who are knowledgeable with your preferred tool set.

Preferably php along side mySQL. My thot is to querry the data from excel into a mySQL database.

supercharged:

Preferably php along side mySQL. My thot is to querry the data from excel into a mySQL database.

Now that you've defined the areas of assistance better, the PHP/MySQL experts should be able to help you. I'm not into PHP/MySQL.

uken73:
Now that you've defined the areas of assistance better, the PHP/MySQL experts should be able to help you. I'm not into PHP/MySQL.

Your own idea might shed some light. What language do u use?

supercharged:

Your own idea might shed some light. What language do u use?

I currently use mostly VB.NET. But other languages I have knowledge of include Java, C#.NET & C++(been ages I last did a project on that). I had used Oracle PL/SQL for my final year project but have not done anything with it since then.

In VB you would reference an appropriate library (Microsoft.Office.Interop.Excel) for excel manipulations

'Following are code snippets to access Excel

Imports Microsoft.Office.Interop 'Importing of supporting library for Microsoft Office operations

        Dim exApp As Excel.Application = New Excel.Application() 'Create an excel application object
        Dim wkbook As Excel.Workbook = exApp.Workbooks.Open("c:\excelfile.xls", , True)  'Open the excel file
        Dim BroadSheet As Excel.Worksheet = wkbook.Worksheets("BroadSheet" 'Select a particular worksheet to work on.
	Dim cell As Excel.Range = BroadSheet.Cells(1, 2) 'select a cell at row 1, column 2
	cell.Value = "some value" 'set a new value to the selected cell
	Dim cellValue as String=cell.value 'read the value from the selected cell.

	'following requests releases of resources held by the variables by invoking a method named releaseObject.

        releaseObject(exApp) 
        releaseObject(wkbook)
        releaseObject(BroadSheet)


'Implemention of the release object method
    Private Shared Sub releaseObject(ByVal obj As Object)
        Try
            System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
            obj = Nothing
        Catch ex As Exception
            obj = Nothing
        Finally
            GC.Collect()
        End Try
    End Sub

^^^
Conceptually,it seems there's no difference btw vb and other mainstream imperative languages (java,c#,python).
Nothing = null
End = delimiter( {} ).
Etc.

The syntax is just bloated up to reduce the fright factor for learners. (Beginners are mor comfortable with vb than other languages)

uken73:
I currently use mostly VB.NET. But other languages I have knowledge of include Java, C#.NET & C++(been ages I last did a project on that). I had used Oracle PL/SQL for my final year project but have not done anything with it since then.

In VB you would reference an appropriate library (Microsoft.Office.Interop.Excel) for excel manipulations

'Following are code snippets to access Excel

Imports Microsoft.Office.Interop 'Importing of supporting library for Microsoft Office operations

        Dim exApp As Excel.Application = New Excel.Application() 'Create an excel application object
        Dim wkbook As Excel.Workbook = exApp.Workbooks.Open("c:\excelfile.xls", , True)  'Open the excel file
        Dim BroadSheet As Excel.Worksheet = wkbook.Worksheets("BroadSheet" 'Select a particular worksheet to work on.
	Dim cell As Excel.Range = BroadSheet.Cells(1, 2) 'select a cell at row 1, column 2
	cell.Value = "some value" 'set a new value to the selected cell
	Dim cellValue as String=cell.value 'read the value from the selected cell.

	'following requests releases of resources held by the variables by invoking a method named releaseObject.

        releaseObject(exApp) 
        releaseObject(wkbook)
        releaseObject(BroadSheet)


'Implemention of the release object method
    Private Shared Sub releaseObject(ByVal obj As Object)
        Try
            System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
            obj = Nothing
        Catch ex As Exception
            obj = Nothing
        Finally
            GC.Collect()
        End Try
    End Sub

This is a good heads up. I'll have to research on vb. i think the last time i used it was in my second year... but i believe sql will be smoother

supercharged:

This is a good heads up. I'll have to research on vb. i think the last time i used it was in my second year... but i believe sql will be smoother

Mind you, that is actually VB.NET. I believe libraries for PHP also exists. I guess that is what dhtml18 is talking about in his post.

Hmmm