By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,290 Members | 1,426 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,290 IT Pros & Developers. It's quick & easy.

Exporting Datagrid to Excel (unable to read file)

P: n/a
Hi,
Is there anything wrong with the code below in sending my browser page to
Excel? Before my page opens in Excel there's a message "Problems came up in
the following areas during load:" and it shows a CSS file in the "temporary
internet files" path. But when i click OK the page displays beautifully.
Even though my page has 3 datagrids, they all display with the same style as
seen in the browser page.

Though, the second problem is, when i try to export a datagrid which has
many rows, it will not export at all and a popup "unable to read file"
displays and Excel just shows gray blankness. Here is the code that i'm am
using:

Public Shared Sub ExportToExcel(ByVal argDG As DataGrid, ByVal argPage
As Page)

Dim resp As HttpResponse
resp = argPage.Response
resp.ContentType = "application/download"
resp.AppendHeader("Content-Disposition",
"attachment;filename=GLdata.xls")
Dim colHeaders As String

Dim tw As New System.IO.StringWriter
Dim hw As New System.Web.UI.HtmlTextWriter(tw)

argDG.RenderControl(hw)

End Sub

Jun 20 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
As far as the row count - I believe there is a limit of around 65,000 rows
for Excel - - how many rows need to be exported?

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://iWritePro.com

"John Walker" <Jo********@discussions.microsoft.comwrote in message
news:F0**********************************@microsof t.com...
Hi,
Is there anything wrong with the code below in sending my browser page to
Excel? Before my page opens in Excel there's a message "Problems came up
in
the following areas during load:" and it shows a CSS file in the
"temporary
internet files" path. But when i click OK the page displays beautifully.
Even though my page has 3 datagrids, they all display with the same style
as
seen in the browser page.

Though, the second problem is, when i try to export a datagrid which has
many rows, it will not export at all and a popup "unable to read file"
displays and Excel just shows gray blankness. Here is the code that i'm
am
using:

Public Shared Sub ExportToExcel(ByVal argDG As DataGrid, ByVal argPage
As Page)

Dim resp As HttpResponse
resp = argPage.Response
resp.ContentType = "application/download"
resp.AppendHeader("Content-Disposition",
"attachment;filename=GLdata.xls")
Dim colHeaders As String

Dim tw As New System.IO.StringWriter
Dim hw As New System.Web.UI.HtmlTextWriter(tw)

argDG.RenderControl(hw)

End Sub

Jun 20 '07 #2

P: n/a
check out this code sample at ASPNet101.com:
http://www.aspnet101.com/aspnet101/a...=ExportDGExcel

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://iWritePro.com

"John Walker" <Jo********@discussions.microsoft.comwrote in message
news:F0**********************************@microsof t.com...
Hi,
Is there anything wrong with the code below in sending my browser page to
Excel? Before my page opens in Excel there's a message "Problems came up
in
the following areas during load:" and it shows a CSS file in the
"temporary
internet files" path. But when i click OK the page displays beautifully.
Even though my page has 3 datagrids, they all display with the same style
as
seen in the browser page.

Though, the second problem is, when i try to export a datagrid which has
many rows, it will not export at all and a popup "unable to read file"
displays and Excel just shows gray blankness. Here is the code that i'm
am
using:

Public Shared Sub ExportToExcel(ByVal argDG As DataGrid, ByVal argPage
As Page)

Dim resp As HttpResponse
resp = argPage.Response
resp.ContentType = "application/download"
resp.AppendHeader("Content-Disposition",
"attachment;filename=GLdata.xls")
Dim colHeaders As String

Dim tw As New System.IO.StringWriter
Dim hw As New System.Web.UI.HtmlTextWriter(tw)

argDG.RenderControl(hw)

End Sub

Jun 20 '07 #3

P: n/a
Thank you! that helped - i wasnt setting EnableViewState to False, so that
solved my "unable to read file" problem.

But, i'm still getting the problem of a prompt window saying that it cant
find the CSS file... is there a way to not have it prompt? i dont care if it
cant find the CSS, i just dont want the user to have to click ok.

"David Wier" wrote:
check out this code sample at ASPNet101.com:
http://www.aspnet101.com/aspnet101/a...=ExportDGExcel

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://iWritePro.com

"John Walker" <Jo********@discussions.microsoft.comwrote in message
news:F0**********************************@microsof t.com...
Hi,
Is there anything wrong with the code below in sending my browser page to
Excel? Before my page opens in Excel there's a message "Problems came up
in
the following areas during load:" and it shows a CSS file in the
"temporary
internet files" path. But when i click OK the page displays beautifully.
Even though my page has 3 datagrids, they all display with the same style
as
seen in the browser page.

Though, the second problem is, when i try to export a datagrid which has
many rows, it will not export at all and a popup "unable to read file"
displays and Excel just shows gray blankness. Here is the code that i'm
am
using:

Public Shared Sub ExportToExcel(ByVal argDG As DataGrid, ByVal argPage
As Page)

Dim resp As HttpResponse
resp = argPage.Response
resp.ContentType = "application/download"
resp.AppendHeader("Content-Disposition",
"attachment;filename=GLdata.xls")
Dim colHeaders As String

Dim tw As New System.IO.StringWriter
Dim hw As New System.Web.UI.HtmlTextWriter(tw)

argDG.RenderControl(hw)

End Sub


Jun 20 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.