E
Elad Frid
Hi
I'm trying to export a datagrid created in asp.net to excel using
VBScript
It's working great but how can I change the background colors, Sheet
name, alignment in the excel ?
Where can I find documentation about it ?
That the code I'm using
<script language= "vbscript">
Sub Button2_onclick()
Dim sHTML
sHTML = window.Form1.children("DataGrid1").outerhtml
Dim oXL, oBook
Set oXL = CreateObject("Excel.Application")
Set oBook = oXL.Workbooks.Add
oBook.HTMLProject.HTMLProjectItems("Sheet1").Text = sHTML
oBook.HTMLProject.RefreshDocument
oXL.Visible = true
oXL.UserControl = true
end sub
</script>
Thanks
Elad.
I'm trying to export a datagrid created in asp.net to excel using
VBScript
It's working great but how can I change the background colors, Sheet
name, alignment in the excel ?
Where can I find documentation about it ?
That the code I'm using
<script language= "vbscript">
Sub Button2_onclick()
Dim sHTML
sHTML = window.Form1.children("DataGrid1").outerhtml
Dim oXL, oBook
Set oXL = CreateObject("Excel.Application")
Set oBook = oXL.Workbooks.Add
oBook.HTMLProject.HTMLProjectItems("Sheet1").Text = sHTML
oBook.HTMLProject.RefreshDocument
oXL.Visible = true
oXL.UserControl = true
end sub
</script>
Thanks
Elad.