Solved

Excel Interop - Problem with Autofit

Posted on 2007-12-02
4
3,732 Views
Last Modified: 2013-11-26
I am trying to use the autofit function to fit the data into the excel columns from a vb.net application.

However, i keep getting the following error when running the Autofit function:-
{"Exception from HRESULT: 0x800A03EC"}

Many thanks
Dan
Private Sub cmdExport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExport.Click

        exc = New Excel.Application()

        Dim r As Integer

        Dim c As Integer

        Dim CellsRange As Excel.Range
 

        If exc Is Nothing Then

            Console.WriteLine("ERROR: EXCEL couldn't be started")

            Exit Sub

        End If
 

        exc.Visible = True
 

        Dim workbook As Excel.Workbook = exc.Workbooks.Add

        Dim WorkSheet As Excel.Worksheet = workbook.Worksheets.Add

        For r = 0 To gridResults.Rows.Count - 1

            For c = 0 To gridResults.Columns.Count - 1

                WorkSheet.Cells(r + 2, c + 1) = gridResults.Item(c, r).Value

            Next

        Next

        For c = 0 To gridResults.Columns.Count - 1

            WorkSheet.Cells(1, c + 1) = gridResults.Columns(c).HeaderText

            WorkSheet.Cells(1, c + 1).font.bold = True

            WorkSheet.Columns(c).autofit()
 
 

        Next
 

    End Sub

Open in new window

0
Comment
Question by:DanJourno
  • 2
  • 2
4 Comments
 
LVL 25

Accepted Solution

by:
imitchie earned 500 total points
ID: 20392430
Make sure the case is exactly the same when using InterOp
0
 
LVL 25

Expert Comment

by:imitchie
ID: 20392434
In this case, it's AutoFit
0
 
LVL 5

Author Comment

by:DanJourno
ID: 20392441
Thanks for your reply.

I replaced the line:-
WorkSheet.Columns(c).autofit()
with
WorkSheet.Columns(c).AutoFit()

However, i get the same error.

Dan
0
 
LVL 5

Author Comment

by:DanJourno
ID: 20392536
Here is the solution I came to:-

I changed:
WorkSheet.Columns(c).AutoFit()
To
WorkSheet.Columns("A:Z").AutoFit()

It autofits all the columns instead of one at a time, but that doesnt both me.
Thanks for your help
Dan
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
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 simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

929 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now