SOLVED
Write to named table in Excel (.xlsx)
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ktipping
7 - Meteor
‎07-28-2022
08:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have seen posts about writing to named ranges ($A1:B6) in excel but not to named tables ($int_rate_table) in excel, ex: [File Path]\[Folder]\[File].xlsx|||[Sheet Name]&[Table Name]. Has anyone had success with this? Also, there are cells below the table that are currently in use so it would be awesome if the table simply inserted rows at the bottom and pushed everything else down.
Solved! Go to Solution.
Labels:
- Labels:
- Output
2 REPLIES 2
Robin_McIntosh
11 - Bolide
‎07-28-2022
09:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎08-04-2022
11:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Robin_McIntosh Not ideal... but worth a shot, thanks!
