python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - openxml

Overwrite an existing Cell in Excel with OpenXML in C#

I am beginning to use OpenXML to update existing Excel file using .NET Core 5 C#. I have pieced the following code below from examples from the internal and it write to the Excel sheet but I get the f...
test-img

William King

c#

excel

openxml

Votes: 0

Answers: 0

Reading data in a SpreadsheetDocument from MemoryStream

I have a page on my site where a user can upload a XLSX spreadsheet. This is a .NET Core web application using the DocumentFormat.OpenXml (2.15.0) NuGet package. I'm trying to read through each row in...
test-img

Steven

c#

asp.net-core

openxml

openxml-sdk

Votes: 0

Answers: 1

Latest Answer

You need to set memory stream to zero after reading to it. Change code to this: await viewModel.SpreadsheetFile.CopyToAsync(memoryStream).ConfigureAwait(false); memoryStream.Position = 0;
test-img

user16049494

OpenXML in C# .NET Core

Saving the filestream of an uploaded file to "var" var fileStream = new MemoryStream(fileModel.FileData); using (ExcelPackage package = new ExcelPackage(fileStream)) { _ws = package.Work...
test-img

Shrth

c#

excel

.net-core

openxml

Votes: 0

Answers: 1

Latest Answer

You need to set your Memory stream to position 0 before doing anything else with it. var fileStream = new MemoryStream(fileModel.FileData); fileStream.Position = 0;
test-img

user16049494

Excel file (.xlsx) created by using DocumentFormat.OpenXML needs to be repaired when opening in Excel

I have a method which create an excel file (.xlsx) from a list of strings using DocumentFormat.OpenXml. The created file needs to be repaired when I try to open it with Excel 2016. When I click "...
test-img

Simone Urbani

c#

excel

openxml

Votes: 0

Answers: 1

Latest Answer

In my experience when a file needs to be repaired after creating it using OpenXML it means that it is missing a crucial element or the crucial element is in the wrong place. I'm having difficulty foll...
test-img

user16049494

Posts

Questions

Blogs

Jobs