Updating MS Excel tabs and specific cells

Reply
New Contributor
Posts: 3

Updating MS Excel tabs and specific cells

Hello everyone,

 

We have "client_server" environment and our goal to automate updating multiple excel tabs and specific cells using EG.

 

When i had standalone license, it was easy to do using X window but since X windows disabled on the production server, I cannot do.

 

So i tried to use ODS which gives you flexibility (start_at, tab name) but the problem is that it generates new one and overwrites existing file so I cannot update per se.

 

Does anyone have any idea how it could be resolved?

 

Thank you!

Super User
Posts: 23,663

Re: Updating MS Excel tabs and specific cells

Try the macro here:

http://www.sascommunity.org/wiki/A_Poor/Rich_SAS_Users_Proc_Export

 

It's custom written by SAS users on here.

New Contributor
Posts: 3

Re: Updating MS Excel tabs and specific cells

Thank you - it does not work, i found this paper
https://communities.sas.com/t5/General-SAS-Programming/Updated-exportxl-macro-now-available/td-p/191...

where it was referenced, tried - no results
Super User
Posts: 23,663

Re: Updating MS Excel tabs and specific cells


ak_8 wrote:
Thank you - it does not work, i found this paper
https://communities.sas.com/t5/General-SAS-Programming/Updated-exportxl-macro-now-available/td-p/191...

where it was referenced, tried - no results

What did you try and what does no results mean?

 

It is designed to work on a server as well. 

Ask a Question
Discussion stats
  • 3 replies
  • 165 views
  • 0 likes
  • 2 in conversation