✅ how to create and insert images that represent program data into excel file
I am building a desktop app that has a feature to create an excel report. i used open-source libraries to create the report and it was easy-peasy until this task came up. i would really appreciate any advices or tips on creating/inserting this kind of image that represents the data in my program...
10 Replies
I successfully used this package:
https://www.epplussoftware.com/
They got you covered on almost all excel topics, except some rare pivot stuff
EPPlus Software
Excel spreadsheet library for .NET Framework/Core - EPPlus Software
EPPlus is a highly popular spreadsheet/xlsx library for .NET Framework/.NET Core.It creates, reads, updates and calculates workbooks compatible with popular spreadsheet applications such as Excel.
GitHub
GitHub - ClosedXML/ClosedXML: ClosedXML is a .NET library for readi...
ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXM...
you can check their wiki with examples
I will look through it, thank you 🙂
Thank you. I am glad that there is a free library that i can use, but i don't see the right solution for me in the documentation... They provide a method to insert an existing image file, but what i find it challenging is to create images where the length and number of bars correspond to the data in my program. 😢
The question is if you really need an actual image, I mean, it's excel, won't a chart do the job?
GitHub
Merging Cells
ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXM...
beyond that u would have to fit scale the image or have some calculation to know how many cells u need to take to display it naturally
but I agree with SpReeD, if its a graph, just let excel handle and build a graph instead.
u also have things like
there is another program that takes my excel report as input. i thought about merging and deviding the cells to make it look like the image i attached, but i was worried that the other program might read it as a value if i do it and mark numbers(1, 2, 3, ... like the image shown) in the cells. that's why i tried to create images, but i will try using bar charts. thank you guys.
Use the /close command to mark a forum thread as answered