OpenSpreadsheet
OpenSpreadsheet copied to clipboard
folkcoder
OpenSpreadsheet provides an easy-to-use wrapper around the OpenXML spreadsheet SAX API. It specializes in efficiently reading and writing between strongly typed collections and worksheets.
From reddit: ```csharp using (var spreadsheet = new Spreadsheet(filepath)) { var records = spreadsheet.ReadWorksheet("Sheet1"); using (var writerNegative = spreadsheet.CreateWorksheetWriter("Negative")) using (var writerPositive = spreadsheet.CreateWorksheetWriter("Positive")) { foreach (var record in records)...
I currently have Aspose.Cells code that looks something nasty, like this DataTable code: ```c# private void CreateSpreadSheet(DataTable dtValue, string reportPath) { using (var ew = Office.OfficeServiceFactory.GetExcelWriter()) { const string sheetName...
We have some spreadsheets where users would rather enter data as rows instead of columns, and our plan is to just use Excel Paste as Transpose manually for now, but...
Not clear how it interacts with HeaderIndexRow property. Problems arise when you have multi-row headers, such as when the first header row is used to span three columns of text...
Example questions: 1. Why would I use OpenSpreadsheet over Microsoft's Open XML API? 2. Why would I use OpenSpreadsheet over ClosedXML? A: When the author tried using ClosedXML for his...
This would help foster competition across different libraries
I am using OpenSpreadSheet 1.2.3 I have updated DocumentFormat.OpenXml from 2.20.0 to 3.1.0 I am now getting the following error when trying to create a spreadsheet ``` System.NullReferenceException: Object reference...
