Implement Spreadsheet in ASP.Net Core

[JNickVAParticipant]

I should add that I tried to use the OpenXML Tools SDK but that will not load in a ASP.Net Core project.

[Jim SnyderParticipant]

I can’t help you with ASP.Net Core, but when I get no output, it is nearly always because I have the XML mismatched. Since XML definitions have order, the adding of OpenXML parts have to match. Here is the order (also obtainable by opening a spreadsheet renamed to .zip):
`<complexType name=”CT_Worksheet”>
<sequence>
<element name=”sheetPr”/>
<element name=”dimension”/>
<element name=”sheetViews”/>
<element name=”sheetFormatPr”/>
<element name=”cols”/>
<element name=”sheetData”/>
<element name=”sheetCalcPr”/>
<element name=”sheetProtection”/>
<element name=”protectedRanges”/>
<element name=”scenarios”/>
<element name=”autoFilter”/>
<element name=”sortState”/>
<element name=”dataConsolidate”/>
<element name=”customSheetViews”/>
<element name=”mergeCells”/>
<element name=”phoneticPr”/>
<element name=”conditionalFormatting”/>
<element name=”dataValidations”/>
<element name=”hyperlinks”/>
<element name=”printOptions”/>
<element name=”pageMargins”/>
<element name=”pageSetup”/>
<element name=”headerFooter”/>
<element name=”rowBreaks”/>
<element name=”colBreaks”/>
<element name=”customProperties”/>
<element name=”cellWatches”/>
<element name=”ignoredErrors”/>
<element name=”smartTags”/>
<element name=”drawing”/>
<element name=”legacyDrawing”/>
<element name=”legacyDrawingHF”/>
<element name=”picture”/>
<element name=”oleObjects”/>
<element name=”controls”/>
<element name=”webPublishItems”/>
<element name=”tableParts”/>
<element name=”extLst”/>
</sequence>
</complexType>
Note the <sequence> tag*

*This is copied from Vincent Tan’s “Spreasdsheet OpenXML From Scratch”. Vincent also has a chapter on “142 How to export your Open XML spreadsheet in ASP.NET”

[Author]

Posts