开发者

Update Excel by OpenXml

开发者 https://www.devze.com 2023-03-23 05:24 出处：网络

everybody! I have an Excel file and onclick event my file values must be changed and sent to client. I did action to file by using Microsoft.Office.Interop.Excel, but I can\'t send to client without s

相关专题：asp.net excel openxml

everybody! I have an Excel file and onclick event my file values must be changed and sent to client. I did action to file by using Microsoft.Office.Interop.Excel, but I can't send to client without saving it on disk. Here I开发者_C百科 found that OpenXML could be usefull for my task. Does anyone know how to change value of cell in Excel by OpenXML and how to send file to client in asp.net?

Open XML is the file format Excel, Word, and PowerPoint use to represent the data in the documents. If you want to access this XML I recommend using the Open XML SDK 2.0 as it will contain all the functions you need to change and set an Excel value.

Take a look at this stackoverflow post for some beginning guidance.