MS-EXCEL
Import data from Excel in Asp.Net
There are various ways to import data from an Excel file to a Sql Server database table. We can use either a “DataSet” to import data into a table or by using the “SqlBulkCopy” class ...Export data to Excel in Asp.Net – All Excel versions
Data can be exported to other file formats using various ways. We are not talking about printing the data, but to export it to an excel file, word and even text files, so the files can be emailed ...January 15, 2013Continue Reading.Edit / Modify excel file using Vb.Net
Data in an Excel file can be manipulated using Vb.Net without even opening the file. With few steps this can be done. Previously we have created Excel file from Vb.Net with auto formating technique ...December 25, 2012Continue Reading.Export data to Excel in Vb.Net with Auto format technique.
Data can be exported to an excel sheet in Vb.Net using Microsoft.Office.Interop.Excel namespace. Though it’s a classic example, exporting data into an excel file can be useful when you want to share ...December 20, 2012Continue Reading.