ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Office Web Component-Data Transfer (https://www.excelbanter.com/excel-programming/293741-office-web-component-data-transfer.html)

Umut

Office Web Component-Data Transfer
 
Hi dear all
We use the "Set xl = Server.CreateObject("OWC.Spreadsheet")" object an
write 15200 characters(below 15200 characters there seems to be no problem
the
Response.Buffer = TRU

Response.ContentType = "application/vnd.ms-excel

Response.Write xl.HTMLDat

and try to open an excel document we get an error:"type mismatch

(also bu using Set xl =CreateObject("Excel.Application","CORDOBA") an
create 15000 or more rows, process hangs..
Can you help me on this problem please, thanks already...(is there a limitation
--
Umut ŞAHİ




All times are GMT +1. The time now is 04:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com