How to import dataGridView in excel file with a fix position

Question

0.00/5 (No votes)

See more:

Hi!

I have a dataGridView which I want to import in my excel file. But I want the position of the gridview at the excel file in Row 14, Column 1.

I have this code:

VB

Dim Row As Integer = 14

For i = 0 To grdvwInterestBreakdown.RowCount - 1
   For j = 0 To grdvwInterestBreakdown.ColumnCount - 1
      xlworksheet.Cells(Row, j + 1) = _
         grdvwInterestBreakdown(j, i).Value.ToString()
   Next
   Row = Row + 1
Next

But it keeps on returning this error:
Object reference not set to an instance of an object.

Is there something missing in my codes or is there another way to import data with fixed position?

Thank you for the help.

Posted 27-Jul-14 16:34pm

mitchiee1226

Updated 27-Jul-14 21:59pm

v6

Add a Solution

Comments

nilesh sawardekar 28-Jul-14 1:44am

Values of Row and Col ?

mitchiee1226 28-Jul-14 2:45am

Updated the question for you. Forgot to put the declaration of Row and Col.

3 solutions

Solution 3

VB

Dim Row As Integer = 13

For i = 0 To grdvwInterestBreakdown.RowCount - 2 
   For j = 0 To grdvwInterestBreakdown.ColumnCount - 1
      xlworksheet.Cells(Row, j + 1) = grdvwInterestBreakdown(j, i).Value.ToString()
   Next
   Row = Row + 1
Next

grdvwInterestBreakdown.RowCount - 1 - Returns the last row which has no value.
When you have 20 rows in the gridview, two of the last row is null that is why it returns this error:
Object reference not set to an instance of an object

Posted 27-Jul-14 22:52pm

mitchiee1226

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Leo Chapiro · Accepted Answer · 2014-07-27T22:35:00

Solution 2

xlworksheet seems to be Nothing - check it twice!

Posted 27-Jul-14 22:35pm

Leo Chapiro

Comments

Maciej Los 28-Jul-14 4:46am

Good point! +5!

mitchiee1226 28-Jul-14 4:53am

Thanks for the help and patience. @Maciej Los

Maciej Los 28-Jul-14 5:03am

You're welcome ;)

mitchiee1226 28-Jul-14 4:53am

Thanks already solved it.

Maciej Los · Accepted Answer · 2014-07-27T21:15:00

Solution 1

Replace:

VB

grdvwInterestBreakdown(j + 1, i + 1).Value.ToString()

with:

VB

grdvwInterestBreakdown(j, i).Value.ToString()

Index of cell in Worksheet starts with 1 (one), index of gridview starts with 0 (zero) to the count of rows -1.

I'll prefer to use ADO.NET. Have a look here: Accessing Microsoft Office Data from .NET Applications[^]

Posted 27-Jul-14 21:15pm

Maciej Los

Comments

mitchiee1226 28-Jul-14 3:27am

Tried your suggestion. But returns with an error: Object reference not set to an instance of an object.

Maciej Los 28-Jul-14 3:50am

You did not. Please, read my comment to your second comment.

mitchiee1226 28-Jul-14 3:38am

If grdvwInterestBreakdown(j + 1, i + 1).Value.ToString() has no value will it return this error?? Object reference not set to an instance of an object.

Maciej Los 28-Jul-14 3:50am

Please, read my answer carefully and do exactly what i wrote.

mitchiee1226 28-Jul-14 3:57am

Sorry I do not understand ADO.NET
I have tried changing the code just as you have said in your solution but still returns the same error.

Maciej Los 28-Jul-14 3:59am

No, you dd not. Replace: grdvwInterestBreakdown(j + 1, i + 1) with: grdvwInterestBreakdown(j, i). Do you see the difference?

mitchiee1226 28-Jul-14 4:04am

Sorry I have not updated the question. But I did exactly what you said change grdvwInterestBreakdown(j + 1, i + 1) to grdvwInterestBreakdown(j, i). I have already updated the codes above.