output multiple table to separate excel file

Hi there,

I have been tried to export table to separate excel files, but the extracted excel file has not the contents of the table but the contents is like

----------------------------------------------------------------------------------------------------

<div class="d9c6c81823c864b689acf3509919fbda7" width="100%"><style>
.d9c6c81823c864b689acf3509919fbda7 thead .column0 { numeric:false; }
.d9c6c81823c864b689acf3509919fbda7 .column0 { text-align:left; }
.d9c6c81823c864b689acf3509919fbda7 thead .column1 { numeric:false; }
.d9c6c81823c864b689acf3509919fbda7 .column1 { text-align:left; } so on.

could anyone let me know why the excel file don't have the actual table contents?

Output

Accepted answers

All comments

apathetichell

yes.

I know.

you are using output data to output report snippets (ie output from a table tool). you must output report snippets via render. If you have multiple tabs you must configure them using layout before render. You can google how to do this on this forum.

Sihyeon

Hi , Thank you !

I changed it by Layout and lender tool as you said, but it exported by one excel file, it need to be separated as the records numbers of table. could you teach me how to export by several excel files please?

apathetichell

The key is you must have data with the following two columns:

table (or whatever the name is of your table/report snippet)

sheetname (or whatever the name is of your sheetname)

you may also have a filename.

in your layout tool - you will allocate records in groups with VERTICAL SECTION BREAKS. when asked to configure the vertical section breaks you will use the sheetname as your vertical section break. you must group your sheetname and your filename (if present) and you must have your report as your report element be your table tool.

after your layout tool with this configuration you can use render to output to your filename.

you can render the same file one time. ever. if you re-render it you will overwrite it.

Sihyeon

Thank you again!

I made the layout configuration to vertical with section breaks, but exported into one excel file with several tabs consist of the records.

please give me more ideas please.

apathetichell

What do you want? How do you want this split? do you want multiple files? so - you came with one speciifc question - and I'm not sure where we are here. My assumption was that you wanted one file - multiple taps? If you don't want one file - multiple taps - you can drop the layout tool and use the table tool with some specific filename. you will get one/sheet/one flie/one table.

Sihyeon

I don't want multiple taps in one excel file, I want several excel files each from an table which have several records.

Please see below, there are 7 record and I want to export them in excel by each.

apathetichell

you have to have your new filename/path in a field - you can build this using formula. you send this to render. in render you change your full path to your filename. Please accept one of these as a solution as it answered your question re: why you were seeing css in excel.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703