All,
I have an Excel spreadsheet with the auto filter option set. In Javascript, I would like to open the Excel spreadsheet ( in JS, ************('filename', 'windowname') and pass a specific country name. The resulting behavior would be for Excel to present only those rows that match the specified country. Does Excel support passing a filtered column value and present the rows as indicated above? If so, How? Any example code would be greatly appreciated.
I have an Excel spreadsheet with the auto filter option set. In Javascript, I would like to open the Excel spreadsheet ( in JS, ************('filename', 'windowname') and pass a specific country name. The resulting behavior would be for Excel to present only those rows that match the specified country. Does Excel support passing a filtered column value and present the rows as indicated above? If so, How? Any example code would be greatly appreciated.
