Re: Excel (2004) Hidden rows show up in tab delimited text file
Re: Excel (2004) Hidden rows show up in tab delimited text file
- Subject: Re: Excel (2004) Hidden rows show up in tab delimited text file
- From: Paul Berkowitz <email@hidden>
- Date: Fri, 31 Jul 2009 14:21:50 -0700
- Thread-topic: Excel (2004) Hidden rows show up in tab delimited text file
Excel 2004 has some problems that were fixed in 2008. It's possible this
('get resize') is one of them. (I had tested with 2008, hadn't really
noticed you asked about 2004.) There are longer ways of getting the same
info.
The problem you're getting in 2008 must relate to the document, as you
suspect: if there's not actual corruption, then perhaps there's some cell
content that doesn't evaluate strictly as 'value' of the whole row. Do you
have any merged cells, for example? They always create problems.
Yes, you can send me the Excel file if you wish. It might take me a few days
to get to it.
--
Paul Berkowitz
> From: Bert Groeneveld <email@hidden>
> Date: Fri, 31 Jul 2009 21:29:20 +0200
> To: AppleScript-Users <email@hidden>
> Subject: Re: Excel (2004) Hidden rows show up in tab delimited text file
>
> Hello Tom, I tested Paul's script with:
> Excel 2004: It errors at line 8 with this message: Microsoft Excel got
> an error: used range of active sheet doesn¹t understand the get resize
> message.
> Excel 2008: Script runs into a timeout error. And I need to force quit
> Excel 2008.
>
> I guess it has something to do with the Excel document itself.
> Paul, can I send you the Excel file to test?
>
> Bert.
>
> On 30 jul 2009, at 23:46, Thomas Maffucci wrote:
>
>> on Wed, 29 Jul 2009 17:21:39 Paul wrote:
>>> This will replace the original worksheet with the "visibly same"
>>> content
>>> minus the hidden rows. Then save it as a tab delimited file the
>>> same way you
>>> were doing before:
>>
>>
>>> tell application "Microsoft Excel"
>>> set ur to used range of active sheet
>>> set visibleRows to {}
>>> repeat with eachRow in (get rows of ur)
>>> if not hidden of eachRow then set end of visibleRows to item 1 of
>>> (get value of (contents of eachRow))
>>> end repeat
>>> set c to count visibleRows
>>> set newRange to get resize ur row size c
>>> clear range ur
>>> set value of newRange to visibleRows
>>> end tell
>>
>>
>>
>>
>>
>> Hi Paul
>> I tried your script on an auto filtered Spread sheet of mine and I
>> got an
>> Excel crash--"Microsoft Excel got an error: Connection is invalid."
>> on the
>> first visible data row. The First Visible Title row was ok but the
>> next
>> visible data row caused this problem. Running MS excel 2008 with
>> update
>> 12.20. I was looking for something like this for some time. I sure
>> hope you
>> can fix the problem.
>>
>> Tom Maffucci
>>
>>
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> AppleScript-Users mailing list (applescript-
>> email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>> -ivc.nl
>> Archives: http://lists.apple.com/archives/applescript-users
>>
>> This email sent to email@hidden
>>
>>
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> AppleScript-Users mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
> Archives: http://lists.apple.com/archives/applescript-users
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden