Using VS 2003, I need to access Excel workbooks and sheets. anyone have some code snippets to do this? All help/advice gratefully appreciated
Jim
jspear 0 Newbie Poster
Ole Raptor 19 Posting Whiz in Training
Is there anything special you need to do with these once you have located the files?
debasisdas 580 Posting Genius Featured Poster
What exactly youa re trying to do.
jspear 0 Newbie Poster
Thanks for your reply. I need to let anyone view the worksheets with no way to change them and another group to be able to modify them. I don't know whether , or how, to do this with code or on the spreadsheet itself. Again, I really appreciate you taking the time to help me.
Regards, Jim
GL.Za 0 Light Poster
Just to clarify, do you want to open excel through your application or just display the data on a form?
jspear 0 Newbie Poster
Thanks for your response. I think That just opening Excel through the application will handle what I need to do. Again thanks for your help.
Jim
GL.Za 0 Light Poster
Sorry about the delay, but here is a link to a page with some good code.
http://xldennis.wordpress.com/2007/11/16/open-excel-workbooks-in-vbnet-solutions/
It gives three different options, so one of them should work for you. I used none of them cos i just used a datagridview & dataset - but its simialr to the spreadsheet component option given.
Hope this helps.
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.