Being new to this myself, here’s what I did: I’m using MS Visual Studio 2010 Pro. Download and install the OpenXML SDK Within my project in Visual Studio, select “Project” then “Add Reference” Select the “Browse” tab In the “Look in:” pull down, navigate to: C:\Program Files(x86)\Open XML SDK\V2.0\lib and select the “DocumentFormat.OpenXml.dll Hit OK … Read more
Your approach seemed to work ok for me – in that it did “enter the loop”. Nevertheless you could also try something like the following: void Main() { string fileName = @”c:\path\to\my\file.xlsx”; using (FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.Read, FileShare.ReadWrite)) { using (SpreadsheetDocument doc = SpreadsheetDocument.Open(fs, false)) { WorkbookPart workbookPart = doc.WorkbookPart; SharedStringTablePart sstpart … Read more
You can create a page break within a Run element using the <w:br> element. In raw OpenXML, it would look something like: <w:p> <w:r> <w:br w:type=”page” /> </w:r> </w:p> If you’re using the OpenXml SDK, you can use new Paragraph( new Run( new Break(){ Type = BreakValues.Page })); EDIT: If you just want to specify … Read more
Open XML stores dates as the number of days from 1 Jan 1900. Well, skipping the incorrect 29 Feb 1900 as a valid day. You should be able to find out algorithms to help you calculate the correct value. I believe some developers use DateTime.FromOADate() as a helper. Also, the Cell class has the DataType … Read more
I wrote this quick example. It works for me. I only tested it with one dataset with one table inside, but I guess that may be enough for you. Take into consideration that I treated all cells as String (not even SharedStrings). If you want to use SharedStrings you might need to tweak my sample … Read more
I think this should do what you’re asking. The other function is there just to deal with if you have shared strings, which I assume you do in your column headers. Not sure this is perfect, but I hope it helps. static void Main(string[] args) { DataTable dt = new DataTable(); using (SpreadsheetDocument spreadSheetDocument = … Read more
The s attribute references a style xf entry in styles.xml. The style xf in turn references a number format mask. To identify a cell that contains a date, you need to perform the style xf -> numberformat lookup, then identify whether that numberformat mask is a date/time numberformat mask (rather than, for example, a percentage … Read more
This makes sense since Excel will not store a value for a cell that is null. If you open your file using the Open XML SDK 2.0 Productivity Tool and traverse the XML down to the cell level you will see that only the cells that have data are going to be in that file. … Read more
If you use a MemoryStream you can save the changes to a new file like this: byte[] byteArray = File.ReadAllBytes(“c:\\data\\hello.docx”); using (MemoryStream stream = new MemoryStream()) { stream.Write(byteArray, 0, (int)byteArray.Length); using (WordprocessingDocument wordDoc = WordprocessingDocument.Open(stream, true)) { // Do work here } // Save the file with the new name File.WriteAllBytes(“C:\\data\\newFileName.docx”, stream.ToArray()); }
All strings in an Excel worksheet are stored in a array like structure called the SharedStringTable. The goal of this table is to centralize all strings in an index based array and then if that string is used multiple times in the document to just reference the index in this array. That being said, the … Read more