open excel template using asp

[paxa]

hi

is it possible to open a excel template using asp.net?

while i open the page the template file appears in the browser window??

if so is possible some help would be appreciated?

thanks in advance

Edited May 15, 2007 by paxa

[Josh]

Not really... unless there's a third party component that I'm not familiar with. You can use xls files as makeshift databases via OLEDB but other than that... I don't think so. There are no "excel controls" for the web.

An alternative, however, would be Google Spreadsheets.

https://www.google.com/accounts/NewServiceA...s.google.com%2F

[paxa]

ok...thanks for the help

[paxa]

scrape that....i've turned it to asp.net and i can already open or download the file.

but i need to fill the colums 1 to 10 and then 20 to 26.

and for that i'm using this function for it

Private Function dumpdat(ByVal _

dt As DataTable, ByVal ocells As Excel.Range) As String

'# fun??o para fazer o dump dos dados

'# vars

Dim dr As DataRow, ary() As Object

Dim iRow As Integer, iCol As Integer

'Output Column Headers

For iCol = 0 To dt.Columns.Count - 1

ocells(4, iCol + 1) = dt.Columns(iCol).ToString

Next

'Output Data

For iRow = 0 To dt.Rows.Count - 1

dr = dt.Rows.Item(iRow)

ary = dr.ItemArray

For iCol = 0 To UBound(ary)

ocells(iRow + 4, iCol + 1) = ary(iCol).ToString

Response.Write(ary(iCol).ToString & vbTab)

Next

Next

'#

End Function

any ideas?

help would be appreciated