Sometimes developers need to create huge spreadsheets, perhaps with 100’s of thousands of rows, and many columns. A worksheet that contains 1,000,000 rows and 10 columns will contain upwards of 20,000,000 nodes in the worksheet part. This presents a problem when using a DOM approach. Both XmlDocument and LINQ to XML allocate too much memory. … Continue reading Screen-Cast: Using Open XML and LINQ to XML in a Streaming Fashion to Create Huge Spreadsheets