Hi,
I hope this is correct forum for this, this might possibly an academic type
question.
I am trying to copy a dataset to an excel spreadsheet for my asp.net
application.
(written VB).
I have tried lots of sample code examples but everyone gets stuck at the
point where I try to manipulate a cell.
snippet follows:
Dim oSheet As Excel.Worksheet (note: not all declarations provided)
oSheet.Cells(1, 1).Interior.Col or = m_Report.m_head ing_color
oSheet.Cells(1, 1).Value = "PP"
oSheet.Cells(2, 1).CopyFromReco rdset(drdata)
all of these statements cause a "no such interface supported" error.
I don't have intellisense appearing after the cells.
Does anyone know what the problem might be ?
thanks
Chris 2 3575
You need to add a reference to Excel.
Right click References in the Solution tree.
Then find Microsoft Excel under the COM tab.
Chris wrote: Hi,
I hope this is correct forum for this, this might possibly an academic type question.
I am trying to copy a dataset to an excel spreadsheet for my asp.net application. (written VB).
I have tried lots of sample code examples but everyone gets stuck at the point where I try to manipulate a cell. snippet follows:
Dim oSheet As Excel.Worksheet (note: not all declarations provided)
oSheet.Cells(1, 1).Interior.Col or = m_Report.m_head ing_color oSheet.Cells(1, 1).Value = "PP" oSheet.Cells(2, 1).CopyFromReco rdset(drdata)
all of these statements cause a "no such interface supported" error. I don't have intellisense appearing after the cells.
Does anyone know what the problem might be ?
thanks
Chris
--
Texeme http://texeme.com
Hi Indie Pop,
I have already reference the excel object and provided import statements.
VS2003 automatically turned it into an interop.excel.d ll.
I found out the problem my syntax was incorrect.
Now I have another problem: the message when I run that line of code is:
"Exception from HRESULT: 0x800A03EC."
source = "Interop.Ex cel"
any ideas?
thanks
Chris
"Indie Pop" wrote: You need to add a reference to Excel.
Right click References in the Solution tree.
Then find Microsoft Excel under the COM tab.
Chris wrote:
Hi,
I hope this is correct forum for this, this might possibly an academic type question.
I am trying to copy a dataset to an excel spreadsheet for my asp.net application. (written VB).
I have tried lots of sample code examples but everyone gets stuck at the point where I try to manipulate a cell. snippet follows:
Dim oSheet As Excel.Worksheet (note: not all declarations provided)
oSheet.Cells(1, 1).Interior.Col or = m_Report.m_head ing_color oSheet.Cells(1, 1).Value = "PP" oSheet.Cells(2, 1).CopyFromReco rdset(drdata)
all of these statements cause a "no such interface supported" error. I don't have intellisense appearing after the cells.
Does anyone know what the problem might be ?
thanks
Chris
-- Texeme http://texeme.com
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mudcat |
last post by:
Howdy,
I could have sworn I downloaded a version of python win that supported
object library 11.0 at some point. However I just downloaded versions
204 and 203, and the highest version they have is OL 9.0.
Does anyone know if this is a mistake or if Excel 2003 isn't yet
supported with the extensions?
Thanks,
|
by: Peter |
last post by:
I am trying to understand Interfaces. I've looked at various Dog, Animal and Shape and Circle examples and I am still murky about interfaces.
I am working on a project where I am using Excel to create graphs, but in a future I might be using third party graphing library like Dundas instead or in conjunction with Excel. Since I can't do...
|
by: al |
last post by:
Greetings,
I'm wondering if Excel object CopyFromRecordset is still supported in
VB.NET?? If not, what is the alternative, looping through dataset????
MTIA,
Grawsha
|
by: Chris |
last post by:
Hi,
I hope this is correct forum for this, this might possibly an academic type
question.
I am trying to copy a dataset to an excel spreadsheet for my asp.net
application.
(written VB).
I have tried lots of sample code examples but everyone gets stuck at the
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |