TM1 Forum

hi,

i have an client who want import excel file to TM1 and even chose what worksheet to import.

i just wondering that TM1 work well with excel since beginning with Macro Perspective and they have surely a client who want to import Excel file.

But why they dont make that?

As i know, TM1 contributor can import Excel file, why not TI ?

i found a video on Youtube show they can make something work with TM1 web, any idea how they do it?

https://www.youtube.com/watch?v=r2COAA8Rq78

I just very curious! thanks any help !!

cross-posted in IBM community

https://community.ibm.com/community/use ... 4eda43146b

You can create a PowerShell script that is called from the Prolog tab, to which you pass the right parameters.
PowerShell opens Excel in the background and does a save as command, then close the source file and stop the Excel instance.
Or use similar solutions like Python or VB or whatever talks to Excel.

Thank a lot for your repose, can you give me 1 exemple of powershell script? Or python?
I can not use VB because as i know, VB can not be called by tm1 , right?

Wim Gielis wrote: ↑Fri Oct 07, 2022 11:13 pm You can create a PowerShell script that is called from the Prolog tab, to which you pass the right parameters.
PowerShell opens Excel in the background and does a save as command, then close the source file and stop the Excel instance.
Or use similar solutions like Python or VB or whatever talks to Excel.

mrdauduong wrote: ↑Sat Oct 08, 2022 2:59 am Thank a lot for your repose, can you give me 1 exemple of powershell script? Or python?

Did you know that you can use Google for information ? E.g. tm1 call powershell script

mrdauduong wrote: ↑Sat Oct 08, 2022 2:59 am I can not use VB because as i know, VB can not be called by tm1 , right?

Why not ?

thank for your reponse, i will try to find a way to do it

Wim Gielis wrote: ↑Sat Oct 08, 2022 7:36 am

mrdauduong wrote: ↑Sat Oct 08, 2022 2:59 am Thank a lot for your repose, can you give me 1 exemple of powershell script? Or python?

Did you know that you can use Google for information ? E.g. tm1 call powershell script

mrdauduong wrote: ↑Sat Oct 08, 2022 2:59 am I can not use VB because as i know, VB can not be called by tm1 , right?

Why not ?