Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using the word Excel on the web
Message
 
To
15/04/2002 11:02:15
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00645021
Message ID:
00645036
Views:
10
>We are creating a Visual Foxpro based website where we are allowing the user to download their search results in various formats. One of those formats is (.xls). Does anyone know what is involved with using the name Excel? Or where I should look for that type of question?

I assume that you want to generate the Excel file on the backend. You can do this via OLE-Automation with code like this:
oExcel = createobject("excel.application")
oExcel.Application.Visible = .T.
oWorkbook = oExcel.Workbooks.Add()
oSheet = oWorkbook.Sheets.Add()
osheet.Cells(1,1).Value='123'
oWorkbook.Save()
Then, you will probably need to e-mail them the XLS file or allow them to download it via FTP.
Hector Correa
Previous
Reply
Map
View

Click here to load this message in the networking platform