Posts

Showing posts with the label MS office

Extending Excel with .NET

Image
Introduction Using 'Excel' as search keyword results in almost 700 CodeProject articles. Admittedly quite a few of these articles address Excel at best tangentially, but none of the ones actually focussing on Excel 'seem' to have addressed a very simple question: how to create menu items in the Excel application that allow the user to interact with code written in .NET without resorting to VSTO or the development of add-ins. This article is intended to fill this void. I intend to provide an easy way to create and interact with custom Excel menu items without having to resort to Microsoft's Visual Studio Tools for Office (VSTO) or Visual Basic for Applications (VBA). This approach takes advantage of the .NET platform and the VB and C# object models for MS Excel which have been illustrated in a number of previous CodeProject articles. In the interest of space I am referencing only two that I found particular helpful. Modifying MS Excel's menu is rat...

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. See full detail: http://www.c-sharpcorner.com/UploadFile/vimalkandasamy/Excel03092009063106AM/Excel.aspx