dfinke / ImportExcel

PowerShell module to import/export Excel spreadsheets, without Excel
https://www.powershellgallery.com/packages/ImportExcel/
Apache License 2.0
2.47k stars 400 forks source link

EPPlus Replacement #979

Closed Tiberriver256 closed 3 years ago

Tiberriver256 commented 3 years ago

Hey thanks for this awesome module. This is more just a curiosity question. Now that EPPlus is commercially licensed (since v5) are you planning on a replacement? or would you just stay on v4 as long as possible?

dfinke commented 3 years ago

Thanks!

Good question. Lots of considerations for moving to the EPPlus v5. Their new license requires users to have a paid license if the library is used in a commercial setting. Plus, lots of breaking changes moving to the new version, and more PowerShell/Unit tests would need to be written to take advantage of the features they are adding.

I'm considering it though.

Tiberriver256 commented 3 years ago

Thanks for the reply! I'll be curious to see which way you head :)

dfinke commented 3 years ago

Do you have a preference? Is there a feature(s) in v5 you are looking for?

RenatoGregio commented 3 years ago

@dfinke thanks a lot for this amazing module. With then we can build our inventory tool. do you know a way to create treemap without EPPlus v5?

dfinke commented 3 years ago

@RenatoGregio No, don't know, not sure it can be. If possible, it'd be great to see how your building that tool.

RenatoGregio commented 3 years ago

@RenatoGregio No, don't know, not sure it can be. If possible, it'd be great to see how your building that tool.

Our tool is Azure Resource Inventory. Now we are working on V2 :)

https://github.com/azureinventory/ARI

dfinke commented 3 years ago

Thanks! Great to see this used in the Azure space. I'll keep my ear to the ground about a treemap, but I don't think that'll happen.

dfinke commented 3 years ago

I did start porting the module to EPPlus v5, lots of breaking changes. I stopped for several reasons. The primary reason being v5 requires a paid license for use in commercial settings.

Here is a treemap 🙂. I don't believe I will make this public though.

image