StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to generate MS-Excel file using ASP web application?
primarykey
Id
1749472
data
AcceptedAnswerId
8345264
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-11-17T15:04:27.053
FavoriteCount
0
LastActivityDate
2011-12-01T17:00:30.183
LastEditDate
2011-12-01T16:51:10.200
LastEditorUserId
3043
OwnerUserId
45255
ParentId
0
PostTypeId
1
Score
0
ViewCount
2077
LastEditorDisplayName
text
Body
As per my application I need to generate Excel files. I am able to generate excel files with: Response.ContentType = "application/vnd.ms-excel" in header and populating data by creating HTML Table. But while trying to create a file fetching it from server location and saving data into it(here we are creating excel object to generate file), the web page opens with DONE status with blank page and the source file shows data in HTML format. Where as I try to open the file explicitly using the path I am getting the following errors: it shows multiple errors like as follows: Note: ( MS-Excel DLL) is installed in the Server location. Error message-1: Macros may contain viruses. It is usually safe to disable macros, but if the macros are legitimate, you might lose some functionality. Note: There is no macro present in the file On Clicking Enable Macros gets the second Error message: The file could not be accessed. Try one of the following: <ol> <li>Make sure the specified folder exists. </li> <li>Make sure the folder that contains the file is not read-only.</li> <li>Make sure the file name does not contain any of the following characters < > ? [ ] : | or *</li> <li>Make sure the file/path name doesn't contain more than 218 characters.</li> </ol> Note: All of the above conditions holds true. And finally on clicking ok it shows the error message: This file is not in a recognizable format. Then it opens with encrypted format. Could anyone let me know what could be the problem?
Tags
<excel><asp-classic>
Title
How to generate MS-Excel file using ASP web application?
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USJoel Coehoorn
UserOwnerUserId
1. USSuman
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.