SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Keep row height in EXCEL

Reply
New Contributor
Posts: 4

Keep row height in EXCEL

I have a Stored Process in an EXCEL spreadsheet.

While EXCEL keeps the column width after refreshing, it doesn't keep the row height accordingly but always minimizes it to the lowest possible height.

How can I "tell" SAS to keep the manually configured row height?

SAS Super FREQ
Posts: 8,720

Re: Keep row height in EXCEL

Hi:

  This is really a question for Tech Support. The code in your stored process will make a difference in how your question is answered. And someone will need to look at all your code and the stored process metadata to see what you mean by "keep the manually configured row height". If you're trying to use a stored process to "update" an existing formatted worksheet, you might not be able to do what you want without making some changes to your stored process.

cynthia

New Contributor
Posts: 4

Re: Keep row height in EXCEL

Hi Cynthia,

thanks for the answer. But I didn't get it: yes, I'm using a Stored Process. But I haven't defined any row heights there. I've just manually adjusted the row height in EXCEL and want to keep that definition after refreshing the data.

If you're saying that I have to define the row height even in my Stored Process then I'm happy to do that but therefore I'd needed the respective code!? And I've already tried some code from "STYLE=[CELLHEIGHT=166} to defining a blank line - but this all didn't work.

So what's your proposal for a code that works for EXCEL?

SAS Super FREQ
Posts: 8,720

Re: Keep row height in EXCEL

Hi,

  I wasn't really proposing a code approach. I was proposing that you work with Tech Support. You can have an Excel sheet with a stored process get refreshed. You can also use VB to interact with the Excel sheet, as described here http://support.sas.com/resources/papers/proceedings11/012-2011.pdf -- this might be something you could do in a VB script after the stored process populates your worksheet.

cynthia

New Contributor
Posts: 4

Re: Keep row height in EXCEL

Hi Cynthia,

thanks for the answer. I have created a VB macro that changes the row height and it works properly.

But one more question: now I first have to refresh the data and afterwards run the macro manually.

Is it possible to let the "Refresh" Button refresh AND run the macro afterwards automatically?

Ask a Question
Discussion stats
  • 4 replies
  • 4174 views
  • 3 likes
  • 2 in conversation