Support multi-sheet workbook exports

[nmggithub]

This may not be the right place to submit it but I would like to see an enhanced export function by making it possible to create multi-sheet workbook exports, with each sheet containing rows from the same project but using different facets and filters.

[tfmorris]

Thanks for the suggestion. Do you have thoughts on how the user would specify these various filters and facets? Currently OpenRefine only has a single set of facets which are active at a time.

[nmggithub]

You would still have only one set active at a time. You would just tell the program what facets to use without actually activating them. The activation process takes place after you hit export. I'm not a coder (at least in this context) but I what I would think it would be best if it created sheet/tab 1 activated the facets and filters, "saved" the sheet/tab, created sheet/tab 2, activated the facets and filters set for that sheet/tab, and so on. An example where this would be useful would be if you have, say, a "category" tab, and wanted to create a workbook, with tabs/sheets, one for the rows within each category. This way they only have to open the worksheet, and not go into Refine and then have to go through all the facets and filters. And it saves the user time from having to export each category as a separate workbook, and then have to combine them.

[sutt]

@nmggithub Could you please elaborate with an example?

@tfmorris I have started working on multi-sheet export. Can the controls for this go in Custom Tabular Exporter GUI?

[nmggithub]

http://www.extendoffice.com/product/kutools-for-excel/excel-split-data-into-multiple-sheets.html Here is an example of what I want it to do. This example takes place in Excel, but I want it to take place in the export in Open Refine. I doesn't have to be based off one column. It can be based off of several columns.

[sutt]

@nmggithub This is very helpful, thank you.

I think I'll only be able to add a one-column-at-a-time solution for though.

[nmggithub]

What do you mean by that?

On Thu, Jul 31, 2014 at 5:18 PM, sutt notifications@github.com wrote:

@nmggithub https://github.com/nmggithub This is very helpful, thank
you.

I think I'll only be able to add a one-column-at-a-time solution for
though.

—
Reply to this email directly or view it on GitHub
#892 (comment)
.

[sutt]

per the example: You can do either:

• Sheets for name: Workbook { Sheet_Kelly, Sheet_Carter, etc... }
  or
• Sheets for Course: Workbook {Sheet_Chemistry, Sheet_English, etc...}

But it won't be possible to do:
Workbook {Sheet_KellyChemistry, Sheet_KellyEnglish, Sheet_CarterChemistry, Sheet_CarterEnglish...etc}

Is this still worthwhile?

[nmggithub]

Yeah. It was just a suggestion to do it with more than one column.

[sutt]

OK, maybe multi-column will be possible...can't be sure yet. I'm just getting started with OR myself.

[tfmorris]

@sutt Missed your question earlier, but the Custom Tabular Export dialog sounds like a reasonable place to put controls for this.