Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > "Unable to Open File" - excel output of Datagrid <-help needed

Thread Tools

"Unable to Open File" - excel output of Datagrid <-help needed

Steve Chatham
Posts: n/a
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 &

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.


Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Open an Excel File in Excel, not HTML viza HTML 0 07-07-2008 11:04 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
Excel 2003 cannot open Output file Fendi Baba ASP .Net 0 05-18-2007 11:24 AM
How to on word doc output (page setup, streaming html and datagrid, open file) Andrew ASP .Net 1 10-05-2005 02:57 PM
Excel open automatically without giving a dialog box option to Open/Save/Cancel using filesys.create eddie wang ASP General 0 10-03-2003 04:05 PM