Allow to read and update an xlsx file

dotnet / roslyn

The Roslyn .NET compiler provides C# and Visual Basic languages with rich code analysis APIs.

https://docs.microsoft.com/dotnet/csharp/roslyn-sdk/

MIT License

18.96k stars 4.03k forks source link

Allow to read and update an xlsx file #47439

Open vsfeedback opened 4 years ago

vsfeedback commented 4 years ago

This issue has been moved from a ticket on Developer Community.

I want to read and update an xlsx file in Community with Visual Basic.

Original Comments

Feedback Bot on 5/11/2020, 10:44 PM:

Thank you for taking the time to provide your suggestion. We will do some preliminary checks to make sure we can proceed further. We'll provide an update once the issue has been triaged by the product team.

PathogenDavid commented 4 years ago

You can already do this with VB.NET through Excel automation: https://docs.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/automate-excel-from-visual-basic-net

There's also various libraries out there that can do it without Excel automation. I think I used EPPlus back in the day.

Regardless though, this isn't on-topic for this repo.