DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

2
kicks
Using ADO.Net and Com Interop to read, modify and output from Excel
submitted by BronwenZ 10 months, 16 days ago

soulsolutions.com.au — Today I was asked to do what seemed like a fairly simple task: Take an Excel 2003 file, add a couple of columns of data and save to a new Excel file programattically. I haven't done any coding Excel for AGES so this i what I did. To read in the file and add the extra columm and data I did the following: Used OleDBConnection to grab the data from the sheet into a dataset Added some columns to the dataset did some processing and set the data in the dataset with the following code:

Add a comment add a comment | category: | Views: 2 | Get KickIt image code
tags: , , , | tag it

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
BronwenZ - manguiver

Comments:

No comments so far




information Login or create an account to comment on this story
 

Sponsored Link: www.carlist.ie

Search:

Ads via The Lounge

You are the editor:
View upcoming stories
Submit a story
How else can I help?
Earn money
Tags: all tags - your tags