• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Excel (2004) Hidden rows show up in tab delimited text file
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
  • Follow-Ups:
    • Re: Excel (2004) Hidden rows show up in tab delimited text file
      • From: Paul Berkowitz <email@hidden>
  • Prev by Date: Re: In a handler passed as a parameter to a handler in another script, how do I refer to top-level variables from the original script?
  • Next by Date: Re: Excel (2004) Hidden rows show up in tab delimited text file
  • Previous by thread: Re: Automating authorization dialog boxes for keychain certificate permission changes
  • Next by thread: Re: Excel (2004) Hidden rows show up in tab delimited text file
  • Index(es):
    • Date
    • Thread