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. NICE EXPLANATION >>>THANK UUUUUU
View Tutorial          By: PraVeen at 2012-07-05 10:12:25

2. This solution worked like a charm, thank you. I ha
View Tutorial          By: budfox at 2014-07-15 14:25:16

3. how to java program run in system and how to open
View Tutorial          By: safeek at 2012-10-20 06:54:38

4. hai vij i am also having error what sol u used to
View Tutorial          By: uma at 2008-05-30 01:05:39

5. Could anyone please forward me the working version
View Tutorial          By: Stephen Machipi at 2010-09-13 06:41:08

6. Tnx. Very fast learning i think.
Just make

View Tutorial          By: mahdi at 2011-07-09 20:20:39

7. very cool you said it! many thanks it's really coo
View Tutorial          By: ArAsh at 2008-12-11 06:41:13

8. I want to know more about Java Garbage collection,
View Tutorial          By: Prosenjit Kundu at 2010-05-08 09:42:40

9. very good explanation,very good examples..
View Tutorial          By: sra1 at 2011-11-14 08:30:47

10. Dear All, I am getting the following exception for
View Tutorial          By: Protik Basu at 2008-10-31 05:30:36