OpenXML SDK 2.0: Export a DataTable to Excel Very good article and download project http://lateral8.com/article... The DocumentFormat.OpenXml.dll is registered in the GAC when the SDK is installed so it doesn't physically copy it to your project's output folder by default when you build the application. If you select the option to Show All Files in Visual Studio (Project | Show All Files), you'll see a References node appear in your VB.NET project...

ASP.NET Export n GridViews to Excel Thanks to awesome article by Matt Berseth http://mattberseth.com/blog... http://forums.asp.net/t/152... //Web Page Call to ExcelExport Class protected void lnkExport_Click(object sender, EventArgs e) { //creating the array of GridViews and calling the Export function GridView[] gvList = new GridView[] { gvPlateList, gvPlateDetails }; ExcelExport.Export("Deliver... gvList); } //ExcelExport Class using System;...

DataGridView CSV Editor · Load CSV File into Dataset -> DataGridView · Show cells with Validation Errors with backcolor & tooltip · Right-Click cell to correct cell via tooltip · Restrict KeyPress Keys · Show cell as “edited” via cell backcolor Public Function GetCSVDataTable(ByVal filePath As String) As DataTable ' The dataset to return Dim dt As DataTable = Nothing Try '--------------------------... ' Create "Excel Like" Column Headers '--------------------------...

original article: http://www.vbforums.com/sho... Public Function Convert(ByVal mFile As String, ByVal mTablename As String, ByVal delimiter As String) As DataSet ' The dataset to return Dim ds As New DataSet ' Open the file with a stream reader Dim sr As New StreamReader(mFile) ' Split the first line into the fields and add to string array called columns Dim columns As String() = sr.ReadLine().Split(delimit... ' Add the new Datatable to the DataSet ds.Tables.Add(mTablename)...

C# Excel Export from ASP.NET Page ----------------- --web Page - ExcelExport.aspx ----------------- <%@ Page Language="C#" MasterPageFile="~/MasterPag... AutoEventWireup="true" CodeFile="ExcelExport.aspx.cs" Inherits="Forms_Techniques_... Title="Untitled Page" %> <asp:Content ID="Content1" ContentPlaceHolderID="Conte... Runat="Server"> <asp:GridView ID="GridView1" runat="server"> </asp:GridView> <br /> <asp:LinkButton ID="LinkButton1" runat="server"...

Option Strict On Option Explicit On Partial Public Class myWebForm Inherits System.Web.UI.Page Dim _objDatasetToExcel As New DatasetToExcel() Dim _showExcel As Boolean = False Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Try '--------------------------... 'build showEnlargeButton '--------------------------... If Request.QueryString("showEx... Is Nothing Then...

protected void lnkBuildExcelReport_Click(o... sender, EventArgs e) { //-------------------------... // //-------------------------... long claimId = long.Parse(this.lblClaimId.... //-------------------------... // //-------------------------... DataSet ds = new DataSet(); //-------------------------... // //-------------------------...

using System; using System.Data.OleDb; using System.IO; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace Excel_Payment_Detail_Report... { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void btnGetFile_Click(object sender, EventArgs e) { //Stream myStream; //-------------------------...

Export a DataSet to Microsoft Excel without the use of COM objects original article: http://www.codeproject.com/... private void exportToExcel(DataSet source, string inFileName) { try { //-------------------------... //replace GetExecutingAssembly().GetN... with inFileName //-------------------------... string fileName = System.Reflection.Assembly.... string...

Understanding the Excel Object Model from a .NET Developer's Perspective http://msdn.microsoft.com/l