Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Updates & Insights
  • Questions
  • Learning
    • E-learning Courses
    • Empower Replay: Limited Edition
    • Tutorials
    • Open Classroom Training
    • Agility
      • Kanban workshop
      • Agile Fundamentals
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
      • About the DevOps Program
      • DataMiner DevOps Support
  • Downloads
  • More
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
    • Global Feedback Survey
  • Support
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

Reading/writing to an excel file in .NET

Solved2.71K views13th April 2023.net C++ driver excel
4
Benjamin Hodžić [SLC] [DevOps Advocate]1.14K 4th April 2023 0 Comments

Hi Dojo,

I need to develop a connector which reads and writes to an excel file. I can't use Microsoft COM objects because the customer doesn't have Microsoft Office installed. I've tried multiple NuGet packages, but they need licenses to be used commercially.

Does anyone have a suggestion on how to approach this?

Benjamin Hodžić [SLC] [DevOps Advocate] Selected answer as best 13th April 2023

7 Answers

  • Active
  • Voted
  • Newest
  • Oldest
2
Benjamin Hodžić [SLC] [DevOps Advocate]1.14K Posted 13th April 2023 0 Comments

In case someone comes across the same question, I'll leave an update. I ended up using OpenXML for my case. It is well documented by Microsoft itself.

Although it's a bit of a hassle to manipulate data inside the excel, as the package uses internal structure of the excel. For example: cells can have multiple value types (integer, string, date, datetime, etc.), but a particularly interesting one is shared string, where the index of the cell from shared strings table is the actual cell value (e.g. cell A3 has the value 12, where 12 represents 12th entry in the shared strings table).

To modify a cell of type shared string, you need to browse the shared strings table manually to find the value you want to enter, and add it to the end of the table if it doesn't exist.

Besides that, the package is straightforward and easy to use.

Benjamin Hodžić [SLC] [DevOps Advocate] Answered question 13th April 2023
You are viewing 1 out of 7 answers, click here to view all answers.
Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin