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
Recommended Answers
Jump to Postyou need to write a program to read excel file using .net and use the same application to write back into another excel.
Jump to Postyou mean you want the complete code? or just an idea?
All 6 Replies
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,780
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.