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. me too
View Tutorial          By: bellyjoy at 2010-05-07 03:14:14

2. Hi puru, The syntax is substring(int startIndex, i
View Tutorial          By: Fazal at 2008-09-12 20:17:53

3. i want to know how to read a file inside zipfile.<
View Tutorial          By: iman at 2009-11-26 12:50:21

4. Why not a simple array list of threads?
wha

View Tutorial          By: Ranadheer Machineni at 2011-08-18 12:30:35

5. i want to learn j2me basic to ....
View Tutorial          By: gopiraj at 2012-12-21 11:52:01

6. import java.io.*;
class lastindexof

View Tutorial          By: arya at 2012-11-07 08:37:59

7. IN the above program at the line in ineerclass's p
View Tutorial          By: Narasimha at 2009-10-14 06:30:26

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

9. Thankyou very much for the explanation
View Tutorial          By: Ruchita at 2010-11-11 01:16:10

10. how to execute all these five programms tell me st
View Tutorial          By: shweta at 2008-09-24 07:35:22