• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 507
  • Last Modified:

working with excel in vb application

I am writing application in asp,storing data in database and according to the data i need to make a report in excel. Now i am not getting how to make an excel worksheet thruogh asp and how to add,edit and delete he records though asp.i am new with this kind of application.
Can any one help me in this. I want ot know what dll do i need to load for excel, how to create file in that how to insert data in that

1 Solution
pfoe, this is a rather difficult job for a biginner...
anyway, you have to know:
- how to create an excel instance, and how to use it
- how to read from/write to a database

this is not very difficult, and i think lots of code is available.
but i can give some tips.
- create an excel object like:
xl = createobject("excel.application")
- create an excel workbook:
set wb = xl.workbooks.add
- add data to a sheet:
set ws = wb.worksheets(1)
ws.cells(1,1).value = "some text"
ws.saveas "filename.xls"

i don't know if this code works as is, but i hope you get the idea.


This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Experts: Post your closing recommendations!  Who deserves points here?
cool_vjy, an EE Moderator will handle this for you.
Moderator, my recommended disposition is:

    DELETE -- No Refund.

DanRollins -- EE database cleanup volunteer

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now