S
Steve Chatham
I am stuck on this. It ought to be a simple reason as to why this is
problematic, in that it works on smaller groups of data (say under 40
records), but doesn't on larger groups of records (40+).
I'm displaying 9 columns in a datagrid, and have a radiobutton at the top of
the page that says Web, Excel & Word. Web is selected by default. If you
click one of the other two buttons, this code is executed:
Private Sub RbtnExport_SelectedIndexChanged(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles RbtnExport.SelectedIndexChanged
DataGrid1.AllowSorting = False
RbtnExport.Visible = False
btnReset.Visible = False
btnReports.Visible = False
Response.Charset = ""
EnableViewState = False
Dim sFile As String = Session("User") & "-Product List-" & Today()
sFile = sFile.Replace("/", "")
RbtnExport.Visible = False
Select Case RbtnExport.SelectedItem.Value
Case "Excel"
Response.ContentType = "application/vnd.x-msexcel"
Case "Word"
Response.ContentType = "application/msword"
End Select
Response.AddHeader("Content-Disposition", "Attachment; filename=" & sFile &
".xls")
btnReset.Visible = True
btnReports.Visible = True
RbtnExport.Visible = True
DataGrid1.AllowSorting = True
EnableViewState = True
End Sub
The smaller datagrids display fine, but anything more than 40 records
(approx 1K per record), doesn't work. When I save the file, it saves as
whatever.xls, and on a File/Open or a double click, it'll give me an "Unable
to read file." message and an OK box in Excel. You click on OK, and nothing
is loaded.
Small (20-30 records) files (approx 25K) work fine. I do nothing any
different in displaying a 75 record file than I do here, but Excel simply
will not open it.
I have tried several other options, looking at aspone.excel, and also trying
the render html option but that doesn't work - I get an error about a
control being outside a form or something. I even tried a component that
did all that, and all it would ever return is a blank page.
I am at the end of my rope on this one. Would appreciate any help.
SC
problematic, in that it works on smaller groups of data (say under 40
records), but doesn't on larger groups of records (40+).
I'm displaying 9 columns in a datagrid, and have a radiobutton at the top of
the page that says Web, Excel & Word. Web is selected by default. If you
click one of the other two buttons, this code is executed:
Private Sub RbtnExport_SelectedIndexChanged(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles RbtnExport.SelectedIndexChanged
DataGrid1.AllowSorting = False
RbtnExport.Visible = False
btnReset.Visible = False
btnReports.Visible = False
Response.Charset = ""
EnableViewState = False
Dim sFile As String = Session("User") & "-Product List-" & Today()
sFile = sFile.Replace("/", "")
RbtnExport.Visible = False
Select Case RbtnExport.SelectedItem.Value
Case "Excel"
Response.ContentType = "application/vnd.x-msexcel"
Case "Word"
Response.ContentType = "application/msword"
End Select
Response.AddHeader("Content-Disposition", "Attachment; filename=" & sFile &
".xls")
btnReset.Visible = True
btnReports.Visible = True
RbtnExport.Visible = True
DataGrid1.AllowSorting = True
EnableViewState = True
End Sub
The smaller datagrids display fine, but anything more than 40 records
(approx 1K per record), doesn't work. When I save the file, it saves as
whatever.xls, and on a File/Open or a double click, it'll give me an "Unable
to read file." message and an OK box in Excel. You click on OK, and nothing
is loaded.
Small (20-30 records) files (approx 25K) work fine. I do nothing any
different in displaying a 75 record file than I do here, but Excel simply
will not open it.
I have tried several other options, looking at aspone.excel, and also trying
the render html option but that doesn't work - I get an error about a
control being outside a form or something. I even tried a component that
did all that, and all it would ever return is a blank page.
I am at the end of my rope on this one. Would appreciate any help.
SC