TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
blusk06
NA
10
0
DataGrid accessing and Excel 11.0 Object Library
Jun 16 2004 5:55 PM
Does anyone know how to export DataGrid, DataView, or DataSet data into an excel spreadsheet using the Microsoft Excel 11.0 Object Library? I saw the guide on how to do it with the 9.0 on the site, but 11.0 is different. If you cant tell me how to do it with 11.0, do you know if it is illegal to use the file EXCEL9.OLB if I didnt purchase excel 2000? (the project is for work) If nobody can tell me how to export data using 11.0, can you at least tell me how to do this with a DataGrid, DataSet, or DataView: 1. Get total number of columns and rows 2. Get cell color and cell text color in a DataGrid 3. Access individual columns in a DataGrid by an index. I.E. if it was in a for loop: dataGrid.Column[i] (obviously incorrect syntax)
Reply
Answers (
2
)
error in Access 2000
Open Excel worksheet inside form