Related questions
Export DataTable to Excel with Open Xml SDK in c#
Sorry for my english please.
I'm new in open xml sdk.
My program have ability to export some data and DataTable to Excel file (template)
In the template I insert the data to some placeholders. It's works very good, but …
open xml excel read cell value
I am using the Open XML SDK to open an Excel xlsx file and I try to read the cellvalue on position A1 in each sheet.
I use the following code:
using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(openFileDialog1.FileName, false))
{
var …
From Excel to DataTable in C# with Open XML
I'm using Visual Studio 2008 and I need create a DataTable from a Excel Sheet using the Open XML SDK 2.0. I need to create it with the DataTable columns with the first row of the sheet and complete it with the …