0

is it possible to read/write CustomDocumentProperties from an xlsx file without using Excel interop but purely by manipulating the XML or using a library like NPOI.

Basically, I need to in an MVC application to allow a user to download an xlsx file which has some CustomDocumentProperties pre set.

Thank you

Peter
  • 87
  • 9

1 Answers1

0

Try to take a look at this : SpreadsheetLight

Especially this page might be interesting to you: DocumentProperties

Henrik Clausen
  • 679
  • 6
  • 16
  • The source is all there so you can easily see where to modify the ooxml – Henrik Clausen Nov 04 '18 at 22:15
  • Thank you Henrik this is super useful, but as far as I can see it doesn't allow defining a custom DocumentProperty – Peter Nov 05 '18 at 15:29
  • Well. I'd try to create a custom property with some distinct text and then find it in the OOXML. Then it should be a breeze to add a function to SpreadSheetLight that inserts it in the same area. – Henrik Clausen Nov 06 '18 at 09:48