Comment on Tutorial - Insert cell data in an Excel file using OLEDB in VB.net By Issac



Comment Added by : Hendrik Jabs

Comment Added at : 2009-12-10 02:46:13

Comment on Tutorial : Insert cell data in an Excel file using OLEDB in VB.net By Issac
Hi,
I've tried this but got a problem. First I run a 'create table'- command to define my columns and datatypes in the excel file.
Then I tried to insert a datatable to the excel file by running an 'insert'- command for each row of the datatable. The excel- sheet only contains the header and the last row of my datatable after that. It seems that the insert command starts to write always in the second row.
How can I solve that problem?
cu


View Tutorial



Subscribe to Tutorials

Related Tutorials

Program using concept of byte long short and int in java

Update contents of a file within a jar file

Tomcat and httpd configured in port 8080 and 80

Java File

Java String

Count number of vowels, consonants and digits in a String in Java

Reverse a number in Java

Student marks calculation program in Java

Handling Fractions in Java

Calculate gross salary in Java

Calculate average sale of the week in Java

Vector in Java - Sample Program

MultiLevel Inheritance sample in Java

Multiple Inheritance sample in Java

Java program using Method Overriding

Archived Comments

1. read and write methods given here are for a file w
View Tutorial          By: Tavva Yaswanth at 2012-10-28 08:02:10

2. class loop8
{
public static voi

View Tutorial          By: ankush singh at 2011-11-04 16:26:36

3. well written hog .good going
View Tutorial          By: Rajesh at 2010-08-17 03:38:05

4. Hi, it looks great!
I'm just starting with

View Tutorial          By: Bertrand at 2013-04-28 19:20:42

5. Great tutorial about ArrayList .It's a very great
View Tutorial          By: umesh sharma at 2009-05-14 20:40:39

6. Actually in gallery example the images can be move
View Tutorial          By: santu at 2013-02-16 12:40:29

7. Great Thanks
View Tutorial          By: seedimani at 2009-09-16 01:27:26

8. This example has helped me a lot.! kudos to the wr
View Tutorial          By: Disha Sareen at 2014-12-24 09:30:12

9. more daitlled coding for me
View Tutorial          By: fred at 2008-07-15 05:56:49

10. Well explained. Example clear out the diff
View Tutorial          By: sonam at 2014-06-25 19:05:20