|
|
|
|
|
Total Hits: 47 | Today: 0
|
Author: Eugene Ciloci
|
Rating:
|
|
FormulaEngine is a .NET assembly that enables you to add formula support to your application. It takes care of parsing and evaluating formulas, tracking their dependencies, and recalculating in natural order. The formula syntax and much of the engine's functionality are direct replicas of Excel ensuring a low learning curve for users. The library is licensed under the LGPL and the project is hosted here on SourceForge....
|
|
|
|
Total Hits: 1357 | Today: 0
|
|
Rating:
|
|
This article demonstrates how you can automate Excel from Visual Basic .NET to create a workbook that contains a new macro associated with a CommandBar button....
|
|
|
|
Total Hits: 1426 | Today: 0
|
|
Rating:
|
|
This step-by-step article describes how to handle Excel events from an Automation client that is developed with Visual Basic .NET....
|
|
|
|
Total Hits: 1046 | Today: 0
|
|
Rating:
|
|
Steve Roman, the author of O'Reilly's Writing Excel Macros, shows how to keep a spreadsheet up to date by pulling stock quotes from the Web.
...
|
|
|
|
Total Hits: 1962 | Today: 0
|
|
Rating:
|
|
This article demonstrates how you can automate Excel from Visual Basic .NET to create a workbook that contains a new macro associated with a CommandBar button....
|
|
|
|
Total Hits: 46 | Today: 0
|
Author: Mahesh Chand
|
Rating:
|
|
This program shows how access an access database using ADO. I have an Access 2000 database in project\bin\debug directory. My database name is mcTest.MDB. You can create your own database and copy in your project's debug directory. I am not attaching database with this code because of size problem....
|
|
|
|
Total Hits: 81 | Today: 0
|
Author: Dennis Betten
|
Rating:
|
|
First of all, I need to give some credit to Marc Brooks for publishing code which made it possible for me to make my code about a hundred times faster as it originaly was!
What does this code do:
As the title says, this code is capable of extracting all tables and it's data from any given database and export it to Excel! Every table gets it's own worksheet. I was searching the net for a program like this, but I didn't come accross any (free) versions. So I decided to write it myself....
|
|
|
|
Total Hits: 50 | Today: 1
|
Author: Ranjith Pitton
|
Rating:
|
|
Very frequently one might need to create a report in Excel. To my dismay, I found out that there is still no option to create an Excel file with some simple formatting along with formula fields etc. Hence I decided to make an assembly which accepts a Dataset and fields to be summarized. It returns an Excel which automatically adjusts width and data formatting etc....
|
|
|
|
Total Hits: 9995 | Today: 1
|
|
Rating:
|
|
This step-by-step article demonstrates how to display data from an Excel worksheet through an ASP.NET (.aspx) page by using Visual C# .NET....
|
|
|
|
Total Hits: 4874 | Today: 0
|
|
Rating:
|
|
This step-by-step article describes numerous methods for transferring data to Excel 2000 or Excel 2002 from a Visual Basic .NET application. This article also presents the advantages and disadvantages of each method so that you can choose the solution that works best for your situation....
|
|
|
|
Total Hits: 2503 | Today: 1
|
|
Rating:
|
|
This article demonstrates how to automate Excel and fill a multi-cell range with an array of values. This article also illustrates how to retrieve a multi-cell range as an array by using Automation....
|
|
|
|
Total Hits: 4455 | Today: 1
|
|
Rating:
|
|
This article discusses how you can use ADO.NET to retrieve data from a Microsoft Excel workbook, modify data in an existing workbook, or add data to a new workbook. To access Excel workbooks with ADO.NET, you can use the Jet OLE DB provider; this article provides the information that you need so that you can use the Jet OLE DB provider when Excel is the target data source.
...
|
|
|
|
Total Hits: 3071 | Today: 0
|
|
Rating:
|
|
This step-by-step article demonstrates how to display data from an Excel spreadsheet through an ASP.NET (.aspx) page by using Visual Basic .NET....
|
|
|
|
Total Hits: 2820 | Today: 1
|
|
Rating:
|
|
This article demonstrates how to create an Automation client for Excel using Visual Basic .NET. Automation is a process that allows applications that are written in languages such as Visual Basic .NET to programmatically control other applications. Automation to Excel allows you to perform actions such as creating a new workbook, adding data to the workbook, or creating charts. With Excel and other Microsoft Office applications, virtually all of the actions that you can perform manually through ...
|
|
|
|
Total Hits: 64 | Today: 0
|
Author: dynamicajax
|
Rating:
|
|
It seems quite often that I need to programmatically create an Excel spreadsheet with data from a database or some other location. I usually just create a CSV (comma separated value) file and dump the results. There are many times when it would be much nicer to create a real Excel file where I could add formatting and additional worksheets. I have a list of files that I need dumped to a spreadsheet on a regular basis with each different directory being located in a new worksheet. I went looking ...
|
|
|
|
Total Hits: 75 | Today: 0
|
Author: ketan_lohar
|
Rating:
|
|
When we develope office applications we need to automate Excel Activity.This can be achieved by VBScript. VBScript support "Excel.Application". Through which we can do comman excel taskautomatically....
|
|
|
|
Total Hits: 35 | Today: 0
|
Author: Alessandro Del Sole
|
Rating:
|
|
With the release of .NET Framework 3.0, Microsoft introduced a new file format called XPS (Xml Paper Specifications) with .Xps extension. This file format was thought as a standard for documents portability; in fact, XPS documents can be read on every system without having installed the originating application (as it is for .PDF documents).
.NET Framework 3.x fully supports this kind of documents which can be created and manipulated with extreme precision. Manipulating this kind of docume...
|
|
|
|
Total Hits: 67 | Today: 0
|
Author: Rami Atia
|
Rating:
|
|
Export from ADO.NET DataSet tables into Excel file
while developing some application I've been asked to let the user export the data from my C# application into an excel file...
|
|
|
|
Total Hits: 1316 | Today: 0
|
|
Rating:
|
|
Ok first thing first: You will need to add a COM reference to Microsoft Office 10 Object Library. (Version 9 will also work...) This is needed to use the Excel Objects, unfortunately there is no .NET version that I know of, so we have to use the COM version....
|
|
|
|
Total Hits: 80 | Today: 0
|
Author: Frank Rice
|
Rating:
|
|
Learn various ways to use Web queries to retrieve data from a Web page. This includes using static and dynamic queries as well as the Add and Find methods. Experimenting with these methods allows you to use the data on Web pages in your own applications....
|
|
|
|
|
|
