Hello Community,
I was wondering if there is a way to make a program that will copy text from an excel spreatsheet and place it in another using visualbasic.net not vba?
Please Help
joshl_1995 22 Twisted Digital
Pgmer 50 Master Poster Featured Poster
you need to write a program to read excel file using .net and use the same application to write back into another excel.
joshl_1995 22 Twisted Digital
I know that. I'm asking how?
Pgmer 50 Master Poster Featured Poster
you mean you want the complete code? or just an idea?
joshl_1995 22 Twisted Digital
Maby a bit of the code just to start me off
G_Waddell 131 Posting Whiz in Training
Hi,
Do you mean manipulate Excel without it being installed on the machine or do you just want a way to do it in .net as opposed to vba?
If you don't mind excel being installed on the machine, then you can use Interop. Here is a sample: DevX.com
As for the other, I'm not 100% sure, I did do a project where I was trying to manipulate newer versions of excel as they are basically compressed XML files but I didn't get very far before we had to pull the plug.
Reverend Jim 4,968 Hi, I'm Jim, one of DaniWeb's moderators. Moderator Featured Poster
I posted code in Retrieve and save to another excel workbook a while back which should get you started.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.