Databases
StackOverflow2013
Postsdbo
POHow do I have Open XML spreadsheet "uncollapse" cells in a spreadsheet?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I have Open XML spreadsheet "uncollapse" cells in a spreadsheet?
    primarykey
    data
    text
    <p>I'm working with xslx Excel file on the server side in C#. In a spreadsheet, say there are 15 columns (cells) total. In the rows of cells, some values are missing. So the first row is my header will properly have the 15 cells. But my data rows, some cells might have empty values, so Open XML has a "jagged" set of cells values. Row 1 will have the full 15 cells, Row 2 might have 13 cells since two of the values are empty. What! How do I map this data properly? It basically shifts everything to the left and my cell values are wrong. What am I missing? It seems like they are being "collapsed" in Open XML terminology.</p> <pre><code>WorkbookPart workbookPart = spreadSheetDocument.WorkbookPart; IEnumerable&lt;Sheet&gt; sheets = spreadSheetDocument.WorkbookPart.Workbook.GetFirstChild&lt;Sheets&gt;().Elements&lt;Sheet&gt;(); string relationshipId = sheets.First().Id.Value; WorksheetPart worksheetPart = (WorksheetPart)spreadSheetDocument.WorkbookPart.GetPartById(relationshipId); Worksheet workSheet = worksheetPart.Worksheet; SheetData sheetData = workSheet.GetFirstChild&lt;SheetData&gt;(); IEnumerable&lt;Row&gt; rows = sheetData.Descendants&lt;Row&gt;(); </code></pre> <p>CLARIFICATION: Here's another way to ask this question. What if I want to take the contents on an Excel file and put it into a DataTable. I want all the columns of data to line up correctly. How could I accomplish this?</p> <p>This question is asked better than I here: <a href="https://stackoverflow.com/questions/3837981/reading-excel-open-xml-is-ignoring-blank-cells">reading Excel Open XML is ignoring blank cells</a></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USShane
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow do I have Open XML spreadsheet "uncollapse" cells in a spreadsheet?
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POHow do I have Open XML spreadsheet "uncollapse" cells in a spreadsheet?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow do I have Open XML spreadsheet "uncollapse" cells in a spreadsheet?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COMS article somewhat on the topic: http://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.row.aspx
      singulars
      1. POHow do I have Open XML spreadsheet "uncollapse" cells in a spreadsheet?
      1. USShane
    2. COCan you elaborate? Are you modifying an existing xlsx file and the output is wrong? Are you trying to read data from an existing xlsx file and the OpenXML cells aren't what you expect? Having trouble understanding the problem, and what your code is trying to accomplish.
      singulars
      1. POHow do I have Open XML spreadsheet "uncollapse" cells in a spreadsheet?
      1. USSapph
    3. COTrying to read in an XLSX file and do work with it. For example, this: foreach (Row row in rows) But in row one, it has the proper 15 cells, row 2, has 13 cells only since in my Excel file, two are just empty strings. So it shifts all the data in Row2 over. Now all the cells are not mapped properly, so for Row 2, Cell 6 for example, it really is the value of Cell 7, which isn't right. Hard to explain i suppose.
      singulars
      1. POHow do I have Open XML spreadsheet "uncollapse" cells in a spreadsheet?
      1. USShane
 

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