|
1.
Microsoft Office XML formats ? Defective by design
[^]
Case studies why Microsoft Office XML formats are broken
Languages »
XML »
General
|
Stephane Rodriguez.
|
Updated: 4 Sep 2007
Rating: 4.46/5
(109 votes)
|
|
...Pretty simple XML. Now say we want to edit cell E2 and set a constant value of
40 in place of a formula. But instead of doing that with Excel 2007
interactively, we are going to do it manually :
unzip the file
...
|
|
|
2.
BasicExcel - A Class to Read and Write to Microsoft Excel
[^]
A Class to Read and Write to Microsoft Excel
|
Yap Chun Wei
|
Updated: 6 Aug 2006
Rating: 4.62/5
(105 votes)
|
|
Introduction
More than 4 years ago, in December 2001, I posted CSpreadSheet, which is able to read and write to Microsoft Excel. That class was relatively popular. However it suffers from a few deficiencies like the necessity of a header row, inability to read cells as numbers, etc. All these...
|
|
|
3.
CSpreadSheet - A Class to Read and Write to Excel and Text Delimited Spreadsheet
[^]
A Class to Read and Write to Excel and Text Delimited Spreadsheet
|
Yap Chun Wei
|
Updated: 15 Feb 2002
Rating: 4.35/5
(52 votes)
|
|
Introduction
There are times when we wish to send our output to an
Excel file or some text delimited files like comma separated value file or tab
delimited file. This class encapsulates the functions for reading and writing to
these types of files. It was constructed with a goal of ...
|
|
|
4.
Working with MS Excel(xls / xlsx) Using MDAC and Oledb
[^]
This article simplifies your work with MS Excel (both xls and xlsx) using Oledb and Microsoft Data Access. Simple demonstration to create/modify/delete excel for both windows and web is provided.
(The Code Project Open License (CPOL))
|
Abhishek Sur
|
Updated: 9 Jun 2009
Rating: 4.61/5
(28 votes)
|
|
Contents
Introduction
Available Ways to work with Excel Workbooks
Background
Working with Excel Workbook
Anatomy of ConnectionString
Creating Excel Workbook
Getting Schema Defination
Retrieve Data By Worksheet Name
Retrieve Dat...
|
|
|
5.
Automating MS Excel Using Visual Studio .NET
[^]
This code will demonstrate how to automate and get content from a MS Excel document.
|
Vahe Karamian
|
Updated: 1 May 2005
Rating: 4.03/5
(56 votes)
|
|
Introduction
I have written this article to address requests I have been getting through e-mail on how to automate MS Excel. Most people who are looking at this article might also be interested at the following articles for automating MS Word documents. Here is the link for Automating MS Word usi...
|
|
|
6.
Excel Export Component Using XSL
[^]
This is an article on an Excel export component (using XSL and XML) in .NET.
(The Code Project Open License (CPOL))
|
Patrick.Alex
|
Updated: 22 Oct 2006
Rating: 4.19/5
(31 votes)
|
|
Introduction
I have created an Excel Export component using XSL and XML which can produce very well formatted Excel files. This doesn't require any Excel library to create Excel files without charts and macros, but if you want charts or macros in the Excel, then you have to have Excel installed o...
|
|
|
7.
Office 2007 .bin file format
[^]
Undocumented binary file formats coming in the Office 2007 timeframe
|
Stephane Rodriguez.
|
Updated: 24 Jan 2007
Rating: 4.85/5
(37 votes)
|
|
...re several additional file formats to deal with.
BIN parts appear in a number of cases. If you insert a VBA macro or an OLE object in a Word 2007, Excel 2007 or Powerpoint 2007 document, then there will be one or more BIN parts of interest. BIN parts are zip entries consisting of files with exten...
|
|
|
8.
How to export GridView to Excel, render cells, add WordArt, and fill a custom template
[^]
Export Gridview to Excel, render cells, add WordArt, and fill a custom template.
|
Sacha Barber
|
Updated: 9 Nov 2006
Rating: 4.33/5
(29 votes)
|
|
Introduction
There is not really much to say about this article except that it shows how to automate Microsoft Excel through C#. More precisley, what it shows is how to export a C# GridView/DataView to Excel, and how to format the resultant Excel spreadsheet cells. It also shows how to place Wo...
|
|
|
9.
Creating Excel Charts Dynamically from Database, using VB.NET
[^]
An article on generating an Excel sheet with different charts, based on the data in the sheet, and then emailing it.
|
Malik Nasir
|
Updated: 12 May 2006
Rating: 4.17/5
(38 votes)
|
|
Introduction
Exporting data from a DataTable to Excel, with charts for comparisons and analysis, is one of the most common tasks for reporting and presentations. We can develop such files by using DataGrids or some other reporting tools, but by using VBA, we can generate fully formatted automat...
|
|
|
10.
Opening and Navigating Excel with C#
[^]
Introduction to manipulating Excel with C#.
(The Code Project Open License (CPOL))
|
Narsters
|
Updated: 2 Oct 2003
Rating: 4.29/5
(105 votes)
|
|
Introduction
This is a short introduction to opening an existing Microsoft Excel spreadsheet using Visual C# .NET. The computer must have Excel installed on the system for this code to run properly. The Excel assembly is used to open and manipulate Excel spreadsheets.
Code Explanation
First, t...
|
