|
-
Dec 23rd, 2010, 09:28 AM
#1
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.
-
Dec 23rd, 2010, 09:33 AM
#2
Re: Read Excel file except fist 14 rows
 Originally Posted by Negative0
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|