Stack Overflow
Stack Overflow

Questions tagged [spreadsheetml]

Part of the Office Open XML specification ECMA-376

Part of the Office Open XML specification ECMA-376, along with WordprocessingML, PresentationtML, DrawingML, Shared MLs and Custom XML Schema

79 questions
47
votes
2 answers

Cell styles in OpenXML spreadsheet (SpreadsheetML)

I've generated a .xlsx spreadsheet in C# using the OpenXML SDK, but can't figure out how to get cell styles working. I've been studying files produced by Excel, and can't quite figure out how it's done. Right now, I'm creating a fill, creating a…
Polynomial
  • 27,674
  • 12
  • 80
  • 107
25
votes
4 answers

C# OPEN XML: empty cells are getting skipped while getting data from EXCEL to DATATABLE

Task Import data from excel to DataTable Problem The cell that doesnot contain any data are getting skipped and the very next cell that has data in the row is used as the value of the empty colum. E.g A1 is empty A2 has a value Tom then while…
Vikas Bansal
  • 10,662
  • 14
  • 58
  • 100
16
votes
2 answers

How do I read data from a spreadsheet using the OpenXML Format SDK?

I need to read data from a single worksheet in an Excel 2007 workbook using the Open XML SDK 2.0. I have spent a lot of time searching for basic guidelines to doing this, but I have only found help on creating spreadsheets. How do I iterate rows in…
ProfK
  • 49,207
  • 121
  • 399
  • 775
16
votes
3 answers

Creating Excel document with OpenXml sdk 2.0

I have created an Excel document using OpenXml SDK 2.0, now I have to style It, but I can`t. I don't know how to paint the background color or change the font size in different cells. My code to create a cell is: private static Cell…
JAiro
  • 5,914
  • 2
  • 22
  • 21
13
votes
1 answer

Proper SpreadsheetML file extension

I want to create a a SpreadsheetML file on local drive which can be opened in MS Excel or Open Office by clicking on file in Windows Explorer. I tried all filename extensions registered to Microsoft Excel i could find so far. Some of them (.xls for…
Vasily Redkin
  • 584
  • 1
  • 3
  • 17
12
votes
4 answers

OpenXML SDK Spreadsheet starter kits

I am trying to start working with Excel documents through the OpenXML SDK Spreadsheet API. But I haven't found any good guides or even examples on how to create a xlsx file from scratch. Only how to open an existing document and modify it. I have…
jmw
  • 2,864
  • 5
  • 27
  • 32
12
votes
1 answer

How to work with style Index in Open xml?

Can Anyone please explain How Style Index in OpenXml works? I have a business requirement where I need to apply background color to certain cells in an excel sheet. And Some style is already applied to other cells. So I need to decide which style…
Raxit J Prajapati
  • 123
  • 1
  • 1
  • 5
9
votes
1 answer

Use SSIS to populate Excel workbook generated using OOXML

We are trying to generate MS Excel workbook using OOXML and populate data using SSIS. We are able to generate Workbook and sheets, also able to create columns and insert data in the Header cell. We can also populate data using SSIS. But the Sheet…
Maulik
  • 91
  • 3
8
votes
1 answer

What's the difference between and in Office Open XML?

What's the difference between these two Office Open XML fragments? btyler and btyler note: The second sample I created manually based on the spec, the first is from an actual…
Samuel Neff
  • 73,278
  • 17
  • 138
  • 182
8
votes
2 answers

Theme confusion in SpreadsheetML

I've been fighting this all day. Inside my styles.xml file I have color information given like so: ECMA 376 defines a theme color reference as: Index into the collection, referencing…
dmaruca
  • 485
  • 2
  • 5
  • 16
7
votes
2 answers

XLSX- how to get rid of the default namespace prefix x:?

I'm generating XLSX spreadsheet using OOXML SDK, and I need to get rid of x: namespace prefix. How can I achieve this? using (SpreadsheetDocument doc = SpreadsheetDocument.Open("template.xlsx", true)) { //Save the shared…
user116884
  • 81
  • 1
  • 4
6
votes
2 answers

How do you use the OpenXML API to read a Table from an Excel spreadsheet?

I've read a bunch of stuff on the web about how to get at cell data using the OpenXML API. But there's really not much out there that's particularly straightforward. Most seems to be about writing to SpreadsheetML, not reading... but even that…
Todd McDermid
  • 1,650
  • 11
  • 12
6
votes
2 answers

Converting Excel XML-Spreadsheet into xlsx

i have got a XML-Excel file (SpreadsheetML format):
Saftpresse99
  • 849
  • 7
  • 16
6
votes
1 answer

OpenXML Spreadsheet- Preserve space before or after the value when writing a cell value

I am using OPENXML SDK 2.0 to stream the spread sheet file. The source data is come from data table and writing this to Spreadsheet using openxml. If there is a one of the column data of a data table has " Treshold%" (this text has tab space on…
user2390252
  • 61
  • 1
  • 2
5
votes
1 answer

Two Index's on the same row

I have a rails application that exports content from my database in an xls format. I'm looking to create two separate tables without putting them in the same row. Is there anyway to have two index's on the same row?
DollarChills
  • 1,076
  • 1
  • 15
  • 33
1
2 3 4 5 6