Hack Forums
[.NET] Replace text in Excel file with VB - Printable Version

+- Hack Forums (https://hackforums.net)
+-- Forum: Tech (https://hackforums.net/forumdisplay.php?fid=444)
+--- Forum: Coding (https://hackforums.net/forumdisplay.php?fid=151)
+---- Forum: Software Development (https://hackforums.net/forumdisplay.php?fid=118)
+---- Thread: [.NET] Replace text in Excel file with VB (/showthread.php?tid=5542908)

Replace text in Excel file with VB - Kαѕρer - Feb 4, 2017

I need to replace text in an Excel file that is in a textbox in VB. How can I do this? I have searched on Google about this, but can't find any simple solution. I hope there are some experienced programmers here that can help me with this. Thanks!

* - Zilog80 - Feb 4, 2017

This can be done using NPOI (https://www.nuget.org/packages/NPOI/) in 0,04 seconds

Edited: i'm out of home now, but I used NPOI a lot. Use this snippet to get a idea:
http://stackoverflow.com/questions/39034401/c-sharp-program-using-npoi-to-edit-cell-values-of-excel-xls-not-working

* - Kαѕρer - Feb 4, 2017

(Feb 4, 2017 01:42 PM)Zilog80 Wrote:  This can be done using NPOI (https://www.nuget.org/packages/NPOI/) in 0,04 seconds
Can you help me doing this? If so, hmu with a PM, please.

* - Zilog80 - Feb 4, 2017

(Feb 4, 2017 01:45 PM)Kαѕρer Wrote:  Can you help me doing this? If so, hmu with a PM, please.

See my edited reply

* - Kαѕρer - Feb 4, 2017

If someone here is able to do this for a small amount of money, hmu.

* - Zilog80 - Feb 4, 2017

(Feb 4, 2017 01:55 PM)Kαѕρer Wrote:  If someone here is able to do this for a small amount of money, hmu.

'Give a man a fish, and you feed him for a day; teach a man to fish, and you feed him for life'

LOL 🤣

* - Kαѕρer - Feb 4, 2017

(Feb 4, 2017 02:01 PM)Zilog80 Wrote:  'Give a man a fish, and you feed him for a day; teach a man to fish, and you feed him for life'

LOL 🤣

True, but if I see how he did it, I will know how it works, lol. I have no clue how to adjust all these small lines into 1 project.

* - Rhez - Feb 4, 2017

[Image: ZBAoHwJ.png]

I didn't have that NPOI that's why there's error.
I hope you can now understand it.
🤝

* - iNCEPTiON_V - Feb 5, 2017

(Feb 4, 2017 10:12 PM)Rhez Wrote:  [Image: ZBAoHwJ.png]

I didn't have that NPOI that's why there's error.
I hope you can now understand it.
🤝

than go and get it so you can include the dll