Results 1 to 16 of 16

Thread: Read Excel file except fist 14 rows

Hybrid View

  1. #1
    PowerPoster 2.0 Negative0's Avatar
    Join Date
    Jun 2000
    Location
    Southeastern MI
    Posts
    4,367

    Re: Read Excel file except fist 14 rows

    They have a free trial, so you might be able to quickly proof it out to see if it works. If it does, then you can suggest spending $900 now or taking two weeks to see if you can write a workaround.

    I've never had good luck with the OLE connection and an excel file that had anything more than really simple tabular data in it.

    Technically you might be able to code something that does use excel and technically works, even though it is against the Microsoft recommendation. I have seen people do this and have it work for them.

    Another option might be some sort of automation using OpenOffice, but I haven't looked into what kind of Automation they offer in a few years.

  2. #2

    Thread Starter
    PowerPoster
    Join Date
    Apr 2007
    Location
    The Netherlands
    Posts
    5,070

    Re: Read Excel file except fist 14 rows

    Quote Originally Posted by Negative0 View Post
    They have a free trial, so you might be able to quickly proof it out to see if it works. If it does, then you can suggest spending $900 now or taking two weeks to see if you can write a workaround.

    I've never had good luck with the OLE connection and an excel file that had anything more than really simple tabular data in it.

    Technically you might be able to code something that does use excel and technically works, even though it is against the Microsoft recommendation. I have seen people do this and have it work for them.

    Another option might be some sort of automation using OpenOffice, but I haven't looked into what kind of Automation they offer in a few years.
    Unfortunately I think me spending two weeks will be cheaper then spending 900 bucks for them

    OpenOffice might be a good idea, I'll check that out.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width