Page 1 of 1

Upload Excel-Sheets to TM1 Web

Posted: Wed Apr 06, 2016 4:44 pm
by MG03
Hello everybody, we are working on a reporting platform based on TM1 Web. Currently we are looking for an opportunity to upload several Excel-Sheets to the Server simultaneously. The upload of single Sheets is no problem, but due to the large amount of Sheets, it would be helpful to find another way. I am thankful für any help. With regards

Re: Upload Excel-Sheets to TM1 Web

Posted: Wed Apr 06, 2016 5:29 pm
by tomok
I assume you are talking about publishing Excel workbooks to the Applications folder? The answer is no. However, you may be able to write a VBA macro to assist with this. The reason I say "may" is because the Perspectives add-in does not expose the publish function as something that can be called. You would have to do some digging inside the add-in menu to see if you could copy what the menu does. I'm not sure you can do this. Never tried it.