Saturday, July 11, 2009

An easy way to view reports through Excel

Generally, we are in need to generate reports while handling financial or any other data. The statistics or Reports must be available for downloading. And reports must be in file format which is very easy to understand. So generally, we choose Excel file type to generate Report.

In this Article, We are going to see an easy way of handling an Excel file using StreamWriter & StreamReader for report generation only

Creation of an Excel Document

We can easily create an Excel document using StreamWriter class. We must specify the type of Encoding in the creation of file. And while writing we have to separate data in excel file using tab.

This tab will arrange data into cells correctly. So when we open, it will show you a perfect Excel document.

No comments: