In this tutorial we can see how to find the used area in a worksheet and the last data row in Excel. For finding last row we are using WorkSheet.UsedRange. It will return the last
Read tutorial ↗To open or edit an Excel 2007 worksheet in you have to add Microsoft 12.0 Object Library in your project. From the following pictures to show how to add Excel reference library in
Read tutorial ↗Excel file can be automated or worked upon by Auomation to Excel 2007,It can be done in two ways through Excel Object Model and using Microsoft Jet Engine to connect to Excel, thro
Read tutorial ↗BinaryReader is used to read primitive types as binary values in a specific encoding stream. This object works at lower level of streams, it also works stream objects that provide
Read tutorial ↗TextWriter is similar to TextReader we can write a given content in a file at one strench in to a file using it. The following sample source showing how write in a file using TextW
Read tutorial ↗StreamReader and StreamWriter are actually derived from Textreader and TextWriter, they are another way to read and write to a file but they are not stream classes.
Read tutorial ↗The FileStream class allows us to move data to and from the stream as arrays of bytes, a filestream actually symbolizes a a file in a system. We operate File using FileMode in File
Read tutorial ↗File class is using for the File operations in VB.NET. We can create, delete, copy etc. operations do with File class.
Read tutorial ↗Directory class in .net is of static nature we need not have to instantiate the class, and can direcly call methods in the class directly from the directory class.
Read tutorial ↗To check the whether the given string ends with specified string we use EndsWith method in String class
Read tutorial ↗The string split function returns array of strings which are the splits of the given string it is delimited by the given System.Char array
Read tutorial ↗Substring is an interesting method of string class it returns a string that is a substring of the given string. It begins from a given index and extends up to the specified length
Read tutorial ↗