Writing macros in Excel using VBA is not every ones cup of tea. However, these are useful piece of code, which can make the Excel sheet more dynamic. Often, we come across a situation where we have to ...
We know how important Excel is and how much it has influenced us in our daily professional life, with its easy to use tools. Whether you are a beginner, a pro, or the head a company, Ms-Excel has ...
The Excel “FSO” also known as the “File System Object” has methods to move, create, alter and delete files and folders in a machine. Using couple of its features in this article, we will see how to ...
Excel is a very useful application for managing data on a spreadsheet. Its VBA tools and functions have made it more dynamic and appealing. Macros can make the contents in the file more meaningful and ...
Many organizations around the world rely on Microsoft Excel to manage their business data and other day to day work. Excel is one of the primary means to maintain data of all sorts. A Dropdown lists ...
One of simplest way to export data to an excel file is by using classes like “StringWriter” of “System.IO” namespace and “HtmlTextWriter” of “System.Web.UI” namespace in “.Net”. Data extracted from a ...
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 ...
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 ...
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 ...
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 ...
