TOPIC: From Excel to Excel Adapter

I need to take a spreadsheet that organizes data by row format and have it create a single spreadsheet from one field, the work order, and all the associated fields and append into column b of a spreadsheet. Then to the next row to column, and next row to column and so forth until the process is finished. It would be creating unique xls files based on the workorder number.

I have included the source file from which the row data should be placed into column b during the append process.

Thanks,

Herb

Hi Herbert,

I'm afraid this feature currently works only with the TextFile Adapter. Soon I’ll adapt this feature also into the Excel Adapter.

By now you can use FlowHeater Parameters instead of a real file name just for the TextFile Adapter. I've made a little example to demonstrate this.

In the example an Excel spreadsheet are read and per each "Work Order" one CSV file are written. The CSV file names are dynamical build with the help of the Set Parameter Heater .

This is great.. When it creates the files I'd like to have each field populate vertically rather than horizontally..

I have included a sample file.. Also the final destination format that the text needs to render into.


Thanks!

Hi Herbert,

Sorry I don’t understand your sample file? NOTE: If you want add more files you have to use a ZIP archive.

I guess what you want and made a new example. To do this you need a second step.

The first steps groups the data with the help of the GroupBy Heater based on the work order. A bit tricky is to put each group row from the READ side to one specific column on the WRITE side. For this you need for each column one IF-THEN-ELSE Heater to decide what row is the current group row. To count the group row you need an additional AutoID Heater with activated GroupBy option.

The second step is just the same as the first example. Read the CSV file where created in the first step and create the unique CSV files based on the work order.

Great.. I think something in my setup is incorrect.. It seems to be stuffing a lot of data that should be on a new line into LINE 1 on the initial output file.

Check it out..

Thanks for all your help!!

Herb

Maybe I can add the other file in another post..

Hi Herbert,

There are no attachments available?
You could also send the attachments via email to support [-at-] flowheater.net.

Thanks.. I think my file size exceeded your limitations.. I will email them.

Thanks,

Herb