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. When run this code then I am getting a blank page.
View Tutorial          By: Paritosh Chandra Dey at 2013-08-14 08:55:42

2. sach a lovely exmpl for bgnrs thanks
View Tutorial          By: aaditya at 2013-01-13 08:05:03

3. Good.understand
View Tutorial          By: Selva at 2009-12-29 23:27:29

4. This works perfect for me. The only big problem is
View Tutorial          By: Eric at 2014-11-20 03:49:19

5. place both comm.jar and javax.comm.properties in l
View Tutorial          By: Rania at 2010-09-14 19:52:49

6. Can u show how to do text to speech with servlet.
View Tutorial          By: Rotika at 2011-01-23 20:54:40

7. Hi Friends.... Can you please send the working ver
View Tutorial          By: shafi at 2010-02-18 08:28:49

8. Nice article
View Tutorial          By: Chakravarthy at 2009-06-09 23:29:09

9. Thanks Man , You are Genius i have been looking fo
View Tutorial          By: hamza Ouni at 2015-02-22 13:38:02

10. Hi all
Can you please tell ,how to recei

View Tutorial          By: Nanthini at 2011-09-07 16:48:04