Why can I not open large files in Excel? What is the maximum limit to be able to open a file in Excel?

If you open a very large file in Excel it might not open up fully. For instance, I tried opening up a .csv file of 480MB and which had 2.2M records it would not open up completely. The reason is Excel has a limit of 1,048.576 rows and 16, 384 columns it can have in a file.  

Why am I not able to Move to the Begin of Stream using the Seek() Method in StreamReader?

As you use StreamReader to manipulate Text files and read one line at a time using Readline() Method you might come across a situation where you are somewhere in the middle of the Stream say on the 5th line and want to go back to the begin of the Stream. You can do that using the Seek Method on the BaseStream of the StreamReader as in this example.

How to read Text from multiple files and write it to a single file using StreamReader and StreamWriter in C#?

Here is an example of using StreamReader and StreamWriter class in C# to Read a number of text files from the source location and writing the contents of all the text files into a single Final Large file.