Geek Answers Handbook

OpenXml Spreadsheet. Unicode Value Filters, Styles, and Symbols

due to a little documentation I am having problems with OpenXml SpreadSheetDocument in C #.

  • How to make the top line with a filter?
  • How to make color alternative?
  • I want to put Unicode characters in my SheetData, but when I get excel out of the way, it gives me an error.
  • Change the color of the top line. Can you tell if there are any correct ways to do this, some more documents than these available in msdn, or send some StyleSheet code? Sorry for my English. Thanks.
+7
source share
2 answers

I think your question is really about how to create tables in a spreadsheet. Spreadsheets is a great feature of Open XML / Excel 2007/2010 that allows you to sort a range of cells by clicking on the column headings. They are also represented by alternative color bars for strings. There are additional features, such as the ability to have a common row and automatic expansion when inserting a row.

I wrote a blog post about spreadsheets and how to create them: Learning table layout in SpreadsheetML . In addition, I recorded a 15-minute screen shot that examines the layout, and shows how to create an Open XML SDK that converts regular cells to a table.

Eric

+2
source

I can’t give you a silver bullet, unfortunately, but what I did when trying to develop how to create Word documents with OpenXML was to work in Word and then examine the resulting .docx file to see what the effect was.

I suggest that the same investigation method can help you with your spreadsheet.

0
source

More articles:


All Articles