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
import Excel file
-
mrdauduong
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
import Excel file
Last edited by mrdauduong on Mon Oct 10, 2022 7:44 am, edited 1 time in total.
-
Wim Gielis
- MVP
- Posts: 3239
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: import Excel file
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.
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.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
mrdauduong
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
Re: import Excel file
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?
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.
-
Wim Gielis
- MVP
- Posts: 3239
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: import Excel file
Did you know that you can use Google for information ? E.g. tm1 call powershell scriptmrdauduong 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?
Why not ?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?
-
mrdauduong
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
Re: import Excel file
thank for your reponse, i will try to find a way to do it
Wim Gielis wrote: ↑Sat Oct 08, 2022 7:36 amDid you know that you can use Google for information ? E.g. tm1 call powershell scriptmrdauduong 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?
Why not ?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?