Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
programming excel 97 from .net 2003
can anyone point me in the direction of material that would relate to,
i'm trying to take some data from a dataview in vb.net 2003 and create an excel file. i've read thru the kbs at http://support.microsoft.com/kb/301982/EN-US/ and http://support.microsoft.com/default...;EN-US;Q306022 and while they seem to work with my office 2003 installs, my dev machines office 97 install throws several exceptions. thanks g |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
programming excel 97 from .net 2003
Doesn't your first article say:
Note Microsoft Office 2003 includes Primary Interop Assemblies (PIAs). Microsoft Office XP does not include PIAs, but they can be downloaded. For additional information about Office XP PIAs, click the following article number to view the article in the Microsoft Knowledge Base: It doesn't say anything about PIA's being available for xl2000 or xl97 or any earlier version. -- Regards, Tom Ogilvy "gabe" wrote in message ... can anyone point me in the direction of material that would relate to, i'm trying to take some data from a dataview in vb.net 2003 and create an excel file. i've read thru the kbs at http://support.microsoft.com/kb/301982/EN-US/ and http://support.microsoft.com/default...;EN-US;Q306022 and while they seem to work with my office 2003 installs, my dev machines office 97 install throws several exceptions. thanks g |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
programming excel 97 from .net 2003
are you indirectly saying this cant be done?
yes the article says that, then my Question is about material that Would relate. i understand that the code in the article doesnt work, i'm looking for material that does. "Tom Ogilvy" wrote: Doesn't your first article say: Note Microsoft Office 2003 includes Primary Interop Assemblies (PIAs). Microsoft Office XP does not include PIAs, but they can be downloaded. For additional information about Office XP PIAs, click the following article number to view the article in the Microsoft Knowledge Base: It doesn't say anything about PIA's being available for xl2000 or xl97 or any earlier version. -- Regards, Tom Ogilvy "gabe" wrote in message ... can anyone point me in the direction of material that would relate to, i'm trying to take some data from a dataview in vb.net 2003 and create an excel file. i've read thru the kbs at http://support.microsoft.com/kb/301982/EN-US/ and http://support.microsoft.com/default...;EN-US;Q306022 and while they seem to work with my office 2003 installs, my dev machines office 97 install throws several exceptions. thanks g |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
programming excel 97 from .net 2003
"gabe" wrote in message ... are you indirectly saying this cant be done? yes the article says that, then my Question is about material that Would relate. i understand that the code in the article doesnt work, i'm looking for material that does. I think it is possible to create PIA's for Excl97. at the very least. I know that David Thielen did so for an older version of MS Word. I think you should try your luck at the microsoft.public.office.developer.com.add-ins newsgroup. /Fredrik |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
programming excel 97 from .net 2003
fredrik, thank you i will try a crosspost to that site,
are there other methods of writing an excel file (with excel 97 istalled) based on a grid of data from with .net aside from PIAs? "Fredrik Wahlgren" wrote: "gabe" wrote in message ... are you indirectly saying this cant be done? yes the article says that, then my Question is about material that Would relate. i understand that the code in the article doesnt work, i'm looking for material that does. I think it is possible to create PIA's for Excl97. at the very least. I know that David Thielen did so for an older version of MS Word. I think you should try your luck at the microsoft.public.office.developer.com.add-ins newsgroup. /Fredrik |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
programming excel 97 from .net 2003
If you just want to write out a "grid of data", write a .csv file (just a
text file with elements separated by commas). Alternately, you can probably do it with ADO.Net (at least you can with its predecessor, ADO, I believe). -- Regards, Tom Ogilvy "gabe" wrote in message ... fredrik, thank you i will try a crosspost to that site, are there other methods of writing an excel file (with excel 97 istalled) based on a grid of data from with .net aside from PIAs? "Fredrik Wahlgren" wrote: "gabe" wrote in message ... are you indirectly saying this cant be done? yes the article says that, then my Question is about material that Would relate. i understand that the code in the article doesnt work, i'm looking for material that does. I think it is possible to create PIA's for Excl97. at the very least. I know that David Thielen did so for an older version of MS Word. I think you should try your luck at the microsoft.public.office.developer.com.add-ins newsgroup. /Fredrik |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
programming excel 97 from .net 2003
na, csv is no good, the data may contain comma or tabs, really looking for a
grid of data written to an excel file - otherwise i would have writen one and named it something.xls. "Tom Ogilvy" wrote: If you just want to write out a "grid of data", write a .csv file (just a text file with elements separated by commas). Alternately, you can probably do it with ADO.Net (at least you can with its predecessor, ADO, I believe). -- Regards, Tom Ogilvy "gabe" wrote in message ... fredrik, thank you i will try a crosspost to that site, are there other methods of writing an excel file (with excel 97 istalled) based on a grid of data from with .net aside from PIAs? "Fredrik Wahlgren" wrote: "gabe" wrote in message ... are you indirectly saying this cant be done? yes the article says that, then my Question is about material that Would relate. i understand that the code in the article doesnt work, i'm looking for material that does. I think it is possible to create PIA's for Excl97. at the very least. I know that David Thielen did so for an older version of MS Word. I think you should try your luck at the microsoft.public.office.developer.com.add-ins newsgroup. /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Programming | Excel Discussion (Misc queries) | |||
Excel 2003 Programming - Outlook.Application and Char(10) | Excel Programming | |||
excel 2003 Task Pane programming | Excel Programming | |||
Programming in Excel 2003! | Excel Programming | |||
Programming Xml Source Pane of Excel 2003 | Excel Programming |