Tag | excel Posts

Download and install owc11. Run AxImp on OWC11.dll, which will have been installed in the microsoft shared\web components directory (ie C:\Program Files\Common Files\microsoft shared\Web Components\11\). AxImp.exe can be found in the Windows SDK (ie, C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bin\AxIm... In Visual Studio project, drag OWC11.dll to a toolbox tab and drop the Excel component on form. Voila. When it comes deployment time, you’ll need the AxInterop.OWC11.dll. Some sample code: ...
It is tax time again. Barring a Tax audit. It means tax returns for most of us hard working Americans. The question is how much are you going to pay to have your tax forms filled out for you? Because lets face it. Who has time and the energy to do it themselves? Yes your CPA and or H and R block but they typically charge you. Then there is Turbotax but who wants to pay 30 dollars without support? Why not go free and no support. That's the true D.I.Y. way. A brilliant excel guru (I want to say developer) ...
Here is an example of a dynamic Excel spreadsheet that populates itself with data from an RSS feed of stock quote details. Each time you open the document, it will automatically reload the data from the feed. Also the feed, while open, will even auto-refresh periodically (whether or not this happens and the interval at which it happens are all configurable inside Excel). The stock quote feed itself is generated using the RSSBus yahooStockQuotes operation (pictured below) which consumes a Yahoo service. ...