Split Excel spreadsheets into multiple spreadsheets

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?

Yes, I want you to refine this.
Thank you.work.morph (7.9 KB)

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:

  • Export done into two different spreadsheets

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:

  • Added synchronization
  • Export into two sheets of the same spreadsheet

work.morph (8.0 KB)

As it wasn’t clear to me what the problem was - a few suggestions:

  • Search the forum before posting a question - it may have already been answered
  • If you’re getting an error - post a screenshot with this error, or at least include in your post the error message

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.

image

I try so but it doesn’t work well.
I send it.
I want you to refine it.
Thank you.

work.morph (8.0 KB)

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:

  1. Create the file called output.xlsx (with Excel)
  2. Create 2 tabs - one MSA and other TSSSA (With Excel)
  3. Then use the Replace sheet in existing file for both actions on export (Easymorph)

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