Using OWC11

We are trying to download a table from a Web site (ASP) to Excel. One of the fields contains phone numbers with ziro ("0") as the first character. While downloading the table to Excel, the program disregard the ziro, and format the number as "Number" without the first ziro. We tryed to use:

spredsheet.Cells(iRow,iColumn).NumberFormat="@"

like in VBA, but it didn't work. How to define this column as text?

View Replies


ADVERTISEMENT

Streaming OWC11.Spreadsheet

I have created a Spreadsheet object that I need to stream directly to a file through the browser. I can not save this file, that I would then stream, to the web server, even though this would save me a lot of aggravation.

Since Microsoft seems to see no value in providing any documentation for their OWC 11 components, I am just one of many developers groping around trying to find how to use this.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved