StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1466187
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-09-23T14:01:21.023
FavoriteCount
0
LastActivityDate
2009-09-24T16:40:23.680
LastEditDate
2009-09-24T16:40:23.680
LastEditorUserId
160359
OwnerUserId
160359
ParentId
1466166
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
<p>While I can't answer the maximum amount of data that Excel can handle, if you use the new .xlsx format, you are using MS's OpenXML format. The .xlsx file is actually a zip compressed file with all of the document data stored internally. The XML can be written just as any other XML, but you'll have to review the standards. There are a few commercial component implementations out there for doing this. You don't need Excel to write the format.</p> <p>Here are some helpful links:</p> <ul> <li><a href="http://en.wikipedia.org/wiki/Office_Open_XML" rel="nofollow noreferrer">Office OpenXML - Wikipedia</a></li> <li><a href="http://sourceforge.net/projects/officeopenxml/files/Open%20Xml%20Docx%20Alpha/Open%20Xml%20Docx%20Alpha%200.1%20Source/" rel="nofollow noreferrer">Office Open XML C# Library</a> - This looks like an open source library for reading/writing OpenXML</li> <li><a href="http://www.codeproject.com/KB/office/OpenXML.aspx" rel="nofollow noreferrer">Read and write Open XML files - CodeProject</a> - Another implementation of a R/W library</li> <li><a href="http://www.gemboxsoftware.com/GBSpreadsheet.htm" rel="nofollow noreferrer">GemBox.Spreadsheet</a> - A commercial .NET component for reading/writing office spreadsheets. Has a free version with limitations on number of rows you can read and write if you want to try it out.</li> <li><a href="http://npoi.codeplex.com/" rel="nofollow noreferrer">NPOI Library</a> - an implementation of Java's POI library for reading and writing office docs.</li> <li><a href="http://simpleooxml.codeplex.com/" rel="nofollow noreferrer">Simple OOXML</a> - "A set of helper classes to make the creation of Open Office XML documents easier. Uses the Open Office SDK v 2.0. Modify or create any .docx or .xlsx document without Microsoft Word or Microsoft Excel."</li> </ul>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWhat is the best way of generating a xslx file on a web site? Possibly with millions of rows?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USsnicker
UserOwnerUserId
1. USsnicker
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. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
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.