Export to Excel File

Results 1 to 2 of 2

Thread: Export to Excel File

  1. #1
    Join Date
    Dec 1969

    Default Export to Excel File

    How can I write some informtion into Excel file format using ASP?

  2. #2
    Kelvin Guest

    Default RE: Export to Excel File

    Actually how do you get the Data/Infomation.<BR>If you are only write to a single file you can createobject to write into the Excel.<BR>eg. Set xlApplication = CreateObject("Excel.Application")<BR> Set xlWorksheet = xlApplication.Worksheets(1)<BR> xlWorksheet.Application.Rows(1).Font.Bold=True<BR> xlWorksheet.Application.Cells(1,1).Value = "Value" <BR> fileName = "excel empFile.xls" <BR> xlWorksheet.SaveAs Server.MapPath(".") & fileName <BR>This is only a sample I receive from my friend.<BR>Hope that it will help you<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts