Excel (2004) Hidden rows show up in tab delimited text file
Excel (2004) Hidden rows show up in tab delimited text file
- Subject: Excel (2004) Hidden rows show up in tab delimited text file
- From: Bert Groeneveld <email@hidden>
- Date: Thu, 30 Jul 2009 00:11:25 +0200
Hi, I have a stay open script (headless script, on idle script,
whatever you call it) that every 30 seconds watches an in-folder for
available Excel files. As soon as an Excel file is available, the
script tells Excel to open it and save it as a tab delimited text file
in an out-folder for further processing. So far so good. But:
Sometimes (unpredictable) the Excel file has a lot of invisible rows
(the Excel operator has sometimes turned on the autofilter option that
hides thousands of rows). The hidden rows are of no interest to me.
I'm only interested in the (for example one hundred) rows that I can
see. But when I tell Excel to save as tab delimited text file,
unfortunately all the invisible rows show up in the text file. And all
I want is a text file that contains only the visible rows. Can anyone
help by telling me how to work around this. It would be nice if
someone could post example code. I'm losing too much time on this.
Bert.
_______________________________________________
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