Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <h2>CSV</h2> <p>Pros: </p> <ul> <li>Simple</li> </ul> <p>Cons: </p> <ul> <li>It may not work in other locales or in different Excel configurations (i.e. List separator) </li> <li>Can't apply formatting, formulas, etc</li> </ul> <h2>HTML</h2> <p>Pros: </p> <ul> <li>Still pretty Simple </li> <li>Supports simple formating and formulas</li> </ul> <p>Cons:</p> <ul> <li>You have to name the file as xls and Excel may warn you about opening a non native Excel file</li> <li>One worksheet per workbook</li> </ul> <h2>OpenXML (Office 2007 .XLSX)</h2> <p>Pros:</p> <ul> <li>Native Excel format</li> <li>Supports all Excel features</li> <li>Do not <em>require</em> an install copy of Excel</li> <li>Can generate Pivot tables </li> <li>Can be generated using open source project <a href="http://epplus.codeplex.com/" rel="noreferrer">EPPlus</a></li> </ul> <p>Cons:</p> <ul> <li>Limited compatibility outside Excel 2007 (shouldn't be a problem nowadays)</li> <li>Complicated unless you're using a third party component</li> </ul> <h2>SpreadSheetML (open format XML)</h2> <p>Pros: </p> <ul> <li>Simple compared to native Excel formats</li> <li>Supports most Excel features: formating, styles, formulas, multiple sheets per workbook</li> <li>Excel does not need to be installed to use it</li> <li>No third party libraries needed - just write out your xml</li> <li>Documents can be opened by Excel XP/2003/2007</li> </ul> <p>Cons:</p> <ul> <li>Lack of good documentation</li> <li>Not supported in older versions of Excel (pre-2000)</li> <li>Write-only, in that once you open it and make changes from Excel it's converted to native Excel.</li> </ul> <h2>XLS (generated by third party component)</h2> <p>Pros: </p> <ul> <li>Generate native Excel file with all the formating, formulas, etc.</li> </ul> <p>Cons:</p> <ul> <li>Cost money</li> <li>Add dependencies</li> </ul> <h2>COM Interop</h2> <p>Pros:</p> <ul> <li>Uses native Microsoft libraries</li> <li>Read support for native documents</li> </ul> <p>Cons:</p> <ul> <li>Very slow</li> <li>Dependency/version matching issues</li> <li>Concurrency/data integrity issues for web use when reading</li> <li>Very slow</li> <li>Scaling issues for web use (different from concurrency): need to create many instances of heavy Excel app on the server</li> <li>Requires Windows</li> <li>Did I mention that it's slow?</li> </ul>
    singulars
    1. This table or related slice is empty.
    1. POGenerating an Excel file in ASP.NET
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJoel Coehoorn
    1. USEduardo Molteni
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POGenerating an Excel file in ASP.NET
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThe "Write-only" constraint mentioned for SpreadsheetML is not fully an issue, since you can save an excel file as SpreadsheetML if you wish.
      singulars
      1. PO
      1. USBrian
    2. COSpreadsheetML may crash Excel 2003 if you create big files with it. Don't trust it :/
      singulars
      1. PO
      1. USBrian
    3. COYou can Save back to a SpreadsheetML file just fine in Office 2002 and 2003. No Save As required. SpreadsheetML cannot store macros, charts, graphics, and a few other odds and ends, including the new features of Office 2007 (e.g., more than 3 conditional formats). Since XML is verbose, Zipping SpreadsheetML before sending from the server (using SharpZipLib is an option) works great to reduce download times--actually, it should be mentioned that OpenXML is stored in a ZIP container anyway. @Brian: I use complex SpreadsheetML in the 50-100MB range on a daily basis without crashing problems.
      singulars
      1. PO
      1. USrichardtallent
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload