Solved

need to start table dump on row 8 column A

Posted on 2008-06-18
5
207 Views
Last Modified: 2013-11-26
Hi!

I want to add a company jpg on column a row 1 and title. Therefore I need to start my dataset dump on row 8 and comlumn A.

The code I have now looks like this:



How do i modify accordingly?

THanks!

Tammy
If CheckBox1.CheckState = CheckState.Checked Then
 
 
                    connectionString2 = "data source='" & ComboServers.Text & "'; Initial catalog=master;Integrated Security = True;"
                    cnn2 = New SqlConnection(connectionString2)
                    cnn2.Open()
                    sql2 = "Select * from master.dbo.temp_Filter_by_error where [Error Description] in ('Could not index file') order by [fileset ID],[Doc ID]"
                    Dim dscmd2 As New SqlDataAdapter(sql2, cnn2)
                    Dim ds2 As New DataSet
                    dscmd2.Fill(ds2)
 
 
                    .Worksheets(3).Select()
 
 
                    CType(Excel.Workbooks(1).Worksheets("Sheet3"), Microsoft.Office.Interop.Excel.Worksheet).Name = "Index Error Report"
 
                    Dim m As Integer = 1
                    For col = 0 To ds2.Tables(0).Columns.Count - 1
                        .cells(1, m).value = ds2.Tables(0).Columns(col).ColumnName
                        .cells(1, m).EntireRow.Font.Bold = True
                        m += 1
                    Next
                    m = 2
                    Dim n As Integer = 1
                    For col = 0 To ds2.Tables(0).Columns.Count - 1
                        m = 2
                        For row = 0 To ds2.Tables(0).Rows.Count - 1
                            .Cells(m, n).Value = ds2.Tables(0).Rows(row).ItemArray(col)
                            m += 1
                        Next
                        n += 1
                    Next
 
 
                End If

Open in new window

0
Comment
Question by:jtammyg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 39

Expert Comment

by:nutsch
ID: 21818592
Change line 18 to
                    Dim m As Integer = 8
and line 24 to
m=9
0
 

Author Comment

by:jtammyg
ID: 21818752
That's not what i need.

I need to dump the data in row 8......not column 8

Thanks!

Tammy
0
 
LVL 39

Accepted Solution

by:
nutsch earned 100 total points
ID: 21818804
My apologies, I got confused since the code uses m as a row once, then as a column. Here is the updated code from line 18 to 33
                    Dim m As Integer = 1
                    For col = 0 To ds2.Tables(0).Columns.Count - 1
                        .cells(8, m).value = ds2.Tables(0).Columns(col).ColumnName
                        .cells(8, m).EntireRow.Font.Bold = True
                        m += 1
                    Next
                    m = 9
                    Dim n As Integer = 1
                    For col = 0 To ds2.Tables(0).Columns.Count - 1
                        m = 9
                        For row = 0 To ds2.Tables(0).Rows.Count - 1
                            .Cells(m, n).Value = ds2.Tables(0).Rows(row).ItemArray(col)
                            m += 1
                        Next
                        n += 1
                    Next

Open in new window

0
 

Author Comment

by:jtammyg
ID: 21818880
Thank you so much Nutsch!!!!!

works perfect :-)
0
 
LVL 39

Expert Comment

by:nutsch
ID: 21819469
Glad to help.

Thomas
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question