Hi all...
While looking around for tools to create Excel files from either HTML pages
or the Data I use to assemble them, I got an interesting response from a
vendor. I have looked at Apose, and may end up using their product. I am
also looking at the capability of SQL Server 2005 reporting services to
produce multi-worksheet workbooks.
However, a vendor that does HTML to PDF conversion asked me why I have not
used Office Open XML File Formats. He sent me a link http://msdn2.microsoft.com/en-us/library/aa338205.aspx
which gave me 17 pages of overview but no real examples of this technology
applied to ASP.NET.
The "more information" link at the bottom of th page sent me back to the
Microsoft Office Developer Center which looked more like a sales page and I
got lost there. Frustrating.
So, can anyone point me to some code examples of this technology in action
to produce Excel from my website? I seem to learn best by code examples.
With the brain overload I am currently experiencing working with 5
technologies relatively new to me (I have been a mere VB6- SQL 2000
programmer for 6 years) the quick fix tools look mighty good...however. ..
I appreciate any help in directing me to a "useful" resource for the Open
XML File formats.
TIA 9 1404
Hi John,
Have a look at these 2 articles from MSDN magazine about creating .docx
files with dotNET (think the examples are in VB as well!)... http://msdn.microsoft.com/msdnmag/is...asicInstincts/
and http://msdn.microsoft.com/msdnmag/is...2/OfficeSpace/
HTH,
Dan
"John Kotuby" wrote:
Hi all...
While looking around for tools to create Excel files from either HTML pages
or the Data I use to assemble them, I got an interesting response from a
vendor. I have looked at Apose, and may end up using their product. I am
also looking at the capability of SQL Server 2005 reporting services to
produce multi-worksheet workbooks.
However, a vendor that does HTML to PDF conversion asked me why I have not
used Office Open XML File Formats. He sent me a link http://msdn2.microsoft.com/en-us/library/aa338205.aspx
which gave me 17 pages of overview but no real examples of this technology
applied to ASP.NET.
The "more information" link at the bottom of th page sent me back to the
Microsoft Office Developer Center which looked more like a sales page and I
got lost there. Frustrating.
So, can anyone point me to some code examples of this technology in action
to produce Excel from my website? I seem to learn best by code examples.
With the brain overload I am currently experiencing working with 5
technologies relatively new to me (I have been a mere VB6- SQL 2000
programmer for 6 years) the quick fix tools look mighty good...however. ..
I appreciate any help in directing me to a "useful" resource for the Open
XML File formats.
TIA
Hi John,
Have a look at these 2 articles from MSDN magazine about creating .docx
files with dotNET (think the examples are in VB as well!)... http://msdn.microsoft.com/msdnmag/is...asicInstincts/
and http://msdn.microsoft.com/msdnmag/is...2/OfficeSpace/
HTH,
Dan
"John Kotuby" wrote:
Hi all...
While looking around for tools to create Excel files from either HTML pages
or the Data I use to assemble them, I got an interesting response from a
vendor. I have looked at Apose, and may end up using their product. I am
also looking at the capability of SQL Server 2005 reporting services to
produce multi-worksheet workbooks.
However, a vendor that does HTML to PDF conversion asked me why I have not
used Office Open XML File Formats. He sent me a link http://msdn2.microsoft.com/en-us/library/aa338205.aspx
which gave me 17 pages of overview but no real examples of this technology
applied to ASP.NET.
The "more information" link at the bottom of th page sent me back to the
Microsoft Office Developer Center which looked more like a sales page and I
got lost there. Frustrating.
So, can anyone point me to some code examples of this technology in action
to produce Excel from my website? I seem to learn best by code examples.
With the brain overload I am currently experiencing working with 5
technologies relatively new to me (I have been a mere VB6- SQL 2000
programmer for 6 years) the quick fix tools look mighty good...however. ..
I appreciate any help in directing me to a "useful" resource for the Open
XML File formats.
TIA
I've done some of this.
Basically, because you write out xml to a standard/schema, you can produce
excel sheets without interop or com or the excel object library.
Sweet!
You can build your own, or buy from a vendor.
My needs were simple. I always had a DataView ( columns and row) and I
threw them into excel.
I think when I was doing it (2005), you could not do any imbedded objects or
graphs. Not sure (but I'd guess so) if that's still the case.
...
But basically, people wanted a "report" they could throw/email around,
instead of directing them to a URL and saying
"Put these parameters in, and click GO and you'll see the data".
Its good for a historical report also. (As in, I need to know what the data
was on May 1st, 2007....and keep a history of that).
............
Mark Rae will chime in (maybe) and tell you (because MS tells you) the the
object library on a webserver is a bad idea.
"John Kotuby" <Jo********@dis cussions.micros oft.comwrote in message
news:uJ******** ******@TK2MSFTN GP05.phx.gbl...
Hi all...
While looking around for tools to create Excel files from either HTML
pages
or the Data I use to assemble them, I got an interesting response from a
vendor. I have looked at Apose, and may end up using their product. I am
also looking at the capability of SQL Server 2005 reporting services to
produce multi-worksheet workbooks.
However, a vendor that does HTML to PDF conversion asked me why I have not
used Office Open XML File Formats. He sent me a link http://msdn2.microsoft.com/en-us/library/aa338205.aspx
which gave me 17 pages of overview but no real examples of this technology
applied to ASP.NET.
The "more information" link at the bottom of th page sent me back to the
Microsoft Office Developer Center which looked more like a sales page and
I
got lost there. Frustrating.
So, can anyone point me to some code examples of this technology in action
to produce Excel from my website? I seem to learn best by code examples.
With the brain overload I am currently experiencing working with 5
technologies relatively new to me (I have been a mere VB6- SQL 2000
programmer for 6 years) the quick fix tools look mighty good...however. ..
I appreciate any help in directing me to a "useful" resource for the Open
XML File formats.
TIA
"John Kotuby" <Jo********@dis cussions.micros oft.comwrote in message
news:uJ******** ******@TK2MSFTN GP05.phx.gbl...
So, can anyone point me to some code examples of this technology in action
to produce Excel from my website? I seem to learn best by code examples.
This is probably the best place to start: http://msdn2.microsoft.com/en-us/office/aa905545.aspx
Office OpenXML is most definitely not for the faint-hearted, especially when
compared to Aspose...
It is, however, free... :-)
-- http://www.markrae.net
Thanks Dan (musodev),
I appreciate the leads. Was too busy digging ditches today (programming) to
get back to you earlier.
"musosdev" <mu*******@comm unity.nospamwro te in message
news:44******** *************** ***********@mic rosoft.com...
Hi John,
Have a look at these 2 articles from MSDN magazine about creating .docx
files with dotNET (think the examples are in VB as well!)...
http://msdn.microsoft.com/msdnmag/is...asicInstincts/
and
http://msdn.microsoft.com/msdnmag/is...2/OfficeSpace/
HTH,
Dan
"John Kotuby" wrote:
>Hi all...
While looking around for tools to create Excel files from either HTML pages or the Data I use to assemble them, I got an interesting response from a vendor. I have looked at Apose, and may end up using their product. I am also looking at the capability of SQL Server 2005 reporting services to produce multi-worksheet workbooks.
However, a vendor that does HTML to PDF conversion asked me why I have not used Office Open XML File Formats. He sent me a link http://msdn2.microsoft.com/en-us/library/aa338205.aspx which gave me 17 pages of overview but no real examples of this technology applied to ASP.NET.
The "more information" link at the bottom of th page sent me back to the Microsoft Office Developer Center which looked more like a sales page and I got lost there. Frustrating.
So, can anyone point me to some code examples of this technology in action to produce Excel from my website? I seem to learn best by code examples.
With the brain overload I am currently experiencing working with 5 technologies relatively new to me (I have been a mere VB6- SQL 2000 programmer for 6 years) the quick fix tools look mighty good...however. ..
I appreciate any help in directing me to a "useful" resource for the Open XML File formats.
TIA
Thanks Mark and Sloan...
I always appreciate the help from seasoned vets...
Mark when a guy like you keeps saying "Office OpenXML is most definitely not
for the faint-hearted", I think in this case maybe I will be better spending
the money. After all time is money (valuable) and I haven't spent enough of
it fishing or playing with the wife .. if she hasn't left me yet ;-)
"Mark Rae" <ma**@markNOSPA Mrae.netwrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..
"John Kotuby" <Jo********@dis cussions.micros oft.comwrote in message
news:uJ******** ******@TK2MSFTN GP05.phx.gbl...
>So, can anyone point me to some code examples of this technology in action to produce Excel from my website? I seem to learn best by code examples.
This is probably the best place to start: http://msdn2.microsoft.com/en-us/office/aa905545.aspx
Office OpenXML is most definitely not for the faint-hearted, especially
when compared to Aspose...
It is, however, free... :-)
-- http://www.markrae.net
//playing with the wife .. if she hasn't left me yet ;-)//
Yep.
And its not trivial stuff. Like I said, I did one, I don't think any of
that third party stuff was around back then.
I didn't even have a schema. I saved an basic excel file "as xml", and just
recreated my code to match.
If you have the funds, then pick another route than rolling your own.
"John Kotuby" <Jo********@dis cussions.micros oft.comwrote in message
news:uW******** ******@TK2MSFTN GP03.phx.gbl...
Thanks Mark and Sloan...
I always appreciate the help from seasoned vets...
Mark when a guy like you keeps saying "Office OpenXML is most definitely
not
for the faint-hearted", I think in this case maybe I will be better
spending
the money. After all time is money (valuable) and I haven't spent enough
of
it fishing or playing with the wife .. if she hasn't left me yet ;-)
"Mark Rae" <ma**@markNOSPA Mrae.netwrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..
"John Kotuby" <Jo********@dis cussions.micros oft.comwrote in message
news:uJ******** ******@TK2MSFTN GP05.phx.gbl...
So, can anyone point me to some code examples of this technology in
action to produce Excel from my website? I seem to learn best by code
examples.
This is probably the best place to start: http://msdn2.microsoft.com/en-us/office/aa905545.aspx
Office OpenXML is most definitely not for the faint-hearted, especially
when compared to Aspose...
It is, however, free... :-)
-- http://www.markrae.net
"John Kotuby" <Jo********@dis cussions.micros oft.comwrote in message
news:uW******** ******@TK2MSFTN GP03.phx.gbl...
I always appreciate the help from seasoned vets...
Mark when a guy like you keeps saying "Office OpenXML is most definitely
not for the faint-hearted", I think in this case maybe I will be better
spending the money. After all time is money (valuable) and I haven't spent
enough of it fishing or playing with the wife .. if she hasn't left me yet
;-)
Yes indeed...
Aspose is (relatively) expensive, but so is my time... :-)
With Aspose, you really do just drop it into your \bin folder and start
coding...
What would take about an hour with Aspose, might easily take up to a week
with Office OpenXML unless I'd done virtually the same thing before and
could re-use most of the code...
Don't get me wrong - Office OpenXML is *extremely* powerful, and you *will*
be able to do everything you need with it...
Eventually... ;-)
-- http://www.markrae.net
"sloan" <sl***@ipass.ne twrote in message
news:uF******** ******@TK2MSFTN GP03.phx.gbl...
And its not trivial stuff. Like I said, I did one, I don't think any of
that third party stuff was around back then.
I didn't even have a schema. I saved an basic excel file "as xml", and
just
recreated my code to match.
Quite. I recall doing a similar thing with RTF a few years ago - mocked up a
document in WordPad, saved it as RTF, and then spent a few days figuring out
what it all meant...:-)
If you have the funds, then pick another route than rolling your own.
I couldn't agree more!
I'm a big fan of 3rd-party .NET assemblies - full respect to the developers
whose skill I'm paying for, and who are saving me so much time...
Current favourites are: http://www.chilkatsoft.com/downloads.asp http://www.siberix.com/
It's been quite a while since I did a commercial project which didn't use at
least one of those...
Not forgetting Aspose, of course, though not every piece of work I do
requires Office integration...
-- http://www.markrae.net This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: tubby |
last post by:
How are Python users dealing with some of the new OASIS Open Document
formats (Open Office) or MS Open XML formats. These formats store data
in a file which is actual a zip archive that contains numerous files and
folders. For example, a file saved from Open Office 2.0 named 'test.odt'
can be unzipped into many parts... content.xml, meta.xml, settings.xml,
etc, etc.
How can I read these files do re searching and matching on them, etc?...
|
by: salad |
last post by:
XML seems to be a hot technology buzzword. And it appears XML is
supported in A2003.
I am wondering if it could be used in the following scenario. I create
an order record for the customer. This customer is one I do a lot of
business with. I could create an email to send him a copy of the order.
A more preferable approach would be to transfer to the customer the
order and order items parts which could then be imported/used to update...
|
by: Altsoft Xml2PDF |
last post by:
Altsoft announces the release of its new Xml2PDF 2007 family of
products, containing Xml2PDF Server 2007 (.NET API), Xml2PDF
Workstation 2007 and AltViewer 2007.
Altsoft Xml2PDF 2007 is a .NET-based formatting engine for converting
various page layout formats (XSF-FO, SVG, Microsoft Word, HTML) into
print-ready documents (PDF, PS, XPS, TIFF).
The new key features and improvements are:
· Significant refactoring and optimization. Xml2PDF...
|
by: tamasumalta |
last post by:
Hi,
I am adding a reference to Microsoft Word Office 11 under the COM tab.
I will do the coding required to work with word from vb.net, what
happens if the client does not have OFFICE 2003 installed? What
happens if the client does not have OFFICE installed? What happens if
Office is not installed in the location specified by the assembly? If
the client has OFFICE 2007 or OFFICE is installed in another location
will my program work?
|
by: funkeymonkey |
last post by:
Please Help !
I am problems accessing any 2003 or earlier databases using microsoft office 2007. Every time I try and open a database file I get the message 'Your Microsoft Office Access database or project contains a missing broken reference to the file 'AITOOL.DLL' version 1.0. I've had the ultimate version installed, removed it and replaced with enterprise version but I still get this message. I can create a new database fine. Any ideas...
| |
by: ARC |
last post by:
Hmmm...This is interesting. While reading info on packaging an Access 2007
runtime app, it's mentioned that a file such as, .accde (mde for 2007) will
be changed to .accdr, where the final r means runtime.
I assume by changing the extension manually yourself from the .accde to
accdr you can then simulate the runtime (instead of the old way of using the
/runtime switch). I tried this, and it works. When you double-click the
..accdr, it...
|
by: jonathan184 |
last post by:
Hi I have a perl script, basically what it is suppose to do is check a folder with files. Now the files are checked using a timestamp with the command ls -l so the timestamp in this format is checked. Now what the script does is it checks the time stamp and creates a year folder if it does not exist and then creates a month folder if it does not exist and puts the respective files in the month folders. If the files are created this month then it...
|
by: =?Utf-8?B?aW5zdHJ1Y3RvcmptbA==?= |
last post by:
I have MS Office 2003 & 2007 installed on my computer. I am just beginning to
adjust to 2007 and would like 2003 to be my default program when I open a
file. Is there a setting I can use to ensure that when I open a file created
in one of the MS programs that the file will open in 2003? Currently I have
to open the 2003 program before opening the file.
Thank you
|
by: Chuck |
last post by:
I've been having problems with Access and Excel talking to one another.
In the process of trying to add features (programs) to Access 97 I have lost
the ability to export an Access query to an external file in Excel 97 format.
It was there yesterday, but it's gone today. Other formats are also gone. I
have found the Value Pack on the original Office 97 Pro CD. It looks like I
can install drivers directly from the value pack. There is an...
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |