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!
|
.NET
Replace text in Excel file with VB |
|
Feb 4, 2017 01:42 PM
(This post was last modified: Feb 4, 2017 01:46 PM by Zilog80.)
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/39034...ot-working (Feb 4, 2017 01:42 PM)Zilog80 Wrote: This can be done using NPOI (https://www.nuget.org/packages/NPOI/) in 0,04 secondsCan you help me doing this? If so, hmu with a PM, please. (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 (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 🤣
Feb 4, 2017 02:03 PM
(This post was last modified: Feb 4, 2017 02:03 PM by Kαѕρer.)
(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' 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. (Feb 4, 2017 10:12 PM)Rhez Wrote: than go and get it so you can include the dll |
|
|




![[Image: ZBAoHwJ.png]](https://i.imgur.com/ZBAoHwJ.png)