Thank you for the good reply.
As you know, I am a beginner for EasyMorph.
I tried to solve the problem but It’s not so easy for me.
I think it’s no problem for you and I hope you sending answer of the problem.
Kind Regards.
Newday
Thank you for the good reply.
As you know, I am a beginner for EasyMorph.
I tried to solve the problem but It’s not so easy for me.
I think it’s no problem for you and I hope you sending answer of the problem.
Kind Regards.
Newday
How exactly did you try to solve this problem in EasyMorph and what didn’t work? Can you post your project?
OK, I see that you’ve done almost everything. But the both tables are exported into the same file (output.xlsx). If you want to export into different spreadsheets you should specify different file names.
See below your project reworked:
work.morph (8.0 KB)
Thank you.
I want to have two sheets, MSA&TSSSA in only one file.
How can I do this?
Use the Synchronize action to avoid simultaneous export into the same spreadsheet. This question was answered in this topic: Unable to update two worksheets in the same workbook from two easy morph table
See below your project reworked:
work.morph (8.0 KB)
As it wasn’t clear to me what the problem was - a few suggestions:
Thank you.
I have some more questions.
I want to output file as A.
I send output file I want.
Please help me more.Book1.xlsx (10.3 KB)
I’m not sure I understand the question. Can you elaborate?
I want to make the output file like A.
I sent you output file I want.
I send again.
Book1.xlsx (11.9 KB)
EasyMorph doesn’t do Excel formatting. Although, it can replace sheets in an existing Excel report. Make a sheet that contains only data and another sheet that has a formatted table with the same data linked to the data sheet using Excel references. Use EasyMorph to replace the data sheet.
Thank you.
How can I replace the data sheet by using EasyMorph?
I hope you helping me about it.
Sorry.
The “Export into Excel spreadsheet” action has a mode for replacing sheets in existing files.
I try so but it doesn’t work well.
I send it.
I want you to refine it.
Thank you.
I believe my instructions were clear. But you don’t follow them.
Can’t help you more, sorry.
Sorry. I sent old file. I will send it again.
I need more help from you.
Please help me.
I am really beginner for this tool.work.morph (8.0 KB)
Please help me.
Hi @Newday
My suggestion is as follows:
I find that it works well.
To get the formatting correct, follows Dmitry’s advise as provided above.
R
Thanks for the reply.
Can you give your workspace that works well please?
My workspace doesn’t well.
I send it.
output.xlsx (9.2 KB) work.morph (8.3 KB)
And this is I want.
output.xlsx (13.9 KB)
Hi Newday
As indicated by Dmitry, you need to format it in Excel.
The morph file is correct and complete.
Use the template I started and complete it.
Copy the headings the way you want it and copy the formulas in Row 3 down.
It will work as follows: EM export to TSSA and MSA
You format the formatMSA and FormatTSSA which link to the MSA and TSSA
R
Regards
Rykie