Skip to main content

Programmatically create excel


Plan is to share different ways to export data to excel . I will be writing this topic  in installments. 

There are many ways to create an Excel file/ export data to excel. I will list down few , later will post samples of each and then will try dig little more and share the pros and cons of them. Let us see how far I go in this ...

1. Create csv file and open in excel
2. Use oledb to create excel
3. Use office inerop / vsto
4. Use office open xml

Comments

Popular posts from this blog

How to accept outlook meeting invite via keyboard shortcut ?

There are two ways you can accept a meeting request. 1. when you are browsing list mail (and invite isn't opened) 2. wen you have opened the invite

Learning Angular With Baljeet : Day 01

I would be posting a series on learning angular js

I would be posting small todos, if you follow along you should be able t

To Beging with

1. you need to install Node.JS (https://nodejs.org/en/)
2. Node.js would get you npm also
3. Download WebStorm as Editor
4. Download Angular CLI command npm install -g @angular/cli)
5. Create new angular app (command d:\RnD\Angular\> ng new HelloAngular
7. open your newly created project in browser by command ng serve --open

one pending todo here is overview of the angular project basic terminolgies
app --> module --> component
every component would have --> .ts , .css, .htmls , .spec file

- Baljeetsingh

Tips 'n' Tricks : SVN : Visual Studio Plugin : AnkhSvn

Now we can access SVN from Visual Studio :) ,